Malik (3/2/2007)

---

i know I can replicate views to table (only indexed views) and i know i can use a query to replicate to table. But my question is HOW? I...

Yes, I meant rows not propogating. I mislabeled it. The problem has not returned since I reinitialized it, I am just confused as to why it happened in...

Very nice article and very useful query.

Just out of curiosity, why did you decide to make it a procedure instead of a view?

Naturally you would lose that order...

In certain cases, creating barriers to entry can help preserve a community and keep it active without being overactive. There can be a value to it.

However, I do not...

Thank you. That is a good thought, but I checked, and I don't have filter. The other thought I had is someone could have deleted the rows from...

The article was well done, but it was much lighter on content than most articles here. A little more depth to this otherwise good work would have been nice.

This was an excellent article and well written. And I cannot overemphasize the point you made about code readability. In fact, I think my team is getting tired...

It is unlikely that you would break something, though it is possible since it will try to enforce things like unique constraints onto the base tables. Also, schemabinding may...

Thanks everyone. It looks like it is insufficient disk space. There is enough space to store the final compressed files, but it looks like there may not be...

You have a few good points, but I think the improvements are quite nice on the development side. Bringing in Intellisense is long overdue as is the addition of...

First, at the risk of appearing horribly ignorant, what is the PMP and what exactly does it involve?

And for a comment to Lonely, have you considered keeping your current job...

Sirish, can you rewrite the stored procedure as a table valued function? Depending on what you are doing inside of it, it may not be possible, but if it...

First, if your issue is blocking you may wish to consider using with (nolock) where appropriate. It does raise the possibility of certain types of inconsistent reads so it...

Very well written article.

It all depends on the situation. I work as a DBA in a company where I have sysadmin rights on all SQL Servers, and I could not do that...