ryan thanks alot for the info.

robert. are you referring to the package protection level?

when we are in development we EncryptSensitiveWithUserKey enabling each developer to do their own thing while working...

<ryan>

Interesting, that's how we'd like to ours to behave.

We use SQL Agent as our job scheduler. Stopping the job step leaves a thread of dtexec running the package and it...

The approach of setting an environment variable in the scope of the batch I do like. Our relative path method for configs and logs works great for a one time...

This topic definitely needs more attention. It wasn't/isn't a pleasant process. So great job on laying some ground rules.

Being able to promote smoothly through environments (4 in our case) was...

The best of wishes to you guys - this site was.... nay IS .... and WILL BE my first port of call when on my SQL wanderings. Thanks for everything...

Restarting your web server can never hurt with this kind of thing - assuming it's not a production machine! Sounds like IIS is keeping an open thread somewhere, it might...

To the debugging Shew: the sp debugger in QA is great, I've been lamenting it's absence since 6.5. Watches, param setting, breaks, autorollback - no more print.

As for dynamic sql:...

Thanks very much for the link. It was a curiosity thing, definitely a neat idea.

TheWildHun,

That's is pretty much exactly what I am doing. It's for report formatting exactly, I'm using it to break out the different levels of aggregation applied by WITH ROLLUP. It's...

I'm looking the GROUPING function applied to the GROUP BY clause of my built T-SQL.

I just need a better discussion of it than BOL has - kinda helpful but not...