You can't, as it's a necessary warning. However, is there a good design reason as to why the table exceeds the maximum row size?

No, I don't condone it, but I do understand the realities of the situation. My mom is Japanese. I was taught to do it right or don't do it at...

Sure, and I think ideally we'd all agree with Rudy. However, realistically we know what many businesses settle on, which was the point Richard was making and also what you...

Let me preface this all by saying I don't use replication a whole lot myself. Therefore, if there is someone else (such as Andy Warren) who does, you should probably...

You're right, there's not a whole lot of guidance there. Looks like distributor, publisher, then subscribers should be fine based on the guidance they provide for MSDE.

If you follow the Principle of Least Privilege, then the service accounts should be configured with the minimum privileges necessary. That means no administrative access because that's not needed. However,...

In that case, C isn't the correct answer (as another poster indicated). The reason is because even putting in the paramter of "HIGH" or "LOW" doesn't make the query work,...

There are free monitoring tools like HP's System Insight Manager which can do this kind of monitoring and more. Is that an option?

Otherwise you could consider building a stored procedure...

What type of replication? Transactional? Merge?

Rahul's solution works if you change the hard number. For instance, if you have 3 options, change the count to = 3. I'll do some looking around and testing to...

Sure. When you install the Windows operating system (NT 4.0, 2000, XP, 2003 and any based on the NT kernel), any drive letters related to hard drives are automatically shared...

The reason they work is because they are using a grouping function, COUNT(*) and comparing the number of matches with the total number of options that have to be matched....

The short answer on clustered setups is no, the service accounts do not need to be members of the local administrators group, except for Windows NT 4.0. More here:

Which one is C?

If the batch processes are running with sysadmin level privileges or anything that would map in as a member of the db_owner rule, you could set the database in RESTRICTED_USER...