Yes. That's the basic purpose of partitioned tables.

Are the columns in the table set as nvarchar or varchar?

I tried various ways to rewrite your query, and using a Join instead of an In does speed it up a bit, but the main thing is going to be...

Have you thought about using LTrim and RTrim for this? Might be easier.

Definitely can't tell what's wrong from that. It looks like a generic error message of some sort. Is it possible to rebuild the DTS package manually as an...

Your right, the "go" will break it. Sorry about that.

On the deallocation, yes, you'll need to do that. I just wrote the skeleton of the code, you'll need...

I think a partitioned table (possibly even a federated database) will be your best bet for this. If you really insist on sticking with the 31 tables idea, the...

The "with" is what's called a CTE (Common Table Expression). They're new in SQL 2005. If you look up CTE in Books Online, it will tell you how...

Could you use a CLR to retrieve the MAC address? That's usually pretty good for uniquely identifying a server. (Can be problems if they have to swap out...

How do the two queries relate? There doesn't appear to be a common column between them.

Like Grant, I would normally design a database to store all address information in one place. No need to maintain two tables with the same columns in them. ...

Have you looked into the possibility of using a CLR to accomplish that? I don't know if it's possible, but it might be. Would at least appear to...

Michael Valentine Jones (5/12/2008)

---

I think that the support cycle fro SQL Server is too short for an enterprise level application. I think that 10 years of support after that...

troyehall (5/12/2008)

---

GSquared (5/12/2008)

---

Surely your original example, where "ActiveWhatever" is an object and "activeWhatever" is a variable from that object, isn't enough to justify the effort expended by coders having to...

Excellent! Glad it worked for you.