Viewing 15 posts - 166 through 180 (of 1,098 total)
If you restored into the same server, you shoudn't have any problems with the login, unless you have restored the master db.
April 28, 2004 at 6:50 am
If you need to compare database structure you can just script out the entire database (of both servers) and then use windows command comp to compare the scripts.
If you also...
April 28, 2004 at 6:45 am
Merge replication won't be affected by the creation of new tables.
When you settep up a merge publication, you already specified the tables (articles) that belong to the merge publication.
Changes to...
April 27, 2004 at 12:58 pm
If you are trying to get the changes made at your server applied also to the new server, instead of triggers you can use replication.
April 27, 2004 at 12:52 pm
try
exec remoteserver.master.dbo.xp_cmdshell 'test.bat'.
you shoud add it as a linked server.
April 26, 2004 at 3:11 pm
I don't think you can.
They must be with the same codepage.
April 22, 2004 at 1:59 pm
No. Permissions are not saved at table level, because depends on users and roles. So you can replicate permisions of a table.
You can try to copy roles and users with...
April 20, 2004 at 7:17 am
Even if you published all tables wich are involved in the integrity validation, if you specify the snapshot to drop the table before applying the snapshot, it will fail.
You shoudn't...
April 19, 2004 at 7:22 am
DTS package in replication are to transform the repliated transactions when you are replicating to heterogeneous subscribers, like Oracle.
If you don't need to transform your data, then you shound't use...
April 19, 2004 at 7:04 am
If the table already exists in the subscriber, you shound't specify the snapshot to drop it.
You can change that in the properties of each article.
If you need to re create...
April 19, 2004 at 6:56 am
run sp_helpmergepublication from the publisher in the publication database to check if the publication really exists.
April 16, 2004 at 2:16 pm
The subscribers are SQL Server?
Why do you need to use DTS? Can you use pre and post Snapshot Application Scripts?
April 16, 2004 at 2:11 pm
I have used it before and never had any problems.
You should be aware that the transactions marked for replication in the Log won't be delivered to the distribution database by...
April 16, 2004 at 2:00 pm
did you made a clean drop of the subscriber before?
Check sp_dropsubscription in BOL, and run it from the publisher.
April 16, 2004 at 1:54 pm
I have used before and never had problems.
You should keep in mind, that until you don't backup the log of the published database, transactions won't be delivered to the distribution...
April 16, 2004 at 1:51 pm
Viewing 15 posts - 166 through 180 (of 1,098 total)