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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2009-10-13 : 11:06:32
|
| I tried to gather information on what exactly DBCC traceon(3604) does but I'm not satisfied with what i got. Could someone please explain in a bit detail about the functionality? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-13 : 12:13:17
|
| It redirects certain outputs to the client (management studio). Without that flag on, those outputs would go to the error log. It's not necessary unless you're using things like DBCC PAGE and other undocumented features.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
DBCC Traceon(3604)