SQL 2005 32 bit code vs 64 bit code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IgorFl - 02 Jul 2008 22:36 GMT

Hello everyone.
We have developed and application in 32 bit SQL 2005 some of our clients are
using 64 bit SQL 2005. My question is: if I transfer my 32 bi DB into 64 but
enviroment would it work or I might have issues?

TIA
Igor F

Reply to this Message

Linchi Shea - 02 Jul 2008 22:44 GMT

If you are talking about the tables, procs, triggers, and so on, they should
just work fine. But if you are invoking code external to SQL Server (e.g. via
linked servers, xp_cmdshell, etc), you need to make sure that code works on
64-bit.

> Hello everyone.
> We have developed and application in 32 bit SQL 2005 some of our clients are
[quoted text clipped - 3 lines]
> TIA
> Igor F

Reply to this Message

Igor - 03 Jul 2008 14:38 GMT

I have some functions written in .net, as far as I understand .net should
handle 64 bit as well as 32 but I am not 100 % sure. Have you ever had a
situation like that? TIA
Igor

> If you are talking about the tables, procs, triggers, and so on, they should
> just work fine. But if you are invoking code external to SQL Server (e.g. via
[quoted text clipped - 8 lines]
> > TIA
> > Igor F

Reply to this Message