I build separate logging into that kind of script. It checks its own log to see if a database has had a full backup in the expected timeframe. ...

Pull the data into a staging table that has a varchar column instead of a date/datetime column, for that data. Then you can use an SQL script task to...

CASE can do odd things to datatype precedences, especially with things like zero-length strings (which can default to numeric datatypes, oddly enough, since '' = 0, per SQL Server).

Try using...

It's doing a Diff on the one you restored. Obviously, that database has a restorable Full backup, since you just used it to restore the database, so it can...

If I understand the requirements correctly, it would look something like this:

IF OBJECT_ID(N'tempdb..#T1') IS NOT NULL

DROP TABLE #T1;

IF OBJECT_ID(N'tempdb..#T2') IS NOT NULL

...

tyson.price (11/12/2012)

---

GSquared (11/6/2012)

---

Does your data take "leap seconds" and things like that into account? There have been several over the last 42 years. They don't matter to very...

One instance will work, but I'd keep the training databases on a separate instance, or even in a separate virtual computer, if it were me. That way, you can...

Jeff Moden (11/11/2012)

---

@Gus,

Although I certainly appreciate the self-healing nature of XML to automatically capture column additions deletions to the table, full row auditing is already expensive from a storage standpoint....

Have you set a default value for the variable?

Jeff Moden (11/9/2012)

---

GSquared (11/9/2012)

---

Jeff, if it helps, here's a version that looks a little more "SQLish". It does essentially the same thing as Magoo's code, but uses subqueries as...

Not a hijack. It's a valid and relevant point.

Select Into is used to create a table. Insert Select is used to insert data into an existing table. You're using Select Into, and getting errors from that,...

Jeff, if it helps, here's a version that looks a little more "SQLish". It does essentially the same thing as Magoo's code, but uses subqueries as an intermediate that...

Does the table you want to insert the data into already exist, or are you creating it from the Select query?

If it already exists, add the correct Insert statement before...

I've seen issues with both performance, and with the expected results of the query, being worse in the first one. If you use Update From, make the target of...