How can I check the version?

Hi, I need to know what's is the latest service pack of my sql 7.0, how can
I check it?
How do I know which user is using sql database?
Thanks,
SarahHi, I need to know what's is the latest service pack of my sql 7.0, how canI
check it?
run
SELECT @.@.version statement to view the version
7.00.699 SP1
7.00.642 SP2
7.00.961 SP3
7.00.1063 SP4
How do I know which user is using sql database?
sp_who or sp_who2 to see who is logged in.
"Sarah G." <sguo@.coopervision.com> wrote in message
news:u%23lFgq0GEHA.3068@.TK2MSFTNGP11.phx.gbl...
> Hi, I need to know what's is the latest service pack of my sql 7.0, how
can
> I check it?
> How do I know which user is using sql database?
> Thanks,
> Sarah
>|||Thank you so much,
Sarah
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:eh9exu0GEHA.1240@.TK2MSFTNGP10.phx.gbl...
> Hi, I need to know what's is the latest service pack of my sql 7.0, how
canI
> check it?
> run
> SELECT @.@.version statement to view the version
> 7.00.699 SP1
> 7.00.642 SP2
> 7.00.961 SP3
> 7.00.1063 SP4
> How do I know which user is using sql database?
> sp_who or sp_who2 to see who is logged in.
>
> "Sarah G." <sguo@.coopervision.com> wrote in message
> news:u%23lFgq0GEHA.3068@.TK2MSFTNGP11.phx.gbl...
> can
>