Thanks Steve.

FWIW As part of our daily backup scripts we run checkdb on all production databases prior to the daily backup taking place. If problems are found then the database...

Just a thought Pearl but wouldn't you be better posting this on the Redgate Support forums or perhaps giving them a call directly?

Their support really is very good.

Cheers Anthony! Exactly what I was after... many thanks.

Hi Emile,

Do tell if you have the time... this thread has my curiosity now!

Our entire SQL environment (DEV, TEST & PROD) are virtualised running under VMware vSphere v4.1.

Thanks Koen for your reply.

I have been 'playing' with SSIS but find it difficult to know which task/s to use for this purpose. I'm rather hoping I don't have...

Thanks everyone for your advice.

Thanks Dev.

I was looking into this when you replied. Any idea what permissions I would need to grant to allow a login to see other user processes in Activity...

Quick Update...

Perhaps I should have mentioned that i'm using the 2008 R2 version of SSMS to manage our SQL 2005 environment.

This morning I started to see 2 x System Databases...

Hi,

There are numerous tools out there... a quick google search will enlighten you! This topic has also been discussed within these very forums.

Redgate's SQL Monitor is one as well...

Nope...

It will default to the dynamic TCP port configured within SQL Server Configuration Manager. You will probably want to change this from a dynamic port to a static port.

It...

Thanks Steve.

lol... trying really hard not to create the tables manually 138 times!

I've never used the import/export wizard within SSIS but looks like it might do the job - thanks....

There I was just reviewing your Performance Tuning Video from SQL in the City!

By the way thanks for the informative presentation.