467,915 Members | 1,455 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

What SQL version am i running? Free or not

New to SQL. Don't know what version of SQL this is, and is it Free or not? When i open Microsoft SQL server management studio express 2005, point to the server, i get this - server name (SQL Server 8.0.760) i guess its the build #. I looked around with no good results. Thanks.
Sep 9 '08 #1
  • viewed: 4262
Share:
3 Replies
ck9663
Expert 2GB
That would be SQL Server 2000, I think.


-- CK
Sep 9 '08 #2
That would be SQL Server 2000, I think.


-- CK
Thanks, looks like i might have found something at sqlsecurity.com
Sep 9 '08 #3
This would get you basically all that --

select 'SQL instance = ' + quotename(cast(SERVERPROPERTY('servername') as varchar(25)))+', '+cast(SERVERPROPERTY('productversion') as varchar(10))+', '
+ cast(SERVERPROPERTY ('productlevel') as varchar(10))
+ case when SERVERPROPERTY ('IsClustered') = 1 then ' (clustered)' else '' end
+ case when SERVERPROPERTY ('IsFulltextEnabled') = 1 then ' ,Fulltext enabled' else '' end
+ ', '+ cast(SERVERPROPERTY ('edition') as varchar(31))
Sep 20 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Ravi Tallury | last post: by
4 posts views Thread by Whitney Kew | last post: by
121 posts views Thread by typingcat | last post: by
3 posts views Thread by jib | last post: by
5 posts views Thread by HotRod | last post: by
3 posts views Thread by crazy420fingers | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.