It is impossible to say whether what you want to achieve is possible or not. That depends on how different the databases are.

But SCHEMABINDING is not your guy. SCHEMABINDING...

Three million rows in three hours, now that is slow! Then again, how does the table look like? Are there tons of blobs or what is the average row size?

You...

Yes, you can upgrade from Standard to Enterprise by running the Setup wizard. A downgrade on the other hand, requires a reinstall as a recall.

I get worried when you say that you are a 24/7 shop and you have a restriction on log-file size. This does not bode well, and you will get hurt...

1. The tables referred to into the view, directly or indirectly through other views.

2. The schema of the table cannot be modified freely. You cannnot drop or alter columns referred...

;May I ask why you want to do this?

In any case, the answer is yes. You need to create an explicit user for the login in the master and then...

When you add the EXECUTE AS clause to a procedure you impersonate a database user, not a server login. If you are logged in with sysadmin rights when you create...

Thanks for the update. Yes, that is definitely a bug. Good to hear that MS has a fix.

The latter is a live table. The others...

They are very different. A differential backup contains the pages changed since the last full backup. A log backup does not include any pages at all. Instead it contains instructions...

Yes, I have not worked much with diff backups, but I think they are mainly useful with databases with very few changes. Beware that reindexing jobs are changes, and reindex...

Because you need to restore full backup + diffbackup + log backups. So that...

Is the # followed by eight hex digits? In that case, they are temp-table definitions that SQL Server has cached. There is no reason to meddle with them.

That's almost...

See http://www.sommarskog.se/dynamic_sql.html#OPENQUERY for some tips.