Re: more service pack question

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 10/30/03 

Date: Wed, 29 Oct 2003 20:23:59 -0600

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: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)