Originally posted by Satya
Didn't specified which version of SQL is using, if its SQL 2K then you can change COLLATION using ALTER Database ..... ALTER TABLE... refer to books online for more information.
If its version 7 then using REBUILDM utility to rebuild the master database for similar collation settings.
I am using SQL Server 2000.
The problem is that altering the database to set the collation order to be the same as the other one is what I have done but I still get the same error.
I am not keen on altering the collation order for every table/column hence my original question on this forum.
Originally posted by Crespo-n00b
Thanks for your help but as I said, I am not keen on using collate on every column I happen to use. Mind you, thank God MicroSoft introduced this new command in SQL Server 2000.
I am still trying to figure out why I keep getting the error even though both databases have the same default collation order!
Probably, we could help you more if you'll post the JOIN in the forum.
I got similar error when in a stored procedure I've created a "Table" type variable and used it in a join... all this happened in one database. The problem was solved by creating the "Table" type variable with the current database's collation order.