Thank you, Milvards, thank you, Chiragkhabaria 😉

I got to the same conclusion: the script works fine for both SQL2000 and 2005 if you apply the change mentioned above by Milvards.

The...

Thanks, man, I hope it works (for both 2000 and 2005). I'll give it a try today.

(I really don't care how it looks as long as it does the job...

Milvards, you are right, the script doesn't work for SQL2005 and I need it, too, for both 2000 and 2005 versions.

I had a couple of attempts on this but failed....

Andy's script is great but not so clean.

I ran it against a SQL2000 database trying to drop a column along with all its constraints/indexes. Here are the issues I...

Just wonderful ! Thanks a lot !

Oh, just one suggestion: if, let's say, column not found, then cursor is not deallocated and script fails next time you try to run...