DataBase Service Packs

Need some help in finding if my databases are on security pack three.
Thanksselect @.@.version
the version number returned must be equal or superior to 8.00.762.
Jacques.
"Robert Salazar" <rsalazar@.cbbank.com> a crit dans le message de
news:9318FB2B-7240-494C-A1F9-F7E1C563CA77@.microsoft.com...
> Need some help in finding if my databases are on security pack three.
> Thanks|||Hi,
Execute "select @.@.version " from query analyzer.
If the value is "8.00.760" , then it is service pack 3.
Look into the attached link for service pack versions:-
This link gives you the version numbers and will also redirect to download
locations.
Thanks
Hari
MCDBA
"Robert Salazar" <rsalazar@.cbbank.com> wrote in message
news:9318FB2B-7240-494C-A1F9-F7E1C563CA77@.microsoft.com...
> Need some help in finding if my databases are on security pack three.
> Thankssql