IN place method for the database upgrade SQL 2000 to 2008,
Can I go for below one of the steps?
first database brings to single user in SQL 2000 database, then start upgrade installation on sql server 2008. once completed installation then apply SP3, finally database brings to multi_user mode
No... Don't use the single user connection mode for this because if you lose connection for even a second, a web service will grab the connection and you'll be out of luck.
The proper way to do this is to make sure that all of the web services pointing to the server have been cleanly shut down.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is usually not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs