Okay, to give you an idea of what I'm dealing with. I used the EM to script out all tables, indexes, views and...

I wonder if you cast it instead of converted it would it have worked?

Because cast is implicit conversion, convert is both implicit/explicit.

Just a...

You would need to attach them as a new database and the use the DTS (Data Transformation Service) to copy Tables/data between the existing database and the new database.

After the...

Try

CONVERT(smalldatetime, 
CAST(vg.CalYearID AS VARCHAR(4)) + '-' + 
RIGHT('0' + CAST(r.BGCancellationMonthID AS VARCHAR(2)),2) + '-' + 
RIGHT('0' + cast(r.BGCancellationDayID AS VARCHAR(2)),2) 
+ ' 00:00')

Or possibly:

CONVERT(smalldatetime, 
CAST(vg.CalYearID AS VARCHAR(4)) + '-' +...

True. Just that when you look at the EM Restore - it's a bear to skip a full. And as Steve Jones pointed out in The Value of...

I meant it in reference to recovery of the production database. My normal backup time for the DB is at 7:30PM for it to be out there for the nightly...

I haven't found a SQL Server Backup Agent (or Oracle for that matter) that I would trust to backup my dog's poo-poo.

And bare metal restores (especially in a DataCenter environment)...

Great,

But does anyone have the suggestions of a script? And what do you do about tables with no indexes?

I know the standard is that every table should have an index,...

Would that actually move the tables? Or just because the indexes aren't updatable?

This isn't a homegrown DB and there are over 700 tables. I don't want to try play with...

:madSmacking my forehead) Actually, I appreciate the offer....but I just came up with a quicker idea. Just...

The backup name changes (ie with a date/time stamp).

That's the problem. I cheat and just use the maint plan wizard to do the backups. I found the answer.

As our companies understanding is.....

If the box is not to be used in production you do not need to license it.

Also you can have a disaster recovery box set up...

I think he is looking for the keywords.....

It is buried in the BOL CREATE TRIGGER as

deleted and inserted are logical (conceptual)
tables. They are structurally...