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 |
|
OTI_Dev
Starting Member
2 Posts |
 Posted - 2011-06-27 : 15:28:54
|
| I have two, 2005 SQL Server boxes and I am setting up merge replication between them. I have no trouble creating the snapshot. When I create the subscription I get the following fatal error:SELECT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Source: MSSQLServer, Error number: 1934)Get help: http://help/1934I have modified the .sch files in the snapshot so that ANSI_PADDING = ON. I looked at the database triggers but cannot see the issue that I researched in some posts.Any thoughts??OTI_Dev |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-27 : 15:52:48
|
| Do you have computed columns or indexed views?http://msdn.microsoft.com/en-us/library/ms190356.aspx |
 |
|
|
OTI_Dev
Starting Member
2 Posts |
Posted - 2011-06-28 : 09:50:37
|
| Thanks for replying Russell. We do not have computed columns nor indexed views. I am currently trying to employ peer-to-peer transactional replications as it appears to fulfill our needs.OTI_Dev |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-28 : 10:43:56
|
Have a look at thisbe sure to look at the workarounds too. one is even mine  |
|
|
|
|
|
|
ANSI PADDING = OFF by default