I am working from my home office today and the spell check window looks fine from my home box, but when I go back and look at my laptop, the...

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()...

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...

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...

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...

Yea, I don't think there is if you really want the lock types. But then again, I've been wrong before.....:Whistling:

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...

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...

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...

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...

Thanks for being humble enough to post your resolution.:)

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...

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...

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...

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/