@Alvin - I can connect to other instances.

@spaggetidba- It's a default instance

@Eric- I can ping server. Trying to connect with IP address don't work either.

Thanks!

I tried to force TCP protocol. This time the error is slightly different..

Cannot Connect to<servername>

-The network related or instance specific error occurred while establishing a connection to SQL Server. The...

Hi Spaghettidba, Everything looks good in comparison to the article you provided. The problem still exists.

Here is the error message -

Cannot Connect to<servername>

-The network related or instance specific error occurred while establishing a connection to SQL Server. The server was not found or was...

Thanks Jacob and Scott. For now my issue is solved as this index will be filtered out from my maintenance plan (its the only one I have having issue with...

Thanks for your invaluable comments. I looked at the execution plans for IF( SELECT COUNT(*)... ) and IF EXISTS options and its giving me identical plan. But I am going...

Hi Jacob, here is the xml from deadlock graph. Thank you.

<deadlock-list>

<deadlock victim="process7bd708">

<process-list>

<process id="process7bd708" taskpriority="5" logused="0" waitresource="OBJECT: 6:385436447:17 " waittime="1489" ownerId="10639817493" transactionname="ALTER INDEX" lasttranstarted="2015-02-22T07:32:52.300" XDES="0x6a8ebb950"...

You can try this-

SELECT COUNT(*) FROM sys.sysprocesses

WHERE dbid>0

How about this?

CREATE FUNCTION dbo.SplitString ( @string varchar(4000))

RETURNS @Result TABLE(SpiltedString VARCHAR(100))

AS

BEGIN

DECLARE @xml XML

...

Thanks for your reply Ray, and yes my report server and db server are in different boxes. When I use sql authentication, it works, but having problem with windows...

As you mentioned, tsql started and completed event will gather too much data that it will often be hard to analyze and get to what we are looking for. Loading...

If you just want to write job output to some kind of file, this is what you can do:

- Double click the job you created

- Click Steps and list of...

The query looks good. I don't think there is any additional arguments to be passed for attachements. The only thing I would like to point out is SQL Server limits...

You are able to take a database offline and bring it online with following code. Its not necessarily the restart of a specific database, which I am not aware of,...

As said earlier, I would say there is no definite right answer. Just wanted to share the issue I recently faced. We were using table variables for staging purposes before...