November 1, 2010 at 7:07 am
Some clarification here, if I want to install standard edition does it mean i am installing 32 bit sql server or does it have 32bit and 64 bit standard edition and likewise in enterprise edition too ?
If there is a difference with in standrard eidtion, how would i find if the existing installation is a 32 or 64 bit standard?
November 1, 2010 at 8:07 am
If there is a difference with in standrard eidtion, how would i find if the existing installation is a 32 or 64 bit standard?
Running select @@version on the instance would tell you whether it is 32 bit or 64 bit.
If it is 64 bit then the out will be like
***** Edition (64-bit) on Windows....
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 1, 2010 at 8:11 am
SQL2005 std comes as well in 32 bit as 64 bit.
std vs ent edtn,... have a look at
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply