I didn't study this in detail, but one thing I have noticed that people miss in deadlock analysis is that the processes may be involved in a multi-statement transaction....

I didn't study this in detail, but one thing I have noticed that people miss in deadlock analysis is that the processes may be involved in a multi-statement transaction....

• This reply was modified 5 years, 4 months ago by Fernando Toledo.

-- Edit: Forgot to quote a reply

• This reply was modified 5 years, 4 months ago by Fernando Toledo.

Hi there!

It does work with UNC names. I just made a test and it works fine on SQL Server 2000 SP4.

Here follows my test:

declare @sql...

Hi Veronica!

I agree with Studdy05, we also monitor our server 24/7 using profiler and perfmon and there is no impact on our servers' performance.

If you still concerned with it's impact,...

Yes, i`m querying views and tables... Looking in the syscacheobjects table, after running the query a few times, here is the return:

cacheobjtype objtype  uid refcounts usecounts pagesused setopts...