OK have you looked at this article here:

it says only new table will be added to snapshot

Activity Monitor usually tells you what resource it is waiting for. For example another process maybe trying to do massive select or update on the same tables.

You will need to change the query (yes SQL server and Oracle use different SQL language and execute it differently).

If you just want to delete on of the duplicate errors...

Hi Andreas,

I think adding new Table to existing publication will trigger snapshot.

What about creating another Replication with just a single table? Then snapshot will contain only that table and it...

Great free tool (Addin for SQL Server Management Studio 2008 / 2012) is SQL Hunting Dog

Red Gate tools are usually very good - we have been using Red gate backup and data comparison.

For everyday monitoring you probably needs something like Red Gate Monitoring or Idera...

Hi,

the basic tools are:

SQL Server Management Studio (SSMS)- for designing and administering SQL Servers

SQL Server Integration Service (SSIS) - probably to generate your datawarehouse

SQL Server Reporting Service (SSRS) - to...

Hi, for free quick search / smooth navigation Addin for SQL Server Management studio 2008/ 2012 you can look into SQL Hunting Dog.

It is free and very easy to use...

It will work with SQL2012 Management Studio as well as with 2008 (R2).

Basically it adds a new window with easy navigation - you type a couple of letter and it...

Hi Guys,

talking about plugins I have developed one - quick search for SSMS 2008 R2.

Let me know your thoughts..