Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-07-2009
Member
 
Join Date: Apr 2009
Posts: 24
linked Server Collation Compatible

I am having SQL 2005... I tried changing the Collation compatibility to my linked server it didn't worked for me... Do SQL allow query collation to linked server...??? Please Help...!
Reply With Quote
  #2  
Old 13-07-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: linked Server Collation Compatible

I think you should use the collate option for casting collation in the query. I hope you understood what i told you to do...! Also was thinking what compatibility mode you where using???
Reply With Quote
  #3  
Old 13-07-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: linked Server Collation Compatible

Defining Linked Server Options :

The following linked server options that are defined by using sp_serveroption control whether and how SQL Server uses collations from linked servers :
  • The use remote collation option specifies whether the collation of a remote column or of a local server will be used. When true, the collation of remote columns is used for SQL Server data sources, and the collation specified in collation name is used for data sources other than SQL Server. When false, distributed queries always use the default collation of the local server instance, and collation name and the collation of remote columns are ignored.

  • The collation name option specifies the name of the collation used by the remote data source if use remote collation is true and the data source is not a SQL Server data source. The name must be one of the collations supported by SQL Server. Use this option when you access an OLE DB data source other than SQL Server, but whose collation matches one of the SQL Server collations. SQL Server data sources report their column collations, and collation name is ignored for linked servers that reference SQL Server data sources.
Reply With Quote
  #4  
Old 13-07-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: linked Server Collation Compatible

Changing the Server Collation :

Changing the default collation for an instance of SQL Server can be a complex operation and involves the following steps :
  • Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them.

  • Export all your data using a tool such as the bcp Utility. For more information, see Importing and Exporting Bulk Data.

  • Drop all the user databases.

  • Rebuild the master database specifying the new collation in the SQLCOLLATION property of the setup command. For example:

    Code:
          Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName 
          /SQLSYSADMINACCOUNTS=accounts /[ SAPWD= StrongPassword ] 
          /SQLCOLLATION=CollationName
  • Create all the databases and all the objects in them.

  • Import all your data.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "linked Server Collation Compatible"
Thread Thread Starter Forum Replies Last Post
How to restore database on a Linked Server AaAgMaN Operating Systems 5 05-03-2011 08:17 PM
Is WS111T in compatible in Windows Server 2008? denny walter Networking & Security 3 15-12-2010 07:40 AM
Unable to access linked Excel file from shared Excel file on server AK_Chopra Windows Software 4 07-05-2009 02:09 PM
Error - The Server is not a compatible streaming media server Aadimoolan MediaCenter 1 02-12-2008 09:44 AM


All times are GMT +5.5. The time now is 05:44 PM.