FYI, With help from naveenka on another forum, I think I found the problem.

The package uses an SSIS Package Configuration, that is pointing to the "SSIS Configurations" table in ...

"truncate table" as the first step in the package.

Great script, Thanks !

I had a few databases offline, so I did this to ignore them:

-- I added the "status" field check for SQL 2000 & 2005

SELECT name

...

Those are links to SSIS 2008. Are they applicable to 2005 ?? Or are there big differences between 2005 SSIS...

randy.witt (9/16/2008)

---

What I was thinking, was to set up application roles, each permitting access to a different set of stored procedures and/or views in a particular database. Simplified examples...

I think SQL Server magazine has done some ratings of various tools.

Just call them up...

Then you would need linked servers to...

You could code something like this:

[font="Courier New"]SELECT MIN(Table_1) as Table_1, Fld1, fld2, fld3

FROM

(SELECT 'Table_1' as Table_1, a.Fld1, a.fld2, a.fld3

FROM Table_1 a

UNION ALL

SELECT 'Table_2' as Table_2, b.Fld1,...

What method are you using to restore when it fails ?? Perhaps it is pointing to the wrong drive ?? For example, you manually restore to E...

Do you want to know if the data in the tables is the same ? Or if the table schemas are the same ?? I wrote some...

Nice reply. GSquared !!

Wouldn't simply replacing the DELETE with TRUNCATE help a tiny bit ?

You can buy a tool such as Idera's Compliance Manager. It will alert you about any number of SQL changes.

I've never had a problem backing up or restoring via UNC path in SQL. I don't do it a lot, it's not ideal, and it's slow, but it does...

Thanks for the replies. I think there are some hiccups on our VPN that's causing the problems. I heard a couple of others here are having the same problem, along...

Sounds like you're referring to logical devices, not a separate machine that has tapes.

I prefer to keep all the databases separate. I don't use backup devices. I backup each database...