Blog Stats
  • Posts - 157
  • Articles - 0
  • Comments - 90
  • Trackbacks - 19

 

<< Unable to open shim database version registry key - v2.0.50727.00000 | Home | How to: check if SP1 for Visual Studio .NET 2003 is installed >>

How to: retrieve the SQL Server remotely

In case you need to find out the version of the SQL Server installed on a server you could execute the following statement:

SELECT @@VERSION;

Which returns on my development sandbox the following string:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)   Apr 14 2006 01:12:25   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Cross-posted from The .NET Aficionado
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Print posted @ Monday, December 04, 2006 7:16 PM

Feedback

No comments posted yet.

Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

 

 

Copyright © Gabriel Lozano-Morán