Innovartis has dbGhost to help with this and a few articles as well as one I'm expecting to get sent here any day.

Can UDP 1434 get to the server? When you hit a server, this port allows the SQL browser to send back the port required for connection. Check for a server...

Eric,

A few things to consider, and it would be great if you could test a few things. First, if your logs will survive on 1 disk, then use a RAID...

I used to setup a separate admin database on each server. Use scripts to grab the size of each database, and you can find a few on this site.

Then use...

Glad you liked it. We'll be looking for you soon as a contestent after the online challenge !

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...