Hi All,

To resolve this issue, I have created two scripts one for SQL 2000 and other for SQL 2005. Check out them

http://www.sqlservercentral.com/scripts/Monitoring/63309/ -> SQL 2K

http://www.sqlservercentral.com/scripts/Monitoring/63307/ -> SQL...

Hi All,

Incase even after having 2005SP2 and still if you facing this issue then it shows that there is no enough Memory for SQLServer. How you can...

Hi All,

Even after trying all above possiblities and if your named pipe issue is still not resolved then 'REINSTALL SQL SERVER INSTANCE' it will work.. 🙂

Microsoft is...

Hi All,

After contacting Microsoft we got the reply that this error is by behaviour.. so below are the option...

1) Remove the words creating issue from noise word list...

Hi,

I forgot to update the forum... Nope.. It is still not working... I'm using SQL authentication with hardcoded user ID..

Hi Sam,

Let me check this when i go to office... I think it is the culprit... Thanks!

We had similair issue.. I had call with Microsoft and they are saying that their driver does'nt support any oracle database greater than 8i. Even for us the linked server...

Hi All,

Happy to see that you all are interested in sharing your experience... Also give some explanation about setting performance baseline and how to compare...

Hi Manu,

Thanks for reply! i did all these but still the same issue. I'm able to connect to SQL 2005 instance in the same server using...

Hi,

Thanks again.. If I take backup manually then your answer is ok.. But how about bakcup running through job... Here is my question... Any...

Hi,

Thanks for your reply... I understand... but my intention is that even previous bak file is deleted then backup should run without error. .. how...

Hi Brian Kelley,

Thank you so much for your reply! Just Y'day i got this site through googling... and found...

Or is there any T-SQL Query to find on which port a particular instance is running? I checked in sysrpocessed for one SPID it shows which protocol it has used...

Hi Kevin,

xp_cmdshell is diabled in production servers we cannot use this... 🙁

Hi Lester ,

Yes that is what i have done... but as said.. SQL Server stops execution and select query level itself...it is not executing next line itself... Hope...