By any chance was a firewall enabled on the Server? Any local policies changed? Those are the only things that come to me.

The only advantage of using PS instead of T-SQL would be that the Cursor or While loop that has to be used is not on the DB layer but on...

Nice one Sean, I was going to suggest Power shell to do this stuff. First get the Table name from Information Schema and then use a while loop and execute...

If the IP is changed and the DNS is not flushed/propogated, the client when it looks up using server name might get resolved to old IP address. This will throw...

Was there any change done on the Network layer? This look more like somebody changing the IP or DNS entry or both. You could try extending the timeout to higher...

With this select statement, you just set the values to your local variable. If you want it to output to screen then you will have to do

SELECT @SourceId...

You could try exporting into a csv file and then view it. SSMS is not the tool to check if the languages are saved good.

You can check if the...

Why use a function for this? Cant you do it directly from the table instead of using a function. When you want to use function you probably will have to...

With just two drives you are not going to get much out of IO performance. RAID 1 is not great for performance but good for fault tolerance.

Keep in mind that...

Ask your Mom to put some Koi and Gold fish in it... They will take care of the plants..:-D They like eating the root of the plants..

Is that your back yard? It is gorgeous. 🙂

I have pond I am fighting with to make the pond lilies grow. It is a struggle.

Merry Christmas to everyone... Enjoy your vacation for who does not celebrate Christmas. 🙂

For more information on Deadlock, read this MSDN page.

One question, Do you have any user defined datatype in your publisher?

As per definition of books online sp_help

Is the name of any object, in sysobjects or any user-defined data type in the systypes table. name is nvarchar(776), with a default of...