| Author |
Is it possible to turn on trace 1024 (for deadlocks) for all connections?
|
|
| Randolph Neall 2006-11-29, 7:12 pm |
| For Sql 2000 is there a way to turn on trace flag 1024 for all connections
at all times? Using dbcc traceon, we've succeeded only in turning on the
trace for the current connection.
Thanks,
Randy Neall
| |
| Kevin3NF 2006-11-29, 7:12 pm |
| Do you mean 1204?
You can set trace flags as startup parameters. Go to the Server Properties
in EM, look for the Startup parameters button and add -T1204
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Randolph Neall" < randolphneall@veraci
tycomputing.com> wrote in message
news:u$p%23mR8EHHA.140@TK2MSFTNGP06.phx.gbl...
> For Sql 2000 is there a way to turn on trace flag 1024 for all connections
> at all times? Using dbcc traceon, we've succeeded only in turning on the
> trace for the current connection.
>
> Thanks,
>
> Randy Neall
>
>
| |
| Randolph Neall 2006-11-29, 7:12 pm |
| Yes, I did actually mean 1204. What you suggested worked. Thanks very very
much!
Randy
"Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message
news:eKMmXd8EHHA.3768@TK2MSFTNGP02.phx.gbl...
> Do you mean 1204?
>
> You can set trace flags as startup parameters. Go to the Server
Properties
> in EM, look for the Startup parameters button and add -T1204
>
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
>
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>
> "Randolph Neall" < randolphneall@veraci
tycomputing.com> wrote in message
> news:u$p%23mR8EHHA.140@TK2MSFTNGP06.phx.gbl...
connections[color=da
rkred]
>
>
| |
| David Browne 2006-11-29, 7:12 pm |
|
"Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message
news:eKMmXd8EHHA.3768@TK2MSFTNGP02.phx.gbl...
> Do you mean 1204?
>
> You can set trace flags as startup parameters. Go to the Server
> Properties in EM, look for the Startup parameters button and add -T1204
>
> --
And on SQL Server 2005, use the new trace flag 1222 instead.
David
| |
| Kevin3NF 2006-11-29, 7:12 pm |
| Thanks for the value-add David...I'll add that to my "big list 'o notes" :)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:OHf3h18EHHA.1356@TK2MSFTNGP06.phx.gbl...
>
>
> "Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message
> news:eKMmXd8EHHA.3768@TK2MSFTNGP02.phx.gbl...
>
>
> And on SQL Server 2005, use the new trace flag 1222 instead.
>
> David
|
|
|
|