You can do this multiple ways.

You can insert all the data from the restored tables, which may result in some duplicates if you don't have constraints to overwrite this.

You can...

Thanks for the update and glad it worked.

As an FYI, I don't recommend dump devices and would just back up to disk files. I'd use a different file name every...

I think what someone is asking is how many rows are in the table when you start (last week and this week).

Are you adding indexes later?

Could you be adding enough...

What's wrong? the older drivers from 2000 should work, although some of the newer features and keywords might not work.

How is the login that is having issues connecting to SQL Server? As a SQL login? It won't have Windows credentials to pass through the linked server.

There are not files within a .Bak file. There might be multiple backups stored within one file, but you cannot delete some of them now. You should back up to...

I'd set an view up on the linked server, select a, b, c from newserver.newdb.newtable, and then use the view for updates. That way you won't have to...

Not many people auditing, or maybe caring, ...

or maybe awake :hehe:

What version/edition of SQL Server is this?

It's got to be auto-close somewhere. Be sure you're not getting auto-close for another instance. Code might do it, but I can't imagine anyone...

Only if you send HTML mail and put color code in it.

Or create a quick VM, restore MSDB to a SQL instance there and then script out the jobs.

I'd keep a VM around for stuff like this, install Windows, SQL, then...

What do you need to do? Are you administering SQL or developing?

Powershell/SMO/DMO have various scripting methods.

Also http://www.sqlservercentral.com/articles/Administering/2896/

Indeed. I think that sometimes the choices of setting names is strange.

Don't smoke, never have, but I have to say having someone regularly grab me to come chat outside was something I enjoyed, being upwind of course.