I would agree, this kind of feels like a security context problem..

CEWII

Great, the syntax is [pretty clear once you see it..

CEWII

Not a problem, those kind of jobs are the single most common reason that history disappears. I would bulk up the space available, I like to have like at...

They are my initials, CEW and since I am then second it is CEWII..

CEWII

I think I'm thinking along the same lines as Steve. Why don't you create a single table that they all share and their data is seperated by some id...

Actually in SQL CLR programming you are limited in what you can add as a reference, you have to add the assembly to SQL Server FIRST then you can reference...

I was unaware of that.. Reporting services is doing it? If so my guess would be that it is so important for it to be at the SQL...

I've been asked for a solution that will allow two separate data centers to keep two separate copies of a database (or many databases), both of which can be written...

Maintenance plans have a table in msdb to store their history apart from SQL Agent. Are the maintenace plans being run from SQL Agent? When you look at...

First if your variables are defined at the package level then this syntax should work for you:

\Package.Variables[VariableName].Value

If they are defined in other containers then it is a bit more complex...

I think Bru is on the right track.

Simple answer

Maintenance plans do maintenance on databases, ie: backups, re-indexes, etc.

SQL Jobs are scheduled actions.

Therefore, they are are used together. The SQL...

How about:

IS_MEMBER ( { 'group' | 'role' } )

Arguments

' group '

Is the name of the Windows group that is being checked; must be in the format Domain\Group. group is...

It would probably be better to do a direct compare and highlight differences. Another twist, what happens if there is more than one change, ie: a change occurs and...

I believe SQL 2005 may re-install the MSDTC with an updated version. But I;m not sure about that. I don't think you have a choice but to install...

I have been stewing on your problem and don't think your solution is probably the right one. I see a few issues like how do you distinguish maker updates...