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, 2011Hoan 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
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

10 years ago SQL ServerHow To, SQL Server Profiler4,484
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
22,485 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
20,284 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
16,043 views
JQuery Allow only numeric characters or only alphabet characters in textbox
13,519 views
C# Read Json From URL And Parse/Deserialize Json
10,067 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
  • Online Payday Loans – Learn How To Make the Most of A Alternative Lending Option
  • Strategies For Buying Photo Editor Software
  • Where to Find the Greatest Free Photo Editor on the Web
  • Custom Research Paper – What’s it So Useful?

  • Getting Bad Credit Paydayloans From a Reputable Source
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (247)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development