That is exactly what I wanted to know. Thank you so much for the help. I had been researching this for a couple of days (not sure if...

Can it be done with READTEXT?

Unfortunately, no. This is an application that determined to use these datatypes but it is running on SQL 2005.

Thanks for the answers.

Why would you not page because you had 32 GB of RAM?

Sorry, misread your question. I was thinking space issues instead of memory. I'm not sure if changing from the % to MB will help with memory or not.

If the log growth is set to 10%, you might try changing this to a certain number of MB instead.

I like being a DBA, but if I were you I might stay in the engineering field. Everything I have seen says that there is a major shortage of...

You have to ....

1) synchronize the actual data between two databases on different servers? i.e. merge or some type replication??

2) or you...

Haven't had a chance to read it yet, but I hope to. Not sure it was wisdom, just Google and finding the link....:-) But I appreciate the vote...

Yes, you have to pick one...but by default you will get the one SQL Server detected from the Windows locale. Thus, the one that is set by the OS....

If you don't specifically pick a collation at install time, SQL Server Setup automatically detects the Windows system locale and selects the appropriate SQL Server collation. That's what I...

If I understand your question, the end user wants you to change your server collation to SQL_Latin1_General_CP1_CI_AS. As far as I know, the server collation comes from the OS....

Sorry if I missed this in the string of replies, but are the fill factors on your indexes the same? If that got changed in the new database, say...

As sad as this is, you might just try creating a brand new package that does the exact same steps and replace the existing one with it. In my...