Hi Friends,

I have installed SQL server 2005 Express Ed. and management Studio Express.
How Do i know if these are havibg SP1 Installed or not?

I have the Database displayed as: MyHomePC\SQLExpress (SQL Server 9.0.2047 -
as version info.

Please guide

Thanks
Prabhat

Haven't used 2005 express, but try querying the database using


SELECT SERVERPROPERTY('ProductLevel')
' this will give you the SP version for your SQL Server instance

'or for longer version output (might not display service pack info)
SELECT @@VERSION


Cheers,
Johan Sjöström
MSc, MCP, MCAD


Prabhat wrote:
Show quoteHide quote

Hi Johan,

I executed  SELECT SERVERPROPERTY('ProductLevel') and get result as "SP1"

So it is having SP1 installed in it.

Thanks
Prabhat

Haven't used 2005 express, but try querying the database using


SELECT SERVERPROPERTY('ProductLevel')
' this will give you the SP version for your SQL Server instance

'or for longer version output (might not display service pack info)
SELECT @@VERSION


Cheers,
Johan Sjöström
MSc, MCP, MCAD

Prabhat (not_a_m***@hotmail.com) writes:
That's indeed SP1.

Timeout expire
Optimize this query
TOP 50 invoices by company
Denormalizing a database table
How can I insert a new field between existing field?