Tip: Undocumented Trace Flags
Microsoft neglected to document three trace flags that might prove helpful when you're troubleshooting a particular database or trying to solve problems with starting SQL Server. The three trace flags, which Table A shows, exist in both SQL Server 2000 and 7.0, and you'll find some additional information about them at http://support.microsoft.com/support/kb/articles/q277/2/72.asp.
|TABLE A: Undocumented Trace Flags|
|T3607||Recovers no database. Skips automatic recovery (at startup) for all databases.|
|T3608||Recovers master database only. Skips automatic recovery (at startup) for all databases except the master database.|
|T3609||Skips the creation of the tempdb database at startup. Use this trace flag if the tempdb database is problematic or problems exist in the model database.|