Daily problems and issues that are hard to resolve about SSMS,SSRS,SSIS,SSAS,DTS,Agent, Optimization, Administration, Always On, Clustering, Point in Time recovery and more...
Search This Blog & Web
Thursday, May 24, 2012
How to find defult transaction level using DBCC - SQL SERVER
I need to know what is my Default settings for Transaction level and Datetime etc. Using DBCC command i can do this easily.
DBCC useroptions
running the above statement will return default values for all following available options.
No comments:
Post a Comment