I think you are confusing a number of things..

peer-to-peer replication is not typically used in cluster configurations because the database files are on shared storage and onyl one server may...

I absolutely agree it can be done with service broker, but for...

About all you would need to do is change the preferred node for instance 2 and add node 1 as an available node using the SQL install program. This...

I was gonna say multiple jobs as well, but I would push SSIS instead. You would have much greater control over the process and order if you do it...

You are missing an important fact about sa, I understand that sa has no rights on the other server, HOWEVER, when a job is owned by sa it is run...

No, that would only let you run the package from VS by hand, so that doesn't solve your problem at all.

And BIDS doesn't really use DTExec to execute the package...

I was a little confused where you said if you run it with the service account it succeeds but as a job it fails. Can you describe how you...

SQLRNNR (7/8/2011)

---

Elliott Whitlow (7/8/2011)

---

...If you have things that you want to monitor often it makes sense to have the instance gather and store that information for later pickup. For...

BIDS will let you do development for any edition of SQL, even ones that you don't own. I would surmise that DTExec evaluates the edition and won't let you...

Under "Executed as user: xxxx", is this user the same as the service account?

Do you need to use credentials? The job could be owned by sa.

Perhaps I...

Thanks, that was good information to have but I am looking for much deeper information, I want to read the files directly without going through SQL in addition to reading...

This is a fundamental change from DTS to SSIS. You cannot modify other objects in the package directly either from activex or script tasks. What you are trying...

In my mind it isn't a one OR the other proposition. If you have things that you want to monitor often it makes sense to have the instance gather...

The "spaces as part of the key" is just crazy.. Whoever designed that needs a talking to.. If you can't see it, it can't be part of the...

The DISA website for SQL is here:

http://iase.disa.mil/stigs/app_security/database/sql.html

I was working in a STIG compliant environment where EVERY server was required to be compliant.

Items labeled at Category I: DG0001, DG0067, DG0128, DG0129,...