Thats great, thanks very much to you both !

Hi, just to confirm....you dont need Ent Edition for the  monitor.

I'm pretty sure it doesn't.  If it does someone please tell!!

We try and track ours by using 3rd party software, in our case Altiris.  This can scan all machines on...

Have you considered using restore with 'standby'.  It could only be used as read-only though.  See BOL

Hi, for the logs you could just give them the relevant command line version and set up OS access ie, for the SQL logs :- explorer \\servername\d$\Program Files\Microsoft SQL Server\MSSQL\LOG\errorlog...

Hi, it depends on the recovery mode you specify when you set it up.

If...

Hi, yes all makes sense thanks, and I understand the importance of sequences when restoring trans logs after the DB restore. 

However I still don't quite know why there should...

Yes they are just full backups. Although thats an interesting point as the one final DB we are moving from Veritas does a backup of the DB and I'm taking tran log...

Just to play Devils advocate, although we now use Data Protector (which seems less intuitive), I had no problems with corruptions when using Veritas over the last couple of years.

Where disk space permits,...

As steve says theres nothing to stop you going above the limit physically.

Youre right in what you say about devices and users although I dont believe there is such a...

Just thought I'd add.  You'll probably need to stop/start SQL Agent once you've made config changes before its effective.

Have you already tried running dbcc checkdb with one of the repair options ? (see BOL)

You can also use the page operator drop down to put an email address in.

Thank-you for that...all ok now.

Not 100% sure of the datatype youre talking about but you could try...

select convert (decimal(16,2), columnname) from tablename

16=max number of digits before and after the decimal point

2=number of digits after...