If you need to check if there is any database on your SQL instance, related to replication, you have couple of different options – from manually checking through SSMS to using different options with T-SQL. Now I will share a simple script that you can use if you need to quickly check if your databases are part of a replication.
The script itself is exposing information in sys.databases, so you will need proper permissions to do that (I guess you are a sysadmin already :) )
SELECT name as [Database name], CASE is_published WHEN 0 THEN 'No' ELSE 'Yes' END AS [Is Published], CASE is_merge_published WHEN 0 THEN 'No' ELSE 'Yes' END AS [Is Merge Published], CASE is_distributor WHEN 0 THEN 'No' ELSE 'Yes' END AS [Is Distributor], CASE is_subscribed WHEN 0 THEN 'No' ELSE 'Yes' END AS [Is Subscribed] FROM sys.databases WHERE database_id > 4
Once you have the output you will have to dig up a little bit to see the details about the replication your database(s) is part of. The script is just pointing you the direction. Here is an output:
Note that you have two different columns for the publishing part – one for merge and one for transactional/snapshot replication.
If you want to write your own version of the script, you can also use DATABASEPROPERTYEX function – http://technet.microsoft.com/en-us/library/ms186823.aspx