SQL 2005 32 bit code vs 64 bit code
in [Server Configuration]
|
From: IgorFl on 2 Jul 2008 17:36 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
From: Linchi Shea on 2 Jul 2008 17:44 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. "IgorFl" wrote: > 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
From: Igor on 3 Jul 2008 09:38 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 "Linchi Shea" wrote: > 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. > > "IgorFl" wrote: > > > 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
|
Pages: 1 Prev: Backup file Next: How to Create a Parameterised GROUP BY Without Using Dynamic-SQL |