You are using almost 15 INNER JOINS that's also not very good idea.

Please provide more information about the issue .

Make sure when ever you delete the Publication , drop the subscription first and then move to publication . Based more...

One more option you may choose is Importing the SQL data from Excel via data connection option . You can convert the query the way you want .

That is not usual , you mentioned queries not a single query which got blocked . SPID 44 blocked multiple queries ?

I dont know the cause of this like many SQL unaswered issues , but good part figured the solution 🙂

Nothing tricky , found the xact_seqno from sp_browsereplcmds

1. Checked...

I have done this multiple times most of the time it runs pretty smooth HBA firmware and drivers doesn't impact SQL layer of files . If you have EMC its...

Firstly do you run the backup via some job which runs on schedule time or you run the backup manually , very likely it should be a schedule one ....

Keeping in mind the different types of Database restore 😉 and source and destination SQL versions.

Basic good info : http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

Not a very good idea if you are considering future performance and other DR deployement .

If your SAN admin is creating different mount points in the drive then the...

Does your other transaction or SP working fine with same linked server .

Pretty good explaination. Worth spending time on the read.

What type of error you are facing that can help in answering better . For any SQL to uninstall first SQL needs to be uninstalled then the components .

Lot...

Quick way connect to distribution database and run below .

USE distribution

GO

SELECT * FROM MSdistribution_agents

SELECT * FROM dbo.MSlogreader_agents

SELECT * FROM dbo.MSsnapshot_agents

thats right it has to be physical name even in repl tables it stored based on physical names.

Thanks Perry ,

I explored a tool from provided by http://dh2i.com/ . This tool faclitate settign up MSCS without WFCS.