how can i modify the setup parameter.!

[nowayout]

Hi all,

I am trying to change the setup parameter from
"-d"C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf"

To

"sqlservr -d"C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf" -T3111"

How can i do that???

 

[mrdenny]

Trace flags are edited in Enterprise Manager, by right clicking on the server, and clicking properties. There is a Startup Paramaters button.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[nowayout]

i did added the -T3111 but now how can i set it for the start up parameter to this:

-d"C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf" -T3111

 

[mrdenny]

I'm not sure what you mean. If you've added the trace flag in the Startup Paramaters button then you've changed it.

Denny

--Anything is possible. All it takes is a little research. (Me)