Yash

It's not easy to condense into a few sentences if you've never designed or edited a package before. Is your code all under source control? Is the person...

Yash

No, it's in the package. You need to open the .dtsx file in BIDS and redesign it.

John

Yash

Put all the tasks in question into a Sequence container and set the TransctionOption property to Required.

John

I think you'd need a trigger to implement that sort of logic.

John

Interesting. Looks as if the maintenance plans are running...

OK, so you've opened the job, looked at the Owner field, and check that the login specified there is sysadmin? You'll need to find a different way of checking...

If the login that owns the job is sysadmin, then the job should run in the context of the SQL Server Agent account. Does SQL Server run under the...

I would strongly advise against running any service under a domain admin account. If the service gets compromised (whether accidentally or maliciously), an unlimited amount of damage could be...

There's a utility (it might even be free) that displays all your scheduled jobs in a calendar format. I'm afraid I don't know what it's called, but if you...

Srikant

My advice to your management would be to test thoroughly in advance, so that you can be as confident as possible that when you upgrade in live, there won't be...

You haven't said what exactly isn't working. I suspect that your problem is how to fire triggers from events in AD. If that's the case, you'd be better...

OK, I didn't quite understand first time. You have these two .cmd files that are triggered automatically whenever a logon or logoff event occurs (presumably on AD) - is...

I don't think it'll work if you just lift sqlcmd.exe and copy it somewhere else. It needs access to all sorts of DLLs and other stuff. Why can't...

It's not a question of whether the file is read-only - it's whether you have permission to change it. Right-click on the file and choose Security. If you...

But you don't want it running against databases that don't have the tables - that would be a waste of resources. That's why I suggested scripting it properly. ...