Object permissions within the datatabase are not replicated by default.

This is because replication usually involves replicating data and schema to other servers, where logins may not be defined or defined...

I may have missed this in your post, but are you actually replicating the identity col. as an identity col.

If so, question is why? Default is not to do this,...

Have you tried this:

If you attach a database to a server other than the server from which the database was detached, and the detached database was enabled for replication, you...

Ok, forgive me, but I am still not entirely sure what the question is.

In terms of DMO itself, with regard to the jobs, if it needs to use local as...

I'm not really sure what you're asking here, but I think you're getting a bit confused about DMO.

Your scripts are not running DMO, but both are running SQL sp's.

Greg,

I understand about the SQL Agent mail notification with CDO, but do you need to use this ?, or have I misinterpreted what you've stated above.

I use CDO even for...

I believe there is a security issue according to an article that I read.

I looked into POP3/SMTP with a no. of configurations, MS Exchange, Lotus Notes mail servers with different...

This error is a fairly common error in replication and can be caused by a no. of issues. Usually, it is because the schema in the publisher does not match...

A very interesting and well put article.

Quite relevant to myself as I have just moved company having been at my previous one for 7 years. It was a big move to...

Avinash

Thanks for reply.

On further investigation on what I was doing it became apparant that I could use SQL-DMO a lot more so decided that I really needed to get to...

I have been working on a very similar issue recently on an upgrade from Access to SQL Server. The design required slight changes also.

Interestingly the original design had one common...

We had the same problem a couple of times even though it was on SQL 7.0.

Our problems related to the registry key:

HKEY_LOCAL_MACHINE\Software\Microsoft\WinNT\CurrentVersion\Perflib\009, which did not have appropriate permissions to reload...