I am going to add some of these into my daily reports.  And yes, I do have co-workers that slip in new sysadmin users!  At least this way I'll know...

Personally, I like to call the first table "TableA", second "TableB" and so forth.  That way no one can follow my code.

That's one way to ensure job security!

Bryant, you misunderstood what I meant.  I am suggesting that you adopt a standard for your organization and stick with it.  It is better than not having a standard.  To...

You can argue all day about naming conventions.  But I think that the main point is too decide on a convention, document it, and enforce it. 

Regards,

Scott

A quick answer to #2: price.

Regards,

Scott

It's an interesting question.  I am in the same boat at the shop that I am at.  When I first took over as DBA, I found that our databases are...

Paul-

Just curious, but what are you looking for in your replication process that cannot be provided by SQL Server? 

Regards,

Scott

Steve-

Thanks for the reply, but I am having problems with the "sub" Windows in EM.

Regards,

Scott

You are on to something.  It did grow -- a lot!

Now I need to figure out why.

Thanks,

Scott

Hadn't thought about that, but it makes sense.

The alert wasn't recently enabled, it's been configured for months and has been restarted many times. 

I have seen you post that message before and it is a good thing...

You could create a new publication that contains only the new tables as articles.  That would get you around have to deal with the large tables in a new snapshot.

I...

I haven't completed the finished product, but thought that I'd pass along the way that I am implementing my solution.

I have basically used the code from sp_helpmergepublication to come up...

I found that in each published databases there are two tables, sysmergepublications and sysmergesubscriptions.  In sysmergepublications, there is one record for each publication for that database.  In sysmergesubscriptions, there are...

I should add that I intend to add this to my report on the publishing server.  And that the subscriptions are all push subscriptions created on the publisher.

Regards,

Scott