Viewing 15 posts - 106 through 120 (of 1,098 total)
That has nothing to do with the owner of a job. You should turn it back to an admin account.
The type of autenthication was setted up during the creation of...
June 22, 2004 at 8:15 am
The owner of the sp should be the login that you use to sincronize the publisher with the subscribers.
When you sincronice the replication, then SQL applies the snapshot and creates...
June 22, 2004 at 7:42 am
When running dinamic queries inside a sp, SQL check that the user executing the stored procedure have enough rights to execute the dinamic query.
So if your sp builds a SELECT...
June 22, 2004 at 7:31 am
If the id column of the published table an identity column?
June 17, 2004 at 9:42 am
Wich type of replication?
The FTP protocol it is only used to copy the snapshot to the subscriber. Then you will have a connection between publisher and subscriber with TCP/IP or...
June 17, 2004 at 9:40 am
Well my advice was to find the error, not to manually apply the snapshot.
To bulk insert do
BULK INSERT TableName FROM 'PathToBcpFile' WITH (DATAFILETYPE = 'NATIVE', CODEPAGE = 'ACP')
The error that...
June 3, 2004 at 7:01 am
You also can use transactional replication so that the changes will replicate back.
But you shoud be carefull to specify the loopback_detection to true in all your articles, so that the...
May 28, 2004 at 7:13 am
Try findin the sp in the subscriber first. If it doesn't exists, then run sp_scriptpublicationcustomprocs in the publisher in the pulblished database.
That shoud create all the sp that you need,...
May 28, 2004 at 7:08 am
Are you applying the snapshot?
If so, try to manually import the snapshot to that table.
Locate the bcp file of that table, and then bulk insert it with the native format.
May 28, 2004 at 7:03 am
Are you sure you execute both full counts in EM and QA? I mean actually executing a count operation instead ob getting in from sysindexes.
May 27, 2004 at 9:21 am
inmediate updating would be slow.
The update would be commited in both server at the same time, and if you hace a slow net then you could have problems, causing the...
May 21, 2004 at 1:06 pm
That settings are saved in the registry. Do you know anything that can be changing that?
May 18, 2004 at 7:04 am
How long since this errors?
Did you made any changes to the server? Service Packs, upgrades, etc?
May 17, 2004 at 10:03 am
Check this article, and copy,create and execute the sp.
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql
May 14, 2004 at 1:44 pm
Viewing 15 posts - 106 through 120 (of 1,098 total)