-
Sql 2000 Sp3a
Select @@version does not know the difference between SP3 and SP3A.
Does anyone know of a SQL statement that will let me know if I have SP3A??
Thanks.
-
Tried 'SELECT SERVERPROPERTY('productversion')'?
-
Yes, I have tried:
'SELECT SERVERPROPERTY 'productversion')'
It returns 8.00.760 for SP3 and SP3A.
That's my problem.
Thanks.
-
Try this
SELECT SERVERPROPERTY('ProductLevel')
-
Did you check sqlservr.exe file properties?.
I am not sure whether 3a installs a new .exe
If not the version may have remained same.
-
Yep. I have checked the version numbers of the sqlservr.exe file properties.
SP3 and SP3A are the same.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|