32 bit XPs on 64bit?

We've got two Extended Proceedures that work fine on 32bit, no bugs and
never AVed the server.
We are about to move to SQL Server 2000 64 bit, and will also evaluate SQL
2005 64bit.
Will these 32bit XPs work fine without change in SQL 64? Or will a simple
recompile with a 64bit compiler make it work in SQL 64bit?
Yeah Yeah Yeah, I know all about CLR in Yukon, I'm not asking that question!
"Bud Y. Zer" <bud@.Gibralter.Bra> wrote in message
news:%23$8V4LzrFHA.248@.TK2MSFTNGP14.phx.gbl...
> We've got two Extended Proceedures that work fine on 32bit, no bugs and
> never AVed the server.
> We are about to move to SQL Server 2000 64 bit, and will also evaluate SQL
> 2005 64bit.
> Will these 32bit XPs work fine without change in SQL 64?
No. Extended stored procedures are dll's loaded into the SQL Server process,
and a 64bit process can only load 64bit dll's.

>Or will a simple recompile with a 64bit compiler make it work in SQL
>64bit?
It depends on how the dll's are written.
See generally,
http://msdn.microsoft.com/isv/techno...q/default.aspx
There are things you can do in C++ which implicity rely on pointers being
32bits.
David