Viewing 6 posts - 31 through 37 (of 37 total)
As far as I Know, replication settings and configuration are stored on distribution database and on every published database.
Which databases did you restore?
I don't know your replication topology, security context...
January 21, 2008 at 9:54 am
Have you verified that the user that you are impersonating against linked server have the appropriate permissions?
Couldn't you create the linked server with a name other than MIAMI\SQLINSTANCE2, for...
January 21, 2008 at 9:15 am
Check this article
How to send e-mail without using SQL Mail in SQL Server
http://support.microsoft.com/kb/312839/en-us
Regards Ramon
January 21, 2008 at 9:00 am
I'm not really sure to understand your problem but I'd try some suggestions.
You can remove Replication for the whole server from the Enterprise Manager >> Tools
You can have a look...
January 21, 2008 at 8:58 am
Have you tried to put destination database in BULK_LOGGED mode?
You may also consider turn off triggers while you are processing data.
Regards
January 17, 2008 at 1:15 am
How you tried to use BULK insert in the DTS?
You also can change destination database recovery to avoid transaction log growth.
Regards Ramon
January 16, 2008 at 8:47 am
Viewing 6 posts - 31 through 37 (of 37 total)