Re: more service pack question

From: Tibor Karaszi (tibor.please_reply_to_public_forum.karaszi_at_cornerstone.se)
Date: 10/30/03 

Date: Thu, 30 Oct 2003 08:28:55 +0100

Did you search the disk for OSQL.EXE? It is in the directory for the SQL Server program files. 

-- 
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"supernova" <abc@yahoo.com> wrote in message news:OU7N6HpnDHA.2216@TK2MSFTNGP12.phx.gbl...
> Dan,
>
>            Thanks for the reply. Do you where I can find the utility? I
> could only find the msde. Please help. Thanks.
>
> Supernova
>
> "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
> news:OzWehzonDHA.1740@TK2MSFTNGP12.phx.gbl...
> > If you have the OSQL command-line utility installed:
> >
> >     OSQL -Q"SELECT @@VERSION" -E
> >
> > You could change the server name in the VBScript below, save it to a
> > file with a '.vbs' extension and execute.
> >
> >     Set oConnection = CreateObject("ADODB.Connection")
> >     oConnection.Open "Provider=SQLOLEDB;" & _
> >         "Server=MyServer;" & _
> >         "Integrated Security=SSPI"
> >     Set oRecordset = oConnection.Execute( _
> >         "SELECT @@VERSION")
> >     MsgBox oRecordset.Fields(0)
> >
> > -- 
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > -----------------------
> > SQL FAQ links (courtesy  Neil Pike):
> >
> > http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> > http://www.sqlserverfaq.com
> > http://www.mssqlserver.com/faq
> > -----------------------
> >
> > "supernova" <abc@yahoo.com> wrote in message
> > news:uMKo8gonDHA.1408@TK2MSFTNGP11.phx.gbl...
> > > If there is only sql service running on the back, SQL 7.0, and no
> > query
> > > analyzer and no entreprise manager. How can I find out what service
> > pack has
> > > been applied? Thanks.
> > >
> > >
> >
> >
>
>

Relevant Pages