Where oh Where has my default value gone?

Question

Post reply

Where oh Where has my default value gone?

tvp1125

Old Hand

Points: 383
More actions
December 17, 2008 at 12:48 pm

#203058

Ok....
Tranactional Repl:
Does a subscriber delete it's default value or bindings when created or dropped? or is it somethng else
I have a getdate() and a couple other default values set in a table, but they are gone after a subscription created/or dropped.
My publisher retains it's default values.
is this normal?
Messes up mt timestamp if it is.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 1

You need to set "Copy default value specification" to TRUE

This parameter is FALSE by default.

[font="Verdana"]--www.sqlvillage.com[/size][/font]

tvp1125 Old Hand Points: 383 More actions · Answer 2

Mohan Kumar (12/17/2008)
You need to set "Copy default value specification" to TRUE
This parameter is FALSE by default.

:laugh: right in front of my nose.....

Thanks so much........

tvp1125 Old Hand Points: 383 More actions · Answer 3

I'll rephrase this question:

I altered a Article Property setting of an existing publication.

I rerun the Snapshot agent.

However, the replication to the subscriber seems to have stopped working . Is there a timed delay in this step?

This happens anytime I change a publication setting

I have to drop the subscription and recreate to get it to work.

Should it restart automatically?

Am I missing another agent?

I sill say that I log onto SQL server with a SQL account to create and modify tables and publications, but the distributor, db_owner, and others are run under a different windows account. Would that have any thing to do with it?