Hi Ram

Unfortunately, I don't have any sharepoint database, I am sure you can always find out the default collation used by Sharepoint since you have it installed.

IT

Hi

I think it depends on what type of DR you are using:

1. If u r using Clustering, the DR should take over automatically when your SQL instance fail-over, you...

Yoseph

I did came accross issue with this in the past and the way I solved the login issue was by setting master database as the default database login.

U can use...

Hi Ram

My understanding is Collation "SQL_Latin1_General_CP1_CI_AI" is a collation that is used for backward compatibility with older SQL server version, I did a research to find out which collation should...

Try to use SELECT statement first with CASE in within to select the data that you want..

once you are happy with that.. you can either use SELECT INTO NEW_TABLE_NAME or...

Hi,

Firstly, I will check if the username that is used for the linked server connection exists on the target machine of the linked server.

Secondly, Try to open the Enterprise Manager->Security->Linked...