Viewing 15 posts - 496 through 510 (of 1,098 total)
We already began with sp3 when I knew there was a sp3a, so we continue with sp3.
July 16, 2003 at 12:08 pm
Say, they installed SP3 in that server, yesterday, so I think that there it is the problem.
Anyone has experienced this before? Reinstalling SP3, can this be fixed?
Thanks
July 16, 2003 at 11:43 am
No, you can reinitialize only an article of the entire publication. And this is the same for all types of publication.
I think you will have to reinitialize the entire publication....
July 11, 2003 at 1:24 pm
If you are only filtering the columns in the publication, then you shouldn't have any problems. You must be doing something wrong if the fileds gtes shifted.
Everytime you made changes...
July 7, 2003 at 9:06 am
Nothing should happen with the data. Anyway I suggest a backup.
July 2, 2003 at 8:28 am
Can you run a remote query from both servers to both servers? Run sp_helpserver to see if the servers are registered.
Run from the command line the distribution (or merge) agents...
July 2, 2003 at 7:29 am
I know that is why I used sp_addscriptexec. This is almost the same as re applying the snapshot, but much easier. I just add the new version of the sp,...
July 1, 2003 at 3:44 pm
Do you need to have all the changes made at the subscriber to be replicated to your publisher?
With merge replication, you will have the same db in both servers, even...
July 1, 2003 at 9:12 am
Before you start modifying your replication schema, I would suggest that you really understand how your replication works.
You must know wich server is the distributor (that sometimes can be the...
June 30, 2003 at 1:55 pm
No, in fact I don't think you will be able to insert them, unless you convert them into a single format. You are allow to store only one date format...
June 25, 2003 at 1:07 pm
Try this:
BULK INSERT TableName FROM 'FullPathToFile'
WITH (DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = ',\n',
KEEPIDENTITY)
I assume the rowdelimiter is a comma, but change it if you need.
June 25, 2003 at 11:10 am
Can you post the error returned?
I Don't see any where condition for the join.
Execute the select without using bcp, to check that returns any results, and also that it is...
June 25, 2003 at 11:01 am
Both servers have the same name? If they are different, then you will have problems, with replication.
June 25, 2003 at 10:55 am
Viewing 15 posts - 496 through 510 (of 1,098 total)