SQL 2005 & MSDE SQL - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Administration

SQL 2005 & MSDE SQL

Author

Topic

zyc_5
Starting Member

1 Post

Posted - 2009-07-20 : 14:08:41

Hi all,

It is my first time to ask a question here, thanks for your help in advance!

My question is:
How to check if MSDE SQL is installed and if it is the full blown version?
The edition of SQL is 2005 Standard and installed on a server 2003 box
My deep concern is how to create a dB but not on msde version

wshawnmelton
Starting Member

17 Posts

Posted - 2009-07-24 : 07:44:18

I would probably start with Add/Remove programs.

noneil277
Starting Member

13 Posts

Posted - 2009-07-24 : 11:10:25

Run the following query

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

--
Nicholas O'Neil
Senior Engineer, Logicworks.net
MCSA/MCSE/+Messaging/MCTS:SQL2005

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources