Thank you for your reply..

It might be the problem of collation.

because thats the one I did additionally in main sql server.

The collation of main sql server was SQL_Latin1_General_CP1_CI_AS

And i have changed to SQL_Latin1_General_CP1256_CI_AS using this scommand sqlservr -m -T4022 -T3659 -q"SQL_Latin1_General_CP1256_CI_AS" which i run through command prompt.

It might be the way which i used to change the collation is wrong.

How can i check the collation in object level and database level.

What should i have to do for changing thiscollation.

Please guid me. and I am new for this sql server.

could you please give me to change the script for collation?