Just out of interest, having been through the world of pain that is changing the collations on columns of a table in a database that had a goodly few GB...

Sorry marfu, but without seeing the structure of your tables, indexes etc it is difficult to see why this could be happening.

How big is the actual table? If you look...

Is it SQL 2005? Is the proc in a schema that the profile that the app is using to access the DB can't see?

In order to eliminate security "issues" temporarily...

From what I could see, Gail was trying, very patiently, to give sound advice to someone who, if they really did have all those qualifications, would have known what to...

I tend to agree with ybol.

Are you using a 32 or 64 bit server btw?

If you use an average of 2GB per instance, that will allow 5GB left over for...

You can also set it to deploy to the MSDB of the server. this is the only way I found - other than to change the security settings of the...

You can choose the database collation in 2K according to your requierments. RebuildM.exe will wipe out all your logins, DTS packages etc. TBH you are better off changing the default...