How check for active trace flags in SQL Server

Dear reader, thanks for visiting!

The post has been moved to my new blogging site – http://www.mssqlinsider.com.

You can read the complete post there.

Advertisements

2 comments on “How check for active trace flags in SQL Server

  1. I have enabled dbcc traceflag(610) in one session and i have verified the status of this traceflag from antoher session, but i am not able to get the active traceflag session details from the otherone

    • When you enabled it, you should do it globally -> dbcc traceon(610,-1). Otherwise you are just enabling it for the current session and you cannot see it enabled in another one!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s