We recently upgraded one of our sql servers to 2005. the view is on a sql server 2000 box which queries the 2005 box
the script for the view is
select *
FROM server.database.dbo.table
I recreated the view with a different name and it worked just fine.
So I tried to rename it and it just keeps running and running
Same for alter and drop.
I think its corrupted but I need a view to have the same name because we have many procs referencing that view.
Any suggestions?:w00t: