Congrats buddy, enjoy the success 🙂

Thanks for following up. The issue was resolved, we had just increased the timeout value for agents so that they don't end up with time out error.

You should not be worried about the Sleeping/Awaiting Commands session unless they are not blocking other sessions. SQL Server does it, so that it can reuse the same connection.

I am not sure if it is exactly the solution, but I think you need something like this:

CREATE TABLE #MyTestTable

(

Row INT,

Person INT

)

GO

INSERT INTO #MyTestTable VALUES (1, 101)

INSERT INTO #MyTestTable...

Didn't you perform a full backup of your databases prior to applying the service pack? You can first try to uninstall the service pack & check if you are able...

Questions asked with such limited information/clarity have very less chances to be answered/answered correctly.

jyoti.patel (2/20/2012)

---

We would like to automate a way to restart SQL at 5:30AM local time every morning. We have an application that hangs until the SQL service is restarted. Cau...

vemula.narayanan (2/21/2012)

---

Hi ,

Please find the logic for the below table in sql 2005.(without using the while loops)

InputOutPut

Row Person Row Person Count

110111011

11021 1021

110311031

210121012

21022...

Performed this months ago. It works fine & the technique is quite familiar these days.

I am not sure if your problem has been resolved. However, did you try o run the DBCC CHECKDB in offline mode? OR you may restore the backup of this...

I am not sure how he is identifying the events. I don't see any column which can be used to uniquely identify a particular event...

sqlnaive (2/21/2012)

---

I tried the same actually. I opened two sessions and from one of them I ran one update statement. Once I closed that session with update command, and performed...

Shrinking data...

sqlnaive (2/20/2012)

---

I was monitoring the sessions through this dmv and found that sometimes even if the session is closed ,it is viewable in the result. Can someone clarify this nature...

Have you run DBCC CHECKDB on it?