No idea. I know that doesnt help much!

Andy

http://www.sqlservercentral.com/columnists/awarren/

Guess not. I'd appreciate a follow up note once you figure out if it works or not - someone will ask it again, sooner or later!

Andy

http://www.sqlservercentral.com/columnists/awarren/

I'd start by making sure you have a good connection. Can you ping the server? Open a connection using QA?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Doesnt affect replication other than the possible blocking that might occur.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Pretty tough I think, it contains a fair bit of code. You'd have to be able to read the transaction log, figure out which subscriptions existed and what changes should...

Logging via triggers is ok, but instead of triggers give you some options that werent there previously.

Bravo to anyone who at least traps for the error if it should occur....

Havent tested, but dont know that I'd agree. The problem with the while is you're continuously reevaluating the condition, which maps out to the worst type of cursor - dynamic.

I...

Is the domain account a member of local admins? Might start by adding it there, see what you get.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Not that I know of. You'd have to query back the value.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Tis a good question! Let me ask. Yukon is tricky with the NDA.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I'll second the vote for no direct data access from any app. This is a huge thing, not just for security but for being able to test and reuse...

I'd recommend turning the logging on for all agents via a switch in the job. I've used queued updates with no issues at all. Not clear from your post, the...

One way would be rename the table, fix the column names, then create a view on that table that aliases the fixed column names back to the original. All your...

You can accomplish the same thing by adding the logging switches to the job (-outputverboselevel 3 -output c:\repl.log I think). When it hangs up, you might check to see if...

Would depend on how long your snapshots take to complete.

Andy

http://www.sqlservercentral.com/columnists/awarren/