Look up Try Catch in BOL. That will help you with being able to rollback the transaction.

Tom West (3/25/2010)

---

Hi,

Apologies now, but I'm not a DBA, I'm a developer and we don't have any of the former here (budgetary constraints :ermm: )

Basically the question is...

You verify that the migration is successful by testing your applications, jobs, logins, etc.

As for migrating the jobs, You could try using REDGate SQL Data COmpare against the msdb database...

Yes there is.

Since it is two different databases, I would recommend using a certificate and a signed stored procedure. The certificate would be associated to a user in the...

There should be...

John McC (3/25/2010)

---

At least in 2k8 we have Intellisense otherwise it might be a tad difficult remembering which symbolic (or should that be shambolic) table is which 😉

Now...

GilaMonster (3/25/2010)

---

It's not you.

Remember the discussions on women in IT and how she reacts in those. There's a...

You're welcome.

If you are still interested in help, please post the new execution plans. There might be something more that we can see to help out.

Charles Barkley (round mound of rebound)

You're welcome.

I agree with Bob. This is a method that can be used where appropriate. It is not appropriate in all situations and can be worse in some. ...

There is not a single status to check. You need to perform a security audit of your system and determine what roles and users have what access.

Baseline your system before you do a backup. Compare the baseline to the counters taken during the backup. Backup will be most of the difference between the two.

Statistics IO will tell you the read information within the database. When performing a backup (particularly to disk) you would also need to capture the write information.

If you want...

repent_kog_is_near (3/24/2010)

---

>>If code is hitting your database from the application and is not in proc form, then profiler would be the better bet.

Can you filter in profiler by tablename (...