Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

dbcc traceon(3604)

 
   Database Forums (Home) -> Sybase RSS
Next:  Your SQL Server installation is either corrupt or..  
Author Message
crazy_monk




Joined: Jun 29, 2005
Posts: 14



(Msg. 1) Posted: Wed Jun 29, 2005 5:01 am
Post subject: dbcc traceon(3604)

why should we execute dbcc traceon(3604) and what is its impact on the server and other programs?
please help

 >> Stay informed about: dbcc traceon(3604) 
Back to top
Login to vote
vipra

External


Since: Mar 08, 2005
Posts: 14



(Msg. 2) Posted: Wed Jun 29, 2005 3:28 pm
Post subject: Re: dbcc traceon(3604) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Usage: 3604 is to redirect the output onto the screen/file. default is to
direct the output of the dbcc's that come after 3604 is errorlog. and is
session based.

impact: depending on what dbcc your are planning to run will impact the
system.

if you use dbccdb, impact is minimal.

hope someone else can shed more light on this.
Vipra.

 >> Stay informed about: dbcc traceon(3604) 
Back to top
Login to vote
crazy_monk




Joined: Jun 29, 2005
Posts: 14



(Msg. 3) Posted: Thu Jun 30, 2005 12:14 am
Post subject: Re: dbcc traceon(3604) [Login to view extended thread Info.]

Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to get a particular row from dbcc page. - Hi there, How can I view a particular row from dbcc page? Below is the full dbcc page output. I was told that the row on this page is #19 (from nextrno which is 20). Now, how can I select this row #19 from the table? (I already know the table name fro...

dbcc checkalloc : error 2540 - Hi, I am getting the following error during a dbcc checkalloc : Server message:: Message number: 2540, Severity 16, State 1, Line 2 Server: EXMRXDAT Message String: Table Corrupt: Page is allocated but not linked. Run DBCC TABLEALLOC to correct the..

logwatch script comments - Hello i would like to ask for comments about the following script for logwatch about ASE, Mon, Hist, Backup and replication server. test with logwatch 5.5 on Centos4/Linux (4 script + conf and one shared script modified) thanks regards julien ===..

about error message - hello,i meet a problem! when i write a store procedure ,i want to show error msg myself,so i use @@error to point the error. the question is how can i find which column induce the error just like the DBMS tell me when i run a sql in isql? pls help me!

Pull stored procedure parameters in sybase - Hi, I'm trying to build a wrapper to stored procedures in my database (Sybase). I already have something working for SQL and I'm trying to convert it to support Sybase as well. I'm looking to find a way to pull all the stored procedure's parameters..
   Database Forums (Home) -> Sybase All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]