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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-12 : 08:01:07
|
| Griffin writes "How can you check (in VB for example) if a computer (local or accesible thru LAN/InterNet) has MSDE or SQL Server installed? I read that running SELECT @@Version will give you the description as well as the service pack installed. However I'm not sure if this will always be in English or in some other language.Your help will be greatly appreciated.Thanks.Griffin" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-08-12 : 19:38:18
|
| SELECT case when substring(@@VERSION,123,1) = 'D' then 'MSDE' else 'SQL Server' endor select SERVERPROPERTY ( 'Edition')or select SERVERPROPERTY ( 'Engine Edition')--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
How to check if MSDE or SQL Server