Post reply

Difference in Task manager and SQL Server Management on 64 Bit

  • February 23, 2012 at 9:21 pm

    #265220

    Hi All,

    My task manager says I'm using a 32 bit SQL Server like "sqlwb 32*' but my Management Console says it is a 64 bit version when i query through @@version.

    Why this difference?

    Thanks,

    Regards,

    ami

  • February 24, 2012 at 1:23 am

    #1451215

    sqlwb32 is actually Management Studio, not the server itself. @@Version will give you the version of the server you're connected to.

    So in your case you are using a 32-bit client which connects to a 64-bit server.

    [font="Verdana"]Markus Bohse[/font]

  • February 24, 2012 at 2:32 am

    #1451246

    I queried from the same server management console only. not connecting to the server from client machines.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply