Geeks With Blogs
Gabriel Lozano-Morán blog

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 Posted on Monday, December 4, 2006 7:16 PM Tips & Tricks , How to | Back to top


Comments on this post: How to: retrieve the SQL Server remotely

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Gabriel Lozano-Morán | Powered by: GeeksWithBlogs.net