Great overview. I'm curious, must each user have Infopath to even fill out the form? If so, that would be a serious limitation.

It sounds like a great workflow type solution.

There's lots to be excited about in the next release of SQL Server (B2). B2 should be out next month last time I heard BTW. It's going to be a...

Good point Lee. Wow, I never thought this one would generate such discussion.

Maybe I should write some real bad questions to generate traffic

I killed everyone's answers and restated the question slightly to add the IN clause.

In BOL under sp_change_users_login, db_owner cannot use the AUTOFIX parameter since it may create new logins. 

We try realllly hard to keep this a free site. That's why you see those banners all over the place. We feel it's what has led us to nearly a...

The main thing to keep in mind also in this is that the contest can't typically be won by forum posting alone (as you can see with the existing contest)....

Bill, I think this is one of the bests solutions so far. If someone likes your answer, they give you a star or point. We show those in your signature...

But really the performance, connections and type of applications you run against the server doesn't affect the edition of SQL Server. Each of the main two run equally as fast...

No worries mate.

Not sure what you mean by this? Report Services is a core SQL Server product now and not an advertiser. I was just trying to get everybody's skills somewhat sharpened...

Ouch! Wow, that was a little ambigious wasn't it. You actually design them in Visual Studio and I thought I was just making...

My only problem with the replication solution is the number of schema changes. If that is minimal, replication rocks!

Good discussion . What's wrong with shipping the tran logs every 15 mins? I would actually prefer that to lessen the spikes in network...

All fixed! Sorry about that. Late night.