What is Trace flag?



What is Trace flag?..

Answer / sqldba29

Trace flags are used to temporarily set specific server
characteristics or to switch off a particular behavior. For
example, if trace flag 3205 is set when an instance of SQL
Server starts

1204: Deadlock information

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to create an multi-statement table-valued function?

0 Answers  


How to Get the last identity value used

4 Answers  


I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  


How to resolve the orphan use problem? : sql server security

0 Answers  


How to download and install microsoft sql server management studio express?

0 Answers  






How to create new databases with "create database" statements?

0 Answers  


What does this statement do @@rowcount?

0 Answers  


How to rebuild master databse?

0 Answers  


How do I find the query plan in sql server?

0 Answers  


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  


What is database replication?

0 Answers  


How to include text values in sql statements?

0 Answers  


Categories