Select @@version

Erwin Sloboda
Database Specialist, Database Services Group
Assante Advisory Services Ltd.
416-535-3792, 416-569-7089
Toronto, ON


-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed]
Sent: Wednesday, December 17, 2003 5:22 PM
To: LazyDBA.com Discussion
Subject: version and service pack of sql server


hi all,

Sql Server 7
Pls can u give command where i can be able to find out
the version and service pack of the servers which i am
using.
and also a script will when run would give the
solution
pls. its very urgent help me....

TIA
Adil


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] All e-mail to or from this address is recorded by Assante
and is subject to archival, monitoring and/or review, by and/or disclosure
to, someone other than the recipient. This message is intended only for
the persons to whom it is addressed. It may contain information that is
privileged and confidential. If you are not the intended recipient, please
contact the sender immediately and delete the e-mail without reading it
or making a copy.

Any distribution, copying, or other use of this e-mail by
a person other than the intended recipient is prohibited. Precautions have
been taken to screen this e-mail for viruses but it may not be virus free.
We are not responsible for any damage that may be caused by this
e-mail. This communication is for information purposes only and is not
an offer to sell or a solicitation of an offer to buy any financial product,
an official confirmation of any transaction or an official statement of
Assante. E-mail transmission cannot be guaranteed to be secure or
error-free.
--------------------------------------------------------------------------
MS Sql Server LazyDBA home page