Steve, There is no need for any apology...:-) You cannot control what others write or how others behave. Thanks for removing the comment though. It wont look good on him...

Thanks for the update Jason. It works in all my Databases I have. In some database I dont even see those tables.

If you use is_ms_shipped = 0, does it not exclude those tables?

Thanks for standing up for me 🙂 I appreciate it very much.

This is the first time I got insulted here. Feels kind of strange... But what ever.. I will...

You can use SQL Profiler to get any kind of trace. It would be best to get the profiler information stored into a table where you can do better analysis...

MSDB if I am not mistaken almost all tables are defined as User tables.

For SQL 2008, you can run one of the standard reports that is available. There is one called Top Queries by Average IO. Check if that helps

The query I gave returns only user tables in all my databases. I tested it again on two different servers. I am not sure why it is showing system tables...

Cant you just do this and get the results?

SELECT * FROM dbo.sysobjects

WHERE OBJECTPROPERTY(id, N'IsUserTable') = 1

Delete the records in the tables you mean?

If you defined the relationship with cascading option, then you can delete the master table and the records in child tables will also...

Do you have any auditing set up?

Also check teh standard reports that is there. You can see schema changes and all that.

There are lots of sample scripts that does what you want..Search for it and you might get it. You will need to add/modify couple of things. If you know how...

Then you should go for Jason Brown solution. less complication about defaults and all the other stuff

As per books online

Configure distribution at Server A, Server B, and Server C.

Create a publication at Server A by using the New Publication Wizard.

Enable the publication for peer-to-peer replication by...

Power shell is a good tool for you to do this. You can do what ever you want with Powershell. Check it out.