Viewing 10 posts - 1 through 10 (of 10 total)
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...
April 28, 2010 at 9:50 pm
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...
April 27, 2010 at 11:19 am
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...
April 27, 2010 at 9:03 am
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...
April 26, 2010 at 9:46 pm
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...
November 14, 2006 at 6:48 am
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...
May 12, 2003 at 3:43 am
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:...
April 25, 2003 at 6:57 am
Thanks very much for the link. It was a curiosity thing, definitely a neat idea.
April 15, 2003 at 5:07 am
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...
April 14, 2003 at 2:27 am
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...
April 11, 2003 at 2:44 am