Refer to Books On Line (BOL) at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/0a760138-460e-410a-a3c1-d60af03bf2ed.htm
The above page provides an example T-SQL statement to do what you want to do.
Be careful changing the schema may invalidate previously written stored procedures, functions, etc., etc.
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]