-T3608 -T4022

[Joh]

sqlservr -c -T3608 -T4022.

Can any one let me know about T3608 & T4022 means ? I have failed to findout
in BOL..

Thanks

[Anith Sen]

Lookup trace flags in SQL Server Books Online. -T3608 & -T4022 indicates
that the instance of SQL Server is started with two specified trace flags
3608 & 4022 in effect. Trace flags are used to start the server with
nonstandard behavior. In this case, 3608 is an undocumented trace flag in
SQL Server 2000.

FYI, trace flag 3608 skips automatic recovery for all databases except the
master database at the startup and with 4022 all the automatically started
procedures will be bypassed during startup. You can find more details about
4022 in SQL Server Books Online in the topic CREATE PROCEDURE under the
section "Automatically Executing Stored Procedures".

[Joh]

Thanks Anith

Post by Anith Sen
Lookup trace flags in SQL Server Books Online. -T3608 & -T4022 indicates
that the instance of SQL Server is started with two specified trace flags
3608 & 4022 in effect. Trace flags are used to start the server with
nonstandard behavior. In this case, 3608 is an undocumented trace flag in
SQL Server 2000.
FYI, trace flag 3608 skips automatic recovery for all databases except the
master database at the startup and with 4022 all the automatically started
procedures will be bypassed during startup. You can find more details about
4022 in SQL Server Books Online in the topic CREATE PROCEDURE under the
section "Automatically Executing Stored Procedures".
--
Anith