Write Data In-DB without specifying collation

[Abbie_Hill]

Hi 

Is it possible to write a table out to my database with a specific collation or without specifying one? Our Database team are requesting tables use the same collation as the database - SQL_Latin1_General_CP1_CI_AI  

Thanks

Abbie

[cmcclellan · Accepted solution]

Two methods I can think of ..... 

- the DBAs should be able to make it a default, OR

- set it in the pre-create SQL statement

[Abbie_Hill]

Thank you!

I'll take a look setting in the pre-create SQL statement.