Feel free. Shouldn't be too long. Give a procedure and show how it works with a test user or two.

Can you track when changes are made to tables?

The replication process looks like any user sending a DML change to the server. To trigger on that, you'd need a trigger...

Potentially you have some sort of open transaction, close mirroring/ replication, that prevents the log from being cleared completely.

In terms of the size, I guess it's possible you need that...

call.copse (2/28/2014)

---

I don't think it could be a movie - maybe a HBO show or something - but I'd love to see the Foundation series adapted well. Tricky one mind...

That would be quite a thriller. I need to pick up his new one.

You don't write a trigger based on a range or partition. You write it based on the table.

If the read only groups are 3 months old, then your trigger just...

email the webmaster, or use the "Write for Us" link to the left and submit as an article.

I'll edit the piece to note that.

FYI, placeholder.

http://www.sqlservercentral.com/Forums/Forum61-1.aspx?Update=1

Good luck next year, Ray.....losing to the way0utwest Cowboys

Bits is great and there was a post on their Facebook page hinting that a contract was sent back today.

I'd guess they'll announce something in the next week

Are you saying you can add data to the partitions that are marked as read-only in the filegroups? It's possible there is a bug here wtih the partitions that doesn't...

roughly a page.

GBimberg (2/27/2014)

---

If you could alter tables the way you suggest, it would appear that you could also change the column order and type.

Accidently changing the column order and type...

paul.knibbs (2/27/2014)

---

I would assume it's because of memory issues (human ones, not SQL ones)--for instance, if I have a 60-column table that I want to add a single column to,...

Not GoDaddy, I hope. They lost my wife's DNS records and I had to play tech support guy for a day.