I have a very large database in 2000 and I'm thinking of requesting that
it be moved to 2005. I've heard that 2005 is faster and I've seen the
interface for it and it looks like it combines Query analyzer with the
standard interface tools. Enterprise Manager is just so limited and clunky.

Do you think I'd run into problems with my site if I had them update to
a new SQL database? Any pitfalls? Warnings? What should I look out for?

Is it worth it for the new security and interface features?

Thanks