Post shows how you can Find total number of Tables in a database and the Tables which are without Primary Key in MS SQL
Few days ago while working on MS SQL 2008 Transactional Replication I have faced following two issue
1) To find out the total number of tables to verify that Primary Server and Secondary server have same table count.
2) Tables without Primary key: After replication setup I have found that some tables were not replication. When I checked the logs it showed following error
“This table cannot be published because it does not have a primary key column. Primary key columns are required for all tables in transactional publications.”
1) Find Number of Tables:
Read more at eitwebguru.comuse <database name>