Its a disheartening message to see! Try stopping your agent, then modify the job by adding -outputverboselevel 3 -output c:\repllog.txt - then you can see real time what is going...

Worth checking to make sure all your SET params match, more than once I've see things go bad because there were differences between what QA used and production used.

Jimi, that's not quite correct. Here's what it says in BOL:

output_table cannot:

• Have enabled triggers defined on it.
• Participate on either side of a foreign key constraint.
• Have CHECK constraints or enabled rules.

You...

I caught the tail of Carl's post just now, pretty much the same thing. Allow the user to flip a bit, or even insert an entire script into a queue...

I think the trick is to use a job, but not let the user start the job directly - avoids the proxy account issues.

I think taking the exams is the most valuable to someone that is new(er) to the profession, because it drives learning. If you've been a DBA for a while it's...

iPhone? Or at least a giftcard for one?

I put a lot of images in the db as well and believe its a valid technique. Always surprises me that even those that believe in SQL as a platform...

There is also a place in the profile to list a home page url - its what you get directed to if you click the WWW button under each individual...

I agree that you don't have to buy a book, but I think its absolutely worth buying at least one book per exam. Most of the people I've seen that...

Was just looking on the dbghost site and it says you can manully check the scripts into other SCM's (which I grant seems like more work) so at least not...

Not all of us - or even most of us, work in cross continent scenarios, but Im here to learn. The discussion seems valuable. Malcolm & others, you should approach...

You can probably find a script in the library that will handle this for you. If you still want to do the maintenance plans you have to hack at it....

Stamp isnt the greatest choice because it isn't unique, but I bet its how you access the data most commonly? Recordno would be unique but putting the clustered index there...

He is in a tough spot, but thats the life of an editor! He's luckier than most to now be insulated from the pressures of advertisers. That said, I agree...