Forum Replies Created

Viewing 2 posts - 16 through 17 (of 17 total)

  • RE: Unable to query new database from linked server

    There may be problem with your query.

    check schema name of table which you are going to access through link server.

    SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'

    AS SchemaTable

    FROM sys.tables

    WHERE NAME='YOUR_TABLE_NAME'

    and then access through that schema

    select...

  • RE: Merge replication - conflicts

    there will be modification on subscriber and publisher with different data. so thats why you face this issue:-

    Run

    SELECT * FROM SYSMERGEARTICLES

    there will be a column: conflict_table

    select * from conflict_table

    your conflict...

Viewing 2 posts - 16 through 17 (of 17 total)