What is Trace flag?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between stored procedure and view in sql server?

616


What encryption security is available in sql azure?

79


Differentiate between SQL and ORACLE joins and write their syntax.

582


How to create a Master database in SQL server ?

547


Do you know the policy based administration feature of sql server 2008?

570






What is user-defined multi-statement table-valued function?

653


Why do we use stored procedures in sql server?

490


Explain primary key?

535


What is serializable?

660


Explain in brief how sql server enhances scalability of the database system?

475


Can you tell me some of the common replication dmv's and their use? : sql server replication

529


What happens if you are trying to access a schema not owned by you?

506


is it important for a database administrator to understand the operating system and file access? : Sql server administration

579


What is trace flag in sql server?

517


How to use clusters?

545