Hey Steve,

Do you get paid for scooping?  Must be a pretty penny as all I ever see you do is write all these dam editorials.

-cjb

Nice job, like you I use profiler extensively for looking into issues and/or monitoring my servers.  Like you said it's not the easiest tool to first get your hands around...

My only real bitch is that when they knew that the SP had issues that they didn't remove it from the downloads.  I patched one of the development servers with...

J I am getting an error on creation:

Msg 102, Level 15, State 1, Procedure data_driven_subscription, Line 259

Incorrect syntax near ','.

Msg 102, Level 15, State 1, Procedure data_driven_subscription, Line 288

Incorrect syntax...

I've used it and it's pretty much like what your use to in 2k. 

I don't think there is an upgrade option.  Just a base price depending on what edition.

And just to add to the fun.  IBM does not have a driver for accessing the DB2 platform. Although they have a 64 bit driver it does not work for...

Alan I respect your opinion but to say the product was "rubbish" is a bit harsh. If you look around the net you'll find a lot of free "rubbish"...

I ahd the same problem with it impacting my system. Plus it said it was a free download but after the eval it shut it's self off and was...

"I'm not the sharpest knife in the drawer"

My hockey Favorites:

"he beat him like a rented mule"

"Top shelf where momma hides the cookies"

My remarks after a large dinner bill..

"what i...

First make sure you do most of your processing at the SQL server (aggregates, sorts filters) that will speed things up.

Hi Moe,

I am assumming you are talking about population of a list or drop down in the report.  If so, is the stored proc the same as the one you...

Steve in Enterprise manager right click on the Data Transformation folder and browse to open your package.