Re: more service pack question

From: supernova (abc_at_yahoo.com)
Date: 10/30/03 

Date: Thu, 30 Oct 2003 11:00:25 +0800

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

  • Re: more service pack question
    ... Supernova ... > You could change the server name in the VBScript below, ... > SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Save as in SQL Server(Backup - Restore)
    ... "Dan Guzman" wrote in message ... > SQL Server MVP ... I take it you already know about the RESTORE command ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: SP accessing other db
    ... regarding the cross-database chaining server option. ... Now the database name is hard-coded. ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Type of Cluster?
    ... MVP - Windows Server - Clustering ... >> cluster, granted not as fast as a SAN, but cheaper:) ... >>>well within the capabilities of SQL Server. ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: active active: can somebody help with design?
    ... SQL Server MVP ... You can't have a default instance in virtual server 1 and another default ... You don't install the instances on particular nodes per se. ...
    (microsoft.public.sqlserver.clustering)