Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bbxrider
Starting Member
37 Posts |
 Posted - 2009-06-24 : 20:12:07
|
| i'm a sql novice as far as admin goes and trying to upgrade 2005 to 2008 and the upgrade advisor complained about global trace flags, that i assume have to be deleted or disabled, see below per the 2008 upgrade advisor msg:Location: Startup/EnabledTrace Flag: 8017my current sql server 2005 has 2 instances, neither of which i installed. one comes from an hp print server and the other from installing visual studio 2005. i don't see any mgt panels anywhere to admin things like the trace flags. googling hasn't been much help for instance this looks good:Trace flags can be set globally or per session. Global trace flags can be set at startup with the -T switch or can be set with the DBCC TRACEON and DBCC TRACEOFF command. DBCC TRACESTATUS is used to determine what flags are currently enabled.but where/how do the above get done?bob |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
remove global trace flags