Viewing 15 posts - 526 through 540 (of 1,098 total)
You should drop the publication before alter the table.
June 13, 2003 at 10:25 am
Are you creating the backup device on a remote server?
To backup to a remote server, you should map from your db, the disk in wich you plan to backup. But...
June 13, 2003 at 7:34 am
That is true. But reinitializing snapshot replication is just like running the replication agent, so you want have any problem. A different thing would be with transactional or merge replication...
June 13, 2003 at 7:19 am
If you change them in both then you won't have any problems. The next time the snapshot agents runs, it will create a snapshot with the new data types...
June 12, 2003 at 10:41 am
Check that merge replication will add a rowID column to all your tables, and if you have a lot of rows, then it will increase the size of your db...
June 12, 2003 at 10:24 am
Wich column data type in the subscriber and in the publisher?
June 12, 2003 at 10:20 am
Yes, you can capture all the queries executed and your prod server. But before starting with profiler, you should create an exact copy of the prod db in your test...
June 12, 2003 at 10:03 am
Well. 760 is the version of SP3. In my servers I also have that version after installed sp3.
The version number .766 could be for SP3a wich I have not...
June 12, 2003 at 6:39 am
Only transactional replication must have primary keys in all the published tables. But you can still use merge or snapshot.
June 12, 2003 at 6:32 am
Sorry, I though it was transacctional replication. With snapshot replication you can't change the table. Or it will depende of the changes.
But be carefull because depending of how you configure...
June 11, 2003 at 3:58 pm
Well, snapshot replication can drop and then recreate the tables. It 's just an option. So you might loose the permissions in here.
You can alter the publication to just delete...
June 11, 2003 at 3:53 pm
Well then there isn't much to say then. It is not difficult. I would create them in a new publication, because when you change the stored procedure, iw will not...
June 11, 2003 at 3:50 pm
I don't think so. I would let the agents running from the jobs of SQL while Things are ok, And when I have a problem, I would run them from...
June 11, 2003 at 3:45 pm
PK is a must for transactional replication, have you consider using another type of replication?
June 11, 2003 at 3:42 pm
If you change the tables that are published, then the replication will fail, but if you use sp to replicate the changes, then you can modify them and add the...
June 11, 2003 at 3:39 pm
Viewing 15 posts - 526 through 540 (of 1,098 total)