I checked  dbo.sp_WhoIsActive...

ok. I will run this when it happens again.
Everything is happening from application not ssms

Thanks for the info.
But What exactly I am looking for and how I can identify the session which is causing the problem ?
Thanks,

Shashi

I don't know if I can use variables in select. I want to create a view for my select statement

This is the only process stuck in Runnable state. As i Refresh the CPU is going up every second .

What does that mean and how to resolve this?

Why Readuncommitted?

- I don't know. The code is a part our ERP system which came from our vendor.

Is incorrect data acceptable here?

- I don't know what that means.

Try...

Here is the code for the Functions used in first INSERT statement

ALTER FUNCTION [dbo].[ApsPlannerNeedsBom] (

@pJob JobType

,@pSuffix SuffixType

)

RETURNS Flag

AS BEGIN

DECLARE @f Flag

-- Jobs for which we...

Thanks for th replies. The password is stored using AesCryptoServiceProvider (that's what I was told). Is there a way to decode is on the sql side?

I have already done TCP/IP changes. But still does not work.

looks like after renaming the server. it didn't chage it.

INSTANCE NAME IS SRVDR

Quick questions

1) What does the command "nslookup SRVLIVE" in a command prompt return?

returns me SRVLIVE.intranet.xxxxx.com

2) Are there any host file entries for SRVDR on the systems?

NO

3) Have you checked using...

ok thanks