Groups > comp.databases.ms-sqlserver > #598

Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005
Date	2011-08-13 12:59 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F40842DF5127Yazorman@127.0.0.1> (permalink)
References	<bc35893b-4e20-4fe7-81b3-1472057cfb8d@u12g2000prc.googlegroups.com> <Xns9F3FE0E9C817AYazorman@127.0.0.1> <c0ef80f9-5dbc-48e2-973b-3187782c0be7@v9g2000pri.googlegroups.com> <Xns9F3FE42F6260Yazorman@127.0.0.1> <e0585c66-f0f3-4c0d-ab94-1297770be493@y39g2000prd.googlegroups.com>

Show all headers | View raw

xo (xo5555ox@gmail.com) writes:
> I am bound by the decision maker not to change the structure of the
> view but to find out why it is working on the old 32-bit SQL server
> 2005 but not working the new 64-bit SQL server.   Thanks
 
And you have gotten the answer: by chance. It could start failing on the 
old server tomorrow.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 10:33 -0700
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-08-12 14:56 -0400
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:05 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-08-12 16:56 -0400
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:06 +0200
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:17 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:25 +0200
        Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 14:31 -0700
          Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-13 12:59 +0200

csiph-web