February 11, 2003 at 11:48 am
I would like to set two trace flags to on by default for my development server,
1204 and 257. The problem is I am not sure on how to set multiple trace options
for my startup options. Would it be "-T1204 -T257" or "-T1204 257" or some other
derivative?
From "Using Startup Options"
quote:
/Ttrace# - Indicates that an instance of SQL Server should be started with aspecified trace flag (trace#) in effect. Trace flags are used to start the
server with nonstandard behavior.
Trace Info :
1204 - Returns the type of locks participating in the deadlock and the current
command affected.
257 - Pre formats XML output before display in the query analyzer output window.
I added -T1204 to my startup, and rebooted my server, and verified that it was
set. I am unwilling to try out my options on this as I would hate to leave this
server in an unusable state. Even though it is a development server, many
developers use it. Rebuilding it during work hours would be very costly...
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One Windows to bring them all and in the darkness bind them
In the Land of Microsoft where the Shadows lie.
Tim C //Will code for food
February 11, 2003 at 12:16 pm
you can use "sqlservr -T1204 -T257"
February 11, 2003 at 12:36 pm
Add them to the startup items in server properties individually
-T1204
-T257
Even if you added a bad line though it should ignore (unless you stumble onto something undocumented). But by any case they are found in the regkey
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters
Keep in mind you can damage things in the registry so be carefull what you delete, but the SQLArgx items should be self explaining.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply