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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-06-10 : 08:48:30
|
| I've configured transactional replication between two servers.Replication is failing due to missing User Defined Table Types on the subscriber database.I thought replication works like this - whatever updates are made on the publisher, the exact same updates are made on the subscriber. If a stored procedure is executed on the publisher database then the results of that stored procedure are applied to the subscriber database.User Defined Table Types are used in stored procedures as parameters.So you would think that once the stored procedure has executed, the records written into the transaction log would be insert or update statements with the actual physical values.So why is replication failing due to missing user defined table types on the subscriber side?Replication should not even be looking for user defined table types when applying updates on the subscriber. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-10 : 09:04:29
|
| Just create the type at the subscribers -- assuming they are SQL 2008 or 2008 R2. |
 |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-06-10 : 11:30:07
|
| Yes I know I can just simply create the type at the subscriber. But I wanted to know why they are even needed at the subscriber end. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-06-10 : 18:27:34
|
| Are you replicating the User Defined Table Type as well; or just the Table?=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
|
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-06-13 : 03:17:37
|
| How SQL server Subscriber knows the user define data type you should create on the Subscriber side alsoRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
|
|
User defined Table Types - replication issue