Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizing a query
Message
 
 
To
09/09/2008 14:24:06
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 6.5 and older
Miscellaneous
Thread ID:
01345942
Message ID:
01346182
Views:
13
>>>I would also recommend to upgrade SQL Server from that antiquated version. It may resolve the problem by itself.
>>
>>The version installed is 9.00.3042. Is that the latest version?
>
>Mine is
>Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
>But I get this with:
>SELECT @@VERSION
> in SSMS
>Not in Help->About.
>Help->About show you only the version of SSMS and related products.

Hmm, I got Express Edition and I was thinking I'm not using free one... :) Good thing I discovered it.

SELECT
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform