So... whats the problem?

Mark: Please edit your post and add [ code ] tags to make your SQL and XML code correctly visible.

Actually, I am pretty unclear on why you are partitioning at all for this.

Multi-tenancy is an application security-mapping architectural issue, whereas Partitioning is primarily a performance tool. ...

Well, that's something then. 🙂

You haven't really given us enough information to make much of a distinction for you. I blogged about Shared Schema, Multi-tenancy DB and application desings and have a couple...

perhaps you should give us all of the requirement first. Before we try to solve it.

Well they can't freakin' find me. And I'm trying to be found!

Story of my freakin life. Apparently, I am so forgettable that even computers can't remember who the...

Glad I could help. 🙂

Perhaps the password changed?

Look at the output from SELECT * FROM MASTER..SYSPROCESSES, you can use any of those columns. In particular, you might find the Host and Application info useful.

Nonetheless, ALZ is...

Do you have the CREATE TABLE to go along with this and some example data?

Generally, LTRIM and RTRIM problems turn out to be that the column is a CHAR or...

Set a default column value on the table for that column to be equal to GETDATE().

dndaughtery (8/29/2009)

---

..I have set the connection property's packet size to 32,000 and set the rows per batch and max commit size if the OLE DB Destination to 100k each. My...

Well there's no reason to use CLR for this, just use SQL:

INSERT INTO YourTable(ColumnA, ColumnB, ...)

SELECT valueA, valueB, ...

If you really need to do it from CLR in C#, then...

Roy Ernest (8/27/2009)

---

Barry, Thanks... I knew I would mess up even when asking a simple question... :hehe:

This is the scenario.. We are moving our Main DB to a new Hardware...