Sometime while connecting MSSQL 2005 Remotely OR locally using MSSQL Management Studio (using user as SA) it throw following Error
Find Table Count and Tables 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
Error: SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name.
Sometime while setting up MSSQL Replication you will receive following error at the time of connecting Slave or Secondary Database Server.
Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part-IV
In Previous three parts I have explained about
Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable
Sometime while connecting to MSSQL Server Configuration Manager it throws following Error
Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II
In previous article (Step by Step Guide to MS SQL 2008 Transactional Replication over Internet Part – I) I have explained replication and how transactional replication work. Now I am going to explain some pre-configuration settings which need to be done before setting up MSSQL replication over Internet and also I will tell how to configure a Distribution Agent.
Milind Koyande is the Senior Research Engineer and his job is to work with new technologies, specially Cloud Computing / Virtualization Technology. His past projects include Government Sector initiatives, Backup and Disaster Recovery Solutions. Follow him on 
