I'll take the contrarian view. App_name is not a bad fix, but it can be easily hacked, programmer can set it anything they want. Approles - well, they sound good,...

Extending the timeout isnt usually my first choice. If the query legitimately takes more than 60 seconds (yes, it happens), then you extend it. If you're extending it because of...

Agree. Filtering is handy, but it does have its downside exhibited here. I don't fault the behavior, it's just not always what you want.

I've not noticed a difference splitting things out. The biggest caution to consider is if you need to do a restore, making sure you remain transactionally consistent across db's. As...

I dont think that my position on this is based on being certified OR being book smart - I deal with this stuff every day and in fact I write...

We've had occasional problems with that - great fun to troubleshoot. Glad you got it working again.

Well, we don't mind hearing that either!

My two cents. Use SSWUG or whatever other resources work for you. We certainly believe there is room for more than one community about SQL. We'd like to think we're...

The pros and cons have been debated quite a bit since .Net launched. I've been using VB forever, didn't see a compelling reason to change. I'd suggest you try both,...

How long does the snapshot take?

Might be worth getting someone else to take a look at your system or a call to PSS. Off hand I can think of nothing...

Congrats from us here at SSC as well. A thousand posts is a lot of time invested in your profession (and our community) - bravo!

Re your comment about Codd, I...

For the most part it will work ok. One potential gotcha if you add a record and use a primary key that ends up getting added on the publisher later...

So you're saying it is blocking on the publisher, not the subscriber? I know you said there was no blocking - how are you checking? Are you using a concurrent...

Given that the majority of us don't use case sensitive servers I'm not sure it would make sense to require that all scripts meet that standard. I agree if you're...

I agree that moving the distributor will reduce the load, but for the most part the load generated by transactional replication is not huge.