Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server How To Filter DataBase Name And Login Username In SQL Server Profiler

How To Filter DataBase Name And Login Username In SQL Server Profiler

By default, SQL Server Profiler traces all coming Stored Procedures or SQL Commands are submitted to your SQL Server. Therefore, you may in trouble if the server is hosting many databases with difference database usernames. It’s hard for you to trace a desired event because other events from difference databases keep logging. Fortunately, SQL Server Profiler allow you to filter events just from a specific database or a specific login username.

In order to limit SQL Server Profiler tracing to a specific database or username, simply follow these steps below:

  • 1. Create a New Trace and login to a server which you want to set the limitation
  • 2. On Trace Properties, click on Events Selection tab then check on Show all columns checkbox
    SQL Server Profiler Column Filter

    SQL Server Profiler Column Filter

  • 3. Click on Column Filters … button, under the Show all columns checkbox
  • 4. You should see DatabaseName and LoginName in the Edit Filter box, enter the database name or login name for the Like section on the right then click OK button.
    SQL Server Profiler Edit Filter

    SQL Server Profiler Edit Filter

  • 5. You will be sent back to Trace Properties box, click Run button then you will see the trace panel is only for the database or login name you have entered on step 4.

Of course, you can do filter with others options with Like or Not like condition. DatabaseName and LoginName are 2 options I often use most.

May 6, 2011 Hoan Huynh
How To Check Which Stored Procedures Or SQL Commands Are Running On SQL ServerFree Web Admin For Microsoft SQL Server And Oracle - 1ClickDBPro
You Might Also Like:
  • How To Check Which Stored Procedures Or SQL Commands Are Running On SQL Server
  • Free Mysql Profiler similar to Microsoft SQL Server Profiler – LogMonitor
  • Capture And Display Execution Time Of SQL Query In SQL Server
  • Export/Import Data From Local Database To Remote Database With MS SQL Server 2008
  • ASP.NET Store Session In MS SQL Server Database
  • Free Web Admin For Microsoft SQL Server And Oracle – 1ClickDBPro
  • Consider SQL Server Express 2008 Limitations
  • Schedule Backup And Zip MySQL Database In Windows
  • MSSQL Create Database With SQL Statement
  • Change Database Configuration Settings In CakePHP
  • http://www.book-marky.de bookmarks online

    Thanks , I’ve recently been looking for information about this topic for a while and yours is the best I have discovered till now. However, what in regards to the bottom line? Are you positive in regards to the supply?|What i do not realize is in truth how you are not actually a lot more neatly-preferred than you may be right now. You’re so intelligent.

  • Mae

    Simple yet very helpful, I followed step by step and saw what I wanted. Thanks

  • Mae

    Simple yet very helpful, I followed step by step and saw what I wanted. Thanks

  • http://chennai.seo-specialist.in/ SEO in Chennai

    Thanks for the short but very useful tutorial, adds some value to my sql knowledge!

Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at hoan@4rapiddev.com

8 years ago SQL ServerHow To, SQL Server Profiler2,097
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
18,765 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
14,632 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
13,366 views
JQuery Allow only numeric characters or only alphabet characters in textbox
10,933 views
C# Read Json From URL And Parse/Deserialize Json
7,502 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Magento Fatal error: Unsupported operand types
  • Ionic bower the name contains uppercase letters
  • PHP Magento Get Manufacturer Name And ID From Magento Product ID
  • Know Simple Hacks To Systematize Media Library in WordPress
  • A handy guideline on adding custom menu item in WordPress admin
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (26)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (140)
EMAIL SUBSCRIPTION

Sign up for our newsletter to receive the latest news and event postings.

Recommended
  • CDN
  • Hosting
  • Premium Themes
  • VPS
2014 © 4 Rapid Development