What are you suggesting by lesser environment?
We don't have any testing machine provided yet. I doubt we will get it though.
That's a very real problem. There should be a Development Environment, a Staging/Testing/UAT Environment, and a Production Environment that is absolutely separated from the "lesser" environments.
Like I said, you can hedge your bets a bit by using the Migration Advisor (not sure what they actually call it now, though). If you have MS Support, you should also be able to call them and ask them.
You also need to have a backout plan for if the new system fails for any reason. The good part about this is that you're migrating to a new machine. That means that the old machine can be left in a "hot standby" mode so you can easily "get back in business" if things go totally haywire on the new not.
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.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)