----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Star_Venkat Message 1 in Discussion DBCC TraceOn: SQL Server is providing an option to switch on the trace flag using DBCC Traceon command. Considering the trace flag 1. 1204 - This flag is used to enable the locking functionality details to be shown to the user or written into the log file. The log information includes type of locks, current command which affect the lock and also about the resource details which are affected by this lock. 2. 3205 - This flag is to enable automatic compression if we proceed with backup strategies. Syntax: DBCC traceon(traceflagnumber) Example: DBCC traceon(1204) The above query will enable the traceon for the 1204 flag. Scenario: In banking,reservation and finance related database, we will face situations like some user write the data meanwhile other user trying to read the data. If we have any deadlock we cant able to find which process to be killed to enable the server to work properly. In that case, enable this flag and checkout in the error log file for the same. Regards, Venkatesan Prabu J ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
