Why don't you test. That's the only you'll know for sure and understand what's happening.

You'll sleep better at night once you do.

That will take you some work to get to work.

Script the code to delete the current oldest partition. Then modify is with dynamic SQL so that you can account...

I am reading wrong? Looks like both count columns should have the same info?

Also the trick with CASE and any aggregate is to "reverse them" >>

SELECT SUM(CASE WHEN ConditionHERE...

calvo (5/3/2011)

---

You're right. I should revise my post to say "an easy way...".

The difference is a gui that could handle converstions if necessary.

The benefit would be that it is easy...

GilaMonster (5/3/2011)

---

Because I didn't notice and wrote a couple...

Well a job to delete the old partition.

Another job could create the next one.

I've read a couple times taht guys create like a couple extra years of partitions in advance...

calvo (5/3/2011)

---

easiest way without having to learn SSIS is to just use SQL Server Migration Assistant for Access v4.2. This has a wizard to walk you through migrating your access...

Why does it bother you? People read this from google today so it's still usefull!

Ya documentation would be nice... :w00t:.

Adam Bean (5/3/2011)

---

Many updates have happened to these objects ... while our documentation is still rather poor, visit the site in my signature if you want to review these objects...

TheSQLGuru (5/3/2011)

---

Came over the top on me, eh?? Oh, I yield to the...

Tx.

shot in the dark since the thread is a couple years old, could you post the link to the connect ticket so that we may vote on it?

Also an updated...

I like the comment idea. I personnally put those in prints so that I can follow along as the script executes. Also you have more logged info when...

You'll get the same error if the server is restarted or if someone killed your SPID.

I've never hit a bug with this, but I'd certainly check the KB posted earlier.

Are...