Walter Meester
HoogkarspelNetherlands
Michel,
There is something wrong in the execution plan. Are you executing this command from within a stored procedure? If so, add the WITH RECOMPILE option to the execution of the stored procedure
Walter,
>Some may have followed some related threads in the SQL Server forum recently where I have observed that specific things do happen when the SQL command is executed from the ASP.NET Web site but not from SSMS. I do have some stats on that today. There is definitely something else being executed such as verifying the data and so on. Because when I execute the same SQL command from the site, it takes 56 seconds. But, when I execute it from SSMS, it is a flash. I have the result instantly. There is only one record and all the indexes are properly created.
>
>So, could this be related to the verification on constraints or something in regards to that?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only