fyi, before too much complaining:

http://www.kbalertz.com/Feedback_913090.aspx

After that, send the complaints to MS.

They also say the difference between a stored procedure and a trigger is the sproc is executed client side and the trigger server side.

http://www.dotnetspider.com/exams/ShowExamQuestion.aspx?ExamQuestionId=2325

It's statement level recompile. A CTE doesn't...

Why an inner cursor? Can't you just get the data and append it to a table or variable?

Believe it or not, I do have a few friends. Or maybe it's just people that owe me for doing something

I don't...

Valid points, but if each of these databases for small and simple (no mention given), they all theoretically can be consolidated onto one server. There is a compatability mode.

The advisor...

Erik,

From what I've read in research and based on SS2K recommendations, you want to start all services with a domain user. This enables you to move the service in a...

It's been years, but I used ER/Studio and ErWIN. I preferred ER/Studio and it was slightly cheaper. Seemed to work better with forward/reverse engineering.

No idea on current pricing.

Support (3-5 years...

Dave, You are welcome and I love driving mine around the twisties. Don't even have to go that fast to enjoy driving it. I've been lucky with the repairs, although...

That's an interesting idea.

Actually I think that the insurance industry will have to drive this. As they start to cover and insure losses, they'll bring pressure on disclosure and more...

Sorry about the spelling. It's possible it was after too many beers, but hard to remember

My 914 is a 74, 2.0, and it...

Good points Dan. Appreciate the response and kudos to you. The SQL Server team has done a great job.

Maybe a month is too short, and honestly since I have no...

My apologies!!!!

The code is now linked at the bottom of the article.

I think mssql-join@lists.sqlservercentral.com will get you there.

I assume you mean SSIS not SSID

I agree with you (original poster), it's very complex. And it's no longer a quick and dirty...

Need a where clause and some ordering mechanism.

Like

select top 50 xy from MyTable order by MyID

then for the next 50, send in the last ID you got and query

select...