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 |
|
punchuk
Starting Member
1 Post |
 Posted - 2011-05-12 : 03:39:56
|
| Hi,New to the Forum and by no means an SQL admin however it's a simple task I have!I have remote software that can run scripts on servers, I have created one to update Sql Server 2005 sp4 on relevant servers (all external customers) as the sp fails to install automaticvally. My only issue is I need need the script to check what version (x86 or x64) of sql that is installed.As checking the OS doesn't mean that the x64 version of SQL is installed.I've searched everywhere all I need is a file/reg key to check to tell me wether the version is x86 or x64.Anyone know?ThanksSteve |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-12 : 04:00:40
|
| SELECT @@VERSION--------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
Version installed x86 or x74 via script check