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:47:02
|
database both: sql server 2000 sp4
I have put a database for transactional replication
Database 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 space
Transaction 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 table
Please let me know how to resolve this?
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-01 : 23:19:03
|
| Possible to remove space from table name? |
 |
|
|
|
|
|
table names with space