TroubleshootingSQL

Explaining the bits and bytes of Azure SQL

Menu

Skip to content
  • Home
  • WhoAmI
  • Facebook
  • LinkedIn
  • Twitter
  • Events
  • Videos

Daily Archives: February 5, 2010

How to identify the SQL Server version from a Profiler Trace

Posted on February 5, 2010 by Amit Banerjee

You use certain little tips and tricks with the SQL Server tools which are not documented anywhere. This is one of them. I needed to find out the version of a SQL Server instance from which the Profiler Trace was captured. I opened the Profiler trace using SQL Profiler 2008. I clicked on the Trace properties and lo behold I had the SQL Server instance name and version.

image

I got the SQL Server release, version and the instance name (Trace provider name).

Share this post:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on Threads (Opens in new window) Threads
  • Click to share on X (Opens in new window) X
  • Click to share on Reddit (Opens in new window) Reddit
  • Click to email a link to a friend (Opens in new window) Email
  • Click to share on WhatsApp (Opens in new window) WhatsApp
  • Click to share on Tumblr (Opens in new window) Tumblr
  • Click to share on Pinterest (Opens in new window) Pinterest
  • Click to share on Bluesky (Opens in new window) Bluesky
  • More
  • Click to print (Opens in new window) Print
  • Click to share on Pocket (Opens in new window) Pocket
  • Click to share on Telegram (Opens in new window) Telegram
Like Loading...
Posted in Tools | Tagged Profiler Trace, SQL Server 2008

Search

Seek Count

  • 1,182,872

Facebook Page

Facebook Page

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,353 other subscribers

Linked Servers

Facebook Fan Page Twitter RSS Feeds Feedburner Feeds LinkedIn Networked Blogs Google+

IAM

  • AI (1)
    • Perplexity (1)
  • Availability Group (3)
  • Azure (26)
  • Azure SQL Database (10)
  • Backup (24)
  • BigData (1)
  • Change Tracking (1)
  • Data Recovery (6)
  • Debugging (11)
  • Did you know (25)
  • Excel (11)
    • Power View (8)
  • IaaS (16)
  • Memory (9)
  • Microsoft (3)
  • Mirroring (4)
  • PaaS (9)
  • Performance (20)
    • Disk (2)
    • Query Tuning (8)
  • Power View (5)
  • PowerBI (2)
  • PowerPivot (7)
  • Replication (6)
  • Reporting Services (6)
    • PowerView (2)
  • Screencasts (1)
  • Scripts (73)
    • Monitoring (13)
    • Powershell (17)
    • TSQL (36)
    • WMI (11)
  • Security (1)
  • SQL Agent (1)
  • SQL How To (13)
  • SQL Myths (3)
  • SQL Server (52)
    • Best Practices (17)
  • SQL Server 2012 (14)
  • SQL Server 2014 (4)
  • SQL Server 2016 (7)
  • SQL Setup (12)
  • T-SQL Tuesday (10)
  • Tools (68)
    • Data Analysis (10)
    • Data Collection (20)
    • Monitoring (20)
      • System Health Session (9)
    • Troubleshooting (7)
  • Tools Tips and Tricks (13)
  • Troubleshooting SQL Issues (48)
  • Twost (13)
  • Webcasts and Events (38)
  • Wikis (15)

Spatial Map

Locations of visitors to this page

Transaction Log

February 2010
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
« Jan   Mar »

Professional SQL Server 2012: Internals and Troubleshooting

Ghosted Posts

Category Azure

Azure Azure SQL Database Backup Best Practices Data Analysis Data Collection Data Recovery Debugging Did you know Excel IaaS Memory Monitoring PaaS Performance PowerPivot Powershell Power View Query Tuning Replication Reporting Services Scripts SQL How To SQL Server SQL Server 2012 SQL Server 2016 SQL Setup System Health Session T-SQL Tuesday Tools Tools Tips and Tricks Troubleshooting Troubleshooting SQL Issues TSQL Twost Webcasts and Events Wikis WMI

Creative Commons License
TroubleshootingSQL by Amit Banerjee is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.

Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • TroubleshootingSQL
    • Join 280 other subscribers
    • Already have a WordPress.com account? Log in now.
    • TroubleshootingSQL
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
%d