SQLRNNR (8/25/2011)

---

Correct, the resource database will not show in either location as a database. It is a hidden database and protected for good reason.

Distribution is certainly different than the...

SQLRNNR (8/24/2011)

---

That is true...

Is the column in the where clause indexed? How many rows are in the table? Are you updating a primary key? Have you looked at the query execution plan?

I'm...

Do you know what transaction caused the error and therefore the table effected?

You can see if you can alter the replication fltr procedure to work. You can find it...

Sounds like an ideal situation to implement a sliding window partitioned table and an additional filegroup.

I would look at the possiblity of setting this up in a"backup" file group. ...

amita pallod (8/24/2011)

---

Thanks.

I never used the script in production but did try in development by turning OFF the immeadiate sync.

It worked without any issues.

How would I use filter on article...

GilaMonster (1/12/2011)

---

Order by is not honoured anywhere other than in the outer-most select statement, that is, the one that selects from the view. This is not a bug, it's intentional....

I think logshipping probably isnt the best soltuion for the volume of databases you are trying to restore. 600 databases is a massive administrative over head.

Do the databases need...

I think the reason for the brief answer is because its something you could answer yourself by using google (other search engines are available.)

Yes it is available, published 11th July...

to be fair the microsoft method is a bit long winded but there must be a hundred other posts of the same question on this forum. I personally have...

amita pallod (8/22/2011)

---

Hello All,

I know this post about removing a article from publication. I tried opposite of this as this is a requirement at my work.

Adding a article to the...

I've found a number of people tend to want an abridged version of the technical documentation. i.e. dumbed down a little

I tend to frequent the replication areas more as...

http://lmgtfy.com/?q=apply+sql+server+service+pack+cluster

Just for my amusement really based on another post.

Here's what you will find

http://support.microsoft.com/kb/958734

You wont be able to do...

It is and overhead, but if its unintentional how frequently do you expect them?

If users are correctly configured with permissions its quite likely you could prevent inadvertant deletions.

Skip...