Posted by reddy via SQLMonster.com on 10/01/58 11:17

Hi
I am new to sql server

I have a question.

1)when can we use trace flags i.e dbcc traceon(1204,3605,-1)?

after locking occured or before locking.

2) when can we use Sql profiler trace on?
after locking occured or before locking.

if we have to use before then it always have to have run 24 hours
trace on then where we will store that trace profile?

can any one tell please

--
Message posted via http://www.sqlmonster.com

[Back to original message]