Re: identify sp

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 10/30/03


Date: Thu, 30 Oct 2003 13:14:28 +0530


> 7.00.1094 in one SQL 7
SQL 7.0 SP4(1063) + Patch

> 7.00.961 in another SQL 7
SQL 7.0 SP3

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"supernova" <abc@yahoo.com> wrote in message
news:espX8ZrnDHA.1728@TK2MSFTNGP09.phx.gbl...
> How do you identify the service pack on SQL 7.0? I ran "select @@version"
> and it gives:
>
> 7.00.1094  in one SQL 7
> 7.00.961 in another SQL 7
>
> do these tell anything?
>
> Thanks.
>
>


Relevant Pages

  • Re: which statement fire the trigger ?
    ... Books Online for SQL Server SP3 at ... > Andrew J. Kelly SQL MVP ... >> TLV ...
    (microsoft.public.sqlserver.programming)
  • Re: SP execution view in Profiler
    ... > been trying to find how I can view the executed SQL in SQL Profiler but ... SQL:StmtCompleted and the TextData column should do. ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.programming)
  • Re: recent drivel posted by Tony Rogerson on his blog
    ... to respond to a blog. ... You accept what you are used to as the norm, msdn is slow which is why I have books online installed locally, it has a link on the search through to the online version anyway - also out to a number of community sites my own included. ... Tony Rogerson, SQL Server MVP ... [UK SQL User Community] ...
    (comp.databases.oracle.server)
  • Re: reclaiming LOB space
    ... Books Online says "Reclaims space from dropped variable-length ... But as I understood Mike, he did not drop the column, only setting the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • Re: Command object and batching stored procedure calls
    ... I'm using SQL Server. ... ADO Command object. ... 22 separate statements is the most I've been able to get in one CommandText, ... I'd appreciate it if you could point me to the Books Online where it's ...
    (microsoft.public.data.ado)