Discussion:
replicating aspnet_* tables
(too old to reply)
david
2010-12-02 14:12:43 UTC
Permalink
Is it possible to replicate the aspnet_* tables used for asp net
membership? by default they are disabled when selecting articles and
I am not sure why. Have not been able to find any answers via Goggle
either.

thanks,

David
Ben Thul
2010-12-02 17:12:29 UTC
Permalink
I don't have those tables in my environment, but a requirement for a
table to be replicated is that the table have a primary key. Do those
tables qualify?
--
Ben
Post by david
Is it possible to replicate the aspnet_* tables used for asp net
membership?  by default they are disabled when selecting articles and
I am not sure why.  Have not been able to find any answers via Goggle
either.
thanks,
David
david
2010-12-02 21:49:49 UTC
Permalink
Post by Ben Thul
I don't have those tables in my environment, but a requirement for a
table to be replicated is that the table have a primary key.  Do those
tables qualify?
--
Ben
Ben,

Thanks for the response, they do have a PK on a column of type
uniqueidentifier. There are also indexes on columns of nvarchar(256),
I know there used to be a limit of 255, but not sure anymore, can't
find any documentation on it.

thanks again,

David
Ben Thul
2010-12-02 23:31:57 UTC
Permalink
The next step I'd take would be to manually issue the sp_addarticle
command against one of the tables and see what error (if any) it
gives. That should tell you why the GUI isn't listing them as valid
article candidates.
--
Ben
Post by david
Post by Ben Thul
table to be replicated is that the table have a primary key.  Do those
tables qualify?
--
Ben
Ben,
Thanks for the response, they do have a PK on a column of type
uniqueidentifier.  There are also indexes on columns of nvarchar(256),
I know there used to be a limit of 255, but not sure anymore, can't
find any documentation on it.
thanks again,
David
Loading...