Checking SQL Server or MSDE Version and Service Pack Level - Cisco Systems:
"SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')"
The above SQL query string was all I needed to verify the SQL Server version, SP level and type (in my case, the type was "Enterprise Edition", but I *thought* it was only "Standard Edition"... so this was helpful in figuring out why my attempts to upgrade to SQL 2K5 Standard were being "blocked").
Pretty soon I'm gonna be a DBA!! (just kiddin)
Thursday, February 5, 2009
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment