check whether MSDE is installed or not

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

check whether MSDE is installed or not

Author

Topic

rushdib
Yak Posting Veteran

93 Posts

Posted - 2004-06-10 : 14:38:07

Hi,
Is there any way I can check whether a SQL Server (MSDE) is installed in a pc or not using transact SQL?

Thank you,

Rushdi

lazerath
Constraint Violating Yak Guru

343 Posts

Posted - 2004-06-10 : 14:41:39

I believe you might be looking for:

SELECT @@Version;

Production:

Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )

* Note that yours may be Standard instead of Enterprise

MSDE:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources