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 |
|
iip
Starting Member
3 Posts |
 Posted - 2008-08-01 : 01:43:44
|
| database both: sql server 2000 sp4I have put one database for transactional replicationDatabase contains almost all table names with space.Once I start replication, after some time i am getting following error.------------------------------------------------{CALL sp_MSins_Table Name ('....')} --Note table name contains spaceTransaction sequence number and command ID of last execution batch are 0x0000008800000026000400000000 and 1.Syntax error or access violation-------------------------After this If I run following proc.sp_dropsubscription 'Pub_Name','Table Name','servertoreplicate' sp_droparticle 'Pub_Name', 'Table Name' sp_addarticle 'Pub_Name', 'Table Name' ,'[Table Name]'--Note [sp_addsubscription 'Pub_Name', 'Table Name', 'servertoreplicate', ....Note space in table name----------------------------Then again replication starts and after some time again same error.According to me the reason is '{CALL sp_MSins_Table Name' contain table name with space so this gives syntax error.The resolution should be change the command name from '{CALL sp_MSins_Table Name' to '{CALL sp_MSins_[Table Name]'from MSrepl_commands tablePlease let me know how to resolve this? |
|
|
iip
Starting Member
3 Posts |
Posted - 2008-08-01 : 01:44:39
|
| Note I am using transactional replication |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-01 : 09:30:23
|
| If table name contains space, then include bracket. |
|
|
|
|
|
|
Replication for table names with space