Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
server and service pack version
- Thread starter adonet
- Start date
You get at funky number don't you?
Go to click on the FAQs/Docs link
select the SQL Server Version Database
That will 'interpret' the results you get from @@version.
You can also find the information on Microsoft's website.
-SQLBill
Go to click on the FAQs/Docs link
select the SQL Server Version Database
That will 'interpret' the results you get from @@version.
You can also find the information on Microsoft's website.
-SQLBill
run the following ...
then check your findings against the info at this link ...
Thanks
J. Kusch
Code:
SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'Thanks
J. Kusch
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question