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
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is the stuff?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
what are the Prerequisites for Replication?
What is exporting utility?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What xml support does the sql server extend?
Can we insert data into view sql server?
What is sql server database?
What are the steps you can take to avoid “deadlocks”?
What is an expensive query?
How to add code to the existing article (using improve article)?
In case you have filters in your report, when filters will be applied in cached report instance?
How to list all tables in the database using odbc_tables()?
How global temporary tables are represented and its scope?
