There's also the data layer vs data ACCESS layer vs Business Layer argument. Embedding SQL calls just screws up the separation in my mind. It's not always a...

The interesting thing to me is that I don't think you could get the "experts" to agree on what constitutes the "complete" set of variables to look at. A...

Funny thing - I've always thought that BI solutions took a GREATER level of expertise to build than typical solutions, since you have to a. model your data correctly to...

Careful...It's expensive stuff...:)

This is the kind of thing where the kind of outages are limited only to your imagination.

Causes of outages (all of these are real):

- dust (seize a hard drive,...

Shared accounts can be problematic at times, but only if the apps are configured to use the cached credentials, which are a vulnerabiliity in and of themselves.

The problem is -...

Backing up the log TRUNCATES the log (meaning - it will remove transactions that have been committed -and if replication is in play, have replicated - so that the space...

Joe Clifford (3/20/2008)

---

Given that we're talking about SQL 2005 there are various encryption options available to prevent exactly what the original poster was asking about - the risk that someone...

patrick h (3/21/2008)

---

Matt,

Yes I think so, but even if a put a commit or rollback right after the exec, the message remains. I'm trying to figure why...

Still, when I execute...

It returns a table variable, so the table variable will be materialized to RAM if there's enough room and the table isn't too large. If it IS large, then...

Aristotle and Archimedes would be proud (one of them would be).

Archimedes:

"Give me a long enough lever and a place to stand, and I will Lift the World"

And Aristotle had his...

Greg Charles (3/20/2008)

---

Neither of those options works for me. When I select 'Delete', I don't get to choose a version to delete. The package is deleted. I...

You can do it from within Enterprise manager. Right-click on the DB, all tasks, Generate SQL Script... follow the wizard. It will dump them all into a directory...

Have you figured out how B is getting run? In other words - is it a job being run? DTEXEC?

Does package A invoke anything starting/scheduling tasks?

How about creating...

I am reading that to say that whatever you are calling with EXEC is starting a transaction, but not performing a COMMIT or ROLLBACK there. Is that a possibility?