something like this?

DECLARE @t table (primarykey int, acctid int, statusid int)

insert into @t values (1, 2, 1)

insert into @t values (2, 2, 1)

insert into @t values (3,2, 2)

insert into @t...

BCP is faster than DTS.

http://www.replicationanswers.com is a good wesbsite from Paul Ibison.

There are a lot of commonly observed error messages and a possible fix.

Good. so you have your job now?

you didnt answer my questions.

you can generate those stored procs using sp_scriptpublicationcustomprocs @publicationname. This will generate the insert/update/delete stored procs for all articles in the publication. You could use only...

What is the structure of the table? And how many records do you have in the table? And is this the first time you set up replication or it was...

Thanks John.

I was finally able to get it set up and running. I am gonna make a document and put it on my blog somewhere one of these days. I...

If your row size is big, perhaps you might want to use TEXT data type. But there are some pay offs for using TEXT data type. Check out docs and...

There are a lot of things here.

Whether the Groups table has data or not does not matter here since GroupId seems to be coming from the parameter list in your...

SELECT Users.userId, userName, userPassword, Users.branchId, UserGroups.groupId

FROM Users JOIN UserGroups

ON Users.branchId=UserGroups.branchId

AND Users.UserId = UserGroups.UserID

I think once the subscription expires you need to resetup replication from scratch.

we are changing the datatypes of columns from int to bigint etc. so repladd/repldrop will not work.

thanks

Dinakar

AFAIK, you need to drop all foreign keys on subscriber.

You could do a count(*), min(date), val and group by val.

If you already have the error, the only solution I would think is to re-setup replication but make sure you check the "never expires" option as Borik mentioned. By default...