Friday, February 10, 2012

Build Question

Hi:

I am confused with the build versions in SQL server.

When I install in my XP local machine...when I say select @.@.version i get the following...

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

In my Enterprise 2003 server I get this...

Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

I am concerned with the compatibility when I am using service broker between two sql servers...why do i get 2 different build versions...?

those are the Windows OS build numbers, nothing to do with SQL Server. The SQL Server build number in your output is 9.00.1399.06.|||Thanks Simon.

No comments:

Post a Comment