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
What are the differences between stored procedure and view in sql server?
What encryption security is available in sql azure?
Differentiate between SQL and ORACLE joins and write their syntax.
How to create a Master database in SQL server ?
Do you know the policy based administration feature of sql server 2008?
What is user-defined multi-statement table-valued function?
Why do we use stored procedures in sql server?
Explain primary key?
What is serializable?
Explain in brief how sql server enhances scalability of the database system?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What happens if you are trying to access a schema not owned by you?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is trace flag in sql server?
How to use clusters?