Service pack / patches

anonymous_at_discussions.microsoft.com
Date: 01/15/04 

Date: Thu, 15 Jan 2004 12:41:16 -0800

You can "drill" to your database. Then you can go to the
SQL Query Analyzer. There type the following:
select serverproperty('productlevel'),serverproperty
('productversion')
This will return the SP and the Version Number
>-----Original Message-----
>Is there an easy way to determine my service pack level
in SQL 2k?
>.
>

Relevant Pages

  • Re: Precision of retrieved data
    ... I SQL via SQL Query Analyzer, I get the value of 0.654321. ... Which Microsoft database? ... What is the DisplayFormat property of the field object set to? ...
    (borland.public.delphi.database.ado)
  • Re: php mssql stored procedure
    ... it into SQL Query Analyzer it executes and returns results. ... Use a serious database, ... make it so simple that there are obviously no deficiencies, ... Installed MS SQL Server Native Client from ...
    (comp.lang.php)
  • Re: php mssql stored procedure
    ... Possibly MS is doing it's famous trick again: repairing wrong stuff, ... In your case I suspect that the 'NULL' is translated to NULL if you run it through MS SQL Query Analyzer. ... If that doesn't help, you can Google around a little for stored procedure, MSSQL and PHP. ... Use a serious database, ...
    (comp.lang.php)
  • Re: Truncate log file
    ... Under SQL Query Analyzer, I run following statement, ... But get error messages like, ... Could not open new database 'backoff_0801'. ... Device activation error. ...
    (microsoft.public.sqlserver.server)
  • LRe: Frustrated trying to use "pure" VS.NET to access database properties
    ... In the table that's returned using the GetSchema method there "appears to be" a column that someone intended to be populated with the default value but I have never seen anything in it (and I KNOW the database definition specifies one). ... If you have SQL Query Analyzer, you can use an index search in it's help documentation to search for sp_columns to review what each field in the results collection represents, and map from there:) ...
    (microsoft.public.dotnet.languages.vb)