Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2012-07-23 : 02:20:15
|
| If I was to create a table from a linked server using :-SELECT * INTO tablename FROM OPENQUERY(SELECT * from linkedservertable)Would the collation of the newly created table take the collation of the linked server's Database or the collation of the local Database? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-23 : 02:23:08
|
Don't know. I would just try and see. Is that possible for you?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2012-07-23 : 02:26:40
|
| One of our users has complained about collation problems on a table she created in such a way, I checked the collation of the database locally and it's CS_AI, yet the table she created using that method is CS_AS. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-23 : 10:57:34
|
| then that proves that its taking collation from source isnt it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2012-07-24 : 00:38:48
|
| Yup, strange how sql server allows that, but then again, i suppose there's arguments for both sides.Thanks both for input. |
|
|
|
|
|
|
Create Table Question?