For as large of installation that we have you would "THINK" that would be advisable or considered but spending money on things like that "utilities" isn't high on the list...

I would have thought I would have gotten at least One reply 😀

Isn't anyone bored enough to give me there two cents!!!

dbaker (4/14/2008)

---

correct as stated [will still keep existing column collations]. or ...

1. script all current tables without explicit collation [and pref in dependency order]

2. install SQL200x to get the instance...

Well I will be DIPPED...

So basically if I create...

so when you go into task manager the SQL service is taking a lot of the CPU? continually?

I guess I would first do a sp_who2 to see what...

Maybe this article will help

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

This is off topic but I just got to tell you Matt....

Your Sig made me laugh out loud!

Not that it isn't possible...but I just spoke with a co-worker whom is a very good resource for DB2 (previous job)

and he couldn't come up with an answer to your...

Good stuff...thanks!

Thanks for the info on SSIS Books!

Sorry this was an error and when I realized I had initally entered the post in the wrong section I thought I deleted the post by hitting the delete...

SA has rights on the server and it isn't a real problem as I verified it within E.M. that the login does have the correct rights also, when I open...

Are you in the OnePoint database?

Try this

Use OnePoint

Go

EXEC dbo.MOMXPartitioning

GilaMonster (10/31/2007)

---

How many rows are you keeping relative to the number you're deleting?

What I often suggest for deletes that affect most of the table is to first copy the rows...

Janet Keith (10/30/2007)

---

About the full vs simple. I've never worried about changing this. If my database is in production it is set to full mode. If...