Wednesday, January 25, 2006

SQL Help

How to check SQL Version

SELECT @@VERSION

Result:
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

SQL Server 2000

NO SP: 8.00.194
SP1:8.00.384
SP2: 8.00.534
SP3/3a:8.00.760
SP4: 8.00.2039

OR

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
and check the above numbers.



The Select Commands ref

5 Comments:

Blogger michelhuron7681486821 said...

I read over your blog, and i found it inquisitive, you may find My Blog interesting. So please Click Here To Read My Blog

http://pennystockinvestment.blogspot.com

2:23 PM  
Blogger kevinbrinick27734959 said...

Get any Desired College Degree, In less then 2 weeks.

Call this number now 24 hours a day 7 days a week (413) 208-3069

Get these Degrees NOW!!!

"BA", "BSc", "MA", "MSc", "MBA", "PHD",

Get everything within 2 weeks.
100% verifiable, this is a real deal

Act now you owe it to your future.

(413) 208-3069 call now 24 hours a day, 7 days a week.

6:42 AM  
Blogger Weight Loss Expert said...

I enjoyed visiting. If you are interested in the TOP 10 NATIONAL RANK listings for fast weight loss informational products, please stop by.

11:59 AM  
Blogger Weight Loss Expert said...

I enjoyed visiting. If you are interested in the TOP 10 NATIONAL RANK listings for weight loss informational products, please stop by.

2:35 AM  
Blogger Weight Loss Expert said...

I enjoyed visiting. If you are interested in the TOP 10 NATIONAL RANK listings for weight loss informational products, please stop by.

5:42 AM  

Post a Comment

<< Home