SQL 2005 or MSDE? How to tell??

Soldato
Joined
11 Feb 2004
Posts
4,532
Location
Surrey, UK
How can I tell which version of SQL is installed on a particular server?
In Add/Remove I see:
Microsoft SQL Server 2005
Microsoft SQL Server Native Client
Microsoft SQL Server Sedtup Support Files (English)
Microsoft SQL Server VSS Writer

I simply cannot tell if I'm using MSDE or the full version.

Leading on from this, accessing SQL2005 remotely, will I need an additional application suite or can I use Enterprise Manager?

Cheers.
 
Back
Top Bottom