My stored procedure uses the temp table and other reporting DB table to combine the output. If I specify (hardcode) the collation to temp table column then it works fine.
But I want to retrieve the Collation name of Reporting DB within the stored procedure and assign it to temp table or temp table column.
Can anyone help me in this since I am not able to find any solution in internet?
Thanks in advance.
View Complete Post