>>>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