Yeah, not smart. I am now using another login that has system and server roles.

I asked our development team about this issue and they added 2 tables for document management unbeknownst to the DBAs; Communication is key. Thanks for all your help.

I really don't know what you mean, so here it is:

ON compression

These are FULL backups

NO we are not backing up to multiple files,

Our database use two files (Data and ...

RESTORE VERIFY FROM DISK = '<backup_file_location>' returns:

The backup set on file 1 is valid.

This is a full backup

We are not backing up to multiple files.

No I am not

I was hoping I could add a T SQL task to my management plan and pass in db_name() and a comment that would then insert a record into my logging...

thanks much

That was what I was looking for. Thank you.

I am able to create the linked server via script, but when I drill into Catalogs, by clicking the "+", management studio just hangs and does not give me any...

The database is really pretty small, less than 100 MB in size.  I suppose I could script the database without primary/foreign keys, then simply dump the data.  I just have...

I know that you probably want the answer straight away, but if you did a search with Google on deleting duplicate records in a database, you will come up with...

I think I figured it out, somewhat anyhow.  I just forgot to take into account hours within a day that have the same temperature.  I can manipulate that programmatically, however. ...

That is strange, because I just ran it again against your temporary table, and it seems to work.  I wonder why it will not work against my table

Thanks, Dave, but when I run that query the returns back nothing.

Yah, I noticed yesterday that I had to make it a left outer join.  Thanks everyone for their help.