Forum Replies Created

Viewing 6 posts - 46 through 52 (of 52 total)

  • RE: SET ANSI_PADDING ON

    I've read elsewhere that a DDL trigger on the source database can cause problems with this but

    a.) change-control forbids me to disable a trigger that is logging DB changes

    b.) must...

  • RE: SET ANSI_PADDING ON

    I can understand that the underlying problem was caused by some dynamic SQL in the DDL trigger but it can't be seen as a solution to this issue disabling and...

  • RE: SET ANSI_PADDING ON

    I've searched all 10 cumulative updates for SP3 and there is no mention of a fix for this issue with ANSI_PADDING OFF in the replication *.sch files. This is definitely...

  • RE: ANSI_PADDING

    I had this same error when trying to initialise a Subscription. I checked the <subname>.sch file on the Publisher and noticed SET ANSI_PADDING OFF.

    I amended the file to SET ANSI_PADDING...

  • RE: How to restore master database.?

    The problem is you cannot connect to the SQL Instance using SSMS when it is running in single-user mode?

  • RE: Differential backup in 2005

    In that case, what happens if you restore a TranLog backup where the Time range of the Transaction Logs 'overlap' a full or differential backup? What happens to the changes...

Viewing 6 posts - 46 through 52 (of 52 total)