I would bet its the DB2 interface. Your using a third party ODBC driver, aren't you? Similar to what mromm said, but I've seen that issue when using third party...

What methods are you using to get your results? Is it from properties on tables tab in EM, or a query? And in QA?

I prefer the b choice, to eliminate the locks on system tables placed by the A choice. With the A choice, the locks on the system tables are maintained until...

I agree with Steve. I use different accounts for the two on some of the systems I work with and have observed that behavior

When you say breaks it, what do you mean? Is it that you cannot compile the trigger, the trigger now errors, or it works but doesn't do the update correctly?

Syntactically,...

Your absolutely correct, AjarnMark. Don't get me wrong though. I agree with a lot of what David had to say as well. I was certianly not saying that there was...

yep

Sorry mromm, I don't mean to pick, but quite honestly, If you cannot enforce data domain integrity reliably in your SQL Server, what makes you think you can enforce the...

To be honest, I think I'd write my procs for each particular dataset returned, and use the one you have to call the one needed. Sure, its a couple new...

Why are you using two different tools that effectively accomplish the same thing? If there is already transactional replication going, why not just add a subscription for the Log...

garutyunyan, you need to get the correct permissions to perform the backup. If run through the EM or SQL agent as a scheduled job, then for the login for SQL...

I learned my lesson with them while scripting the database. Ha, that was a joke. One that took me most of a weekend to pinpoint and correct, on a then...

I remember the "Inside" series as the one that stands out in my mind as most useful to me. I read a lot of books about SQL (bout as fast...

I am a dyed in the wool, true blue believer of a dedicated Sql Server. It may not have a load today, but one or two years from now, after...

Look at the start time and last batch time. Are you certain that the same process has been running for three days? That doesn't sound like clean ups I'm used...