Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-25 : 03:53:03
|
| Dear All,we've two servers one is with 1)windows 2003 server 32 bit ...sql server 2000 with sp12)windows 2003 server 64 bit ...sql server 2005is it possible to create a linked server between these two servers without any issues?please provide me steps....thanks in advanceArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-25 : 11:57:22
|
| Yes you can. You do same as you do in SQL 2000. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-25 : 12:51:51
|
| thank you very much sodeep...implemented successfullyArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-26 : 03:52:57
|
| can i insert the data from 64 bit to 32 bit also?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 23:17:42
|
| Sure you can. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-29 : 15:54:48
|
| 32-bit is compatible with 64-bit . |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-01 : 01:03:02
|
| is 64 bit is not compatiable with 32 bit?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 09:20:51
|
| Yes it is. |
|
|
|
|
|
|
32 bit sql 2000 to 64 bit sql2005 linked server