Look below problem

http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx

waitinf for reply

Old Collation was---SQL_Latin1_General_CP1_CI_AS

and new of MY DB and Server is--Latin1_General_CI_AI

I notice something meanwhile describe with ex. as below

Suppose I had a proc attached with a report

Create Proc ProcName

@PAr1 varchar(4)

@PAr2 varchar(4)

@PAr3...

I try That

But its not possible until these constraints r there

so first I drop that constraint

and change collation it changed sucussfully

but I as alter table to restore constraint it change...

Cant we not change collation just disable that perticular constraints.

I disable constraints SYS_C001619, but still cant alter table with new collation.

If I drop this constraints and then try to change...

Thnaks a lot

Tnanks to all

What if first we disable all check constraints with sp_MSforeachtable Procedure then chage collation and

then again enable check constraints.

Is there any risk to use sp_MSforeachtable procedure

Thanks for reply

I want to know how we can make a CSV file instead of Txt file

deos nobudy have any idea

use Sp_WHo

if you are admin then

can use

sp_helplogins

Cheers

KD

Thanks Nitin

But it does not work for alter proc command.

U should try

sp_changeobjectowner

to change the user of any object

but u must have sysadmin right