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 |
|
purell
Starting Member
17 Posts |
 Posted - 2008-07-12 : 22:26:28
|
| Installed sql server 2005 64bit dev editionsql management studio opens in x86 mode. It is running in 32bit mode. Why? "C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SqlWb.exe""C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\" --this folder doesn't have the link. All it has is ASInstanceRename and sqlconf.dll.It's supposed to run in 64bit mode. Am I missing something?I'm running vista 64bit |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-12 : 22:42:51
|
| Run select @@version on installed SQL Server. |
 |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-13 : 00:24:57
|
| did you install SP2? it is a required resource with x64ManinderSQL server Architect / Admin (DEV&PROD) |
|
|
|
purell
Starting Member
17 Posts |
Posted - 2008-07-13 : 03:34:12
|
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) That's what i get.I didn't install sp2. Will do that now.quote:
Originally posted by maninder
did you install SP2? it is a required resource with x64ManinderSQL server Architect / Admin (DEV&PROD)
|
|
|
|
purell
Starting Member
17 Posts |
Posted - 2008-07-13 : 03:52:01
|
| Installed sp2 - management studio still runs from x86 folder. What's wrong? Is there something I have to do before installation?Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-13 : 05:02:40
|
I wonder if it has something with the SSMS still being 32-bit?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-13 : 08:53:47
|
quote:
Originally posted by purell
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) That's what i get.I didn't install sp2. Will do that now.quote:
Originally posted by maninder
did you install SP2? it is a required resource with x64ManinderSQL server Architect / Admin (DEV&PROD)
Nothing to worry about. You should be good.Did you have 32-bit SQL Server installed before? |
|
|
|
purell
Starting Member
17 Posts |
Posted - 2008-07-13 : 14:49:35
|
| No didn't have 32bit installed before.You mean SSMS is just 32bit no matter what?If so then is 64 bit sql any faster than 32bit? Wouldn't running in native 32bit be faster than? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-13 : 16:39:01
|
| SSMS is client tool, nothing to do with sql engine. |
|
|
|
|
|
|
Installed sql server 2005 64bit dev edition