October 24, 2009 at 8:08 am
Hello,
I'm trying to configure replication but when I create the publication the snapshot agent fails with the following error:
Script failed for UserDefinedTableType 'test.IntegerTableType'.
This happens because I'm trying to publish an SP that uses a UserDefinedTableType.
CREATE TYPE [test].[IntegerTableType] AS TABLE(
[Value] [int] NULL
)
When I create the publication I can't select the UserDefinedTableType to publish.
Is there a workarround to this problem?
The only solution I can see is not to publish ths SP and create it manually at the subscriber.
October 27, 2009 at 9:39 am
Is the UserDefinedTableType at the subscriber? What if you were to put that on the subscriber first then try to run your snapshot again?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 27, 2009 at 10:09 am
The problem occurs while generating the snapshot.
I tried to create the user defined type using a pre-snapshot script but I get the same error.
October 27, 2009 at 10:13 am
Sorry, thought the error was being generated when applying the snapshot. I haven't replicated stored procedures yet so, haven't really run into anything like this. Sounds like your initial thought to just copy the procedure might be the best alternative.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply