Viewing 15 posts - 2,041 through 2,055 (of 3,232 total)
Exactly!! There is no reason to CAST/CONVERT here as the Query Optimizer will do an implicit conversion. Hence my earlier suggestion to use the select 1 where getdate()...
October 5, 2007 at 11:48 am
ubuntuXP07,
I understand what you are trying to do. Here is what I suggest you do to accomplish what you are after. First, let's go over you table...
October 5, 2007 at 11:43 am
Either way, your stuck with not being able to go back in time to look at previous deadlocks. Have you been able to capture a deadlock in your log...
October 4, 2007 at 4:28 pm
It would help if you would post your insert code so we could look at what is producing your error. It sounds like you are attempting to create a...
October 4, 2007 at 3:14 pm
Yea, I don't think there is if you really want the lock types. But then again, I've been wrong before.....:Whistling:
October 4, 2007 at 2:51 pm
When you right-click on the SP in the object browser, instead of saying 'Open', look down a bit farther and you'll see scripting options. You can script it as...
October 4, 2007 at 2:49 pm
What do you mean that it is not in the errorlog but you can see in in Enterprise Manager? Also, the input buffer (or part of it) is listed...
October 4, 2007 at 2:22 pm
Profiler will not be able to tell you the lock types. You can use it to watch for locks aquired/released and locks escalated but not lock type. Keep...
October 4, 2007 at 2:17 pm
Setting a trace flag using DBCC TRACEON will leave the trace flag running until you run DBCC TRACEOFF or restart SQL Server. If you need the trace flags to...
October 4, 2007 at 1:56 pm
Thanks for being humble enough to post your resolution.:)
October 4, 2007 at 1:06 pm
Ron, got you message. I would use what Jason has suggested here. Give me a call if you need to discuss further. BTW, I got your e-mail...
October 4, 2007 at 1:03 pm
I am still a bit confused as to what you are seeing. I don't use grid, I prefer text and when you execute a SP in text, you don't...
October 4, 2007 at 12:29 pm
MattieNH (10/4/2007)
I get two recordsets with the complete string, but no output parameters. I've even tried bringing back the 30 leftmost characters, and the 20 rightmost characters as output...
October 4, 2007 at 10:50 am
The trace flags will put the trace data into the error log the next time a deadlock occurs. Check out this link, it will help:
http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/tracingdeadlocks/1324/
October 4, 2007 at 10:26 am
Adam,
In the future, it would help greatly if you post the error that you are getting. This was an easy one, but if you know the error, why...
October 4, 2007 at 10:23 am
Viewing 15 posts - 2,041 through 2,055 (of 3,232 total)