Hi

It looks a very useful and worthwhile project but it would be good to know if the authors thinks this should also work with the more numerous SS2k8 installations out...

I found cdc to be ott for tracking user data changes, besides I only had standard edition to work with so I looked around and found Standard CDC on codeplex....

Koen answer is pathetic and folks should not comment on things they know nothing about. A file share relies on a mutual internal server and that's not what most web...

Thanks for improving the code, Lynn. It's 11 pm here in the UK and I'm using that as an excuse.

It would have helped us respond to you quicker if you'd kindly posted a table create and data insertion SQL. It would also have cleared up any assumptions about the...

Have you tried calling the proc recursively in the catch block with a parameter indicating the progress?

Just in case anyone was looking for a post SS 2k version that avoids cursors (and dare I say more readable?) version.

/*

uspRefreshViews

Date: 2012-03-13

purpose: to refresh the schema bindings of the...

Bit of a stale thread but I thought it might be worth updating that StreamInsight is available in all editions other than express.

Interestingly, although using Select TOP 100 PERCENT with an ORDER BY clause results in the sort order being ignored, specifying Select TOP 99.999999 PERCENT will honour the ORDER BY.

I'm...

well, thanks for sharing your answer. Not.

Shame on you after so many folk tried to help you. This is a community after all.

Hi Ganesh

I know this was some time ago but I have the same problem and I'm wondering if you ever found a solution. If you have, please share, if not,...

@SSC Veteran: Thanks for the final clue to this mystery. I was actually putting in my top level package name and not the literal 'Package' Doh! Still, looks like I'm...

You could try setting up a test where you schedule two jobs to clash to say, increment an integer column in a test table and see what happends. if they...

I think you might want to look at enablaing/disabling package steps in ActiveX scripts dotted about the package e.g. at the beginning...

 set pkg = DTSGlobalVariables.Parent

 set stpFinished = pkg.Steps("DTSStep_DTSActiveScriptTask_3")

 stpFinished.DisableStep = True

Then...

As Grasshopper says, there are tools out there to help your present need. Another is Log P.I. to be found at http://www.logpi.com/ I have no experience of either...