Any issues with SP2 and 2005 x64?

I came across someone who mentioned in passing that there are lots of issues
with SP2 and x64, is that true? Are there any significant differences to be
aware of between SP2 on x32 vs x64?
TIA
Michael MacGregor
Database ArchitectMost of my clients run SP2 on X64 with no problem. I would rather run on SP2
than SP1.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Michael MacGregor" <macnoknifespam@.noemailspam.com> wrote in message
news:Ot3z3zaFIHA.3548@.TK2MSFTNGP06.phx.gbl...
>I came across someone who mentioned in passing that there are lots of
>issues with SP2 and x64, is that true? Are there any significant
>differences to be aware of between SP2 on x32 vs x64?
> TIA
> Michael MacGregor
> Database Architect
>|||Thanks Andrew.
MTM

ANSI Nulls

I've mentioned this before, but now it's got me stuck. I have a
table-valued function that was created using QA in SQL 2000. I can't
edit it using 2005 Mgt Studio, because the property AnsiNullsStatus
isn't set (apparently SQL 2000 forgot to set it when creating the
function). Now I find I really want to edit it in SQL 2005 MS without
going to SQL 2000 QA on my laptop. So, using SQL 2005 MS, I dropped
and re-created the function, having obtained the code from SQL 2000 QA.
That should fix this, right? When SQL 2005 re-creates the function, it
will specify whatever it needs. But no, I still can't edit it! The
property is still not set!

Can anyone help? Please?

Thanks,
Jim GeissmanHello, Jim

It's a known bug. See:
http://lab.msdn.microsoft.com/Produ...ackid=FDBK38845

Microsoft tried to fix it in SQL Server 2005 SP1, but did not fully
succeed. However, on SP1 you can script the function in Management
Studio, by choosing "Script function as Create" (but it still doesn't
work with "Modify" or "Script function as Alter").

Razvan|||Thank you, Razvan.