sqlfriends (12/5/2012)
Thanks, but it seems detach and attach is easier and involves less steps to do.
Do whatever you feel comfortable with, just know that in SQL server 2005 on ALTER DATABASE is the preferred method
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉