Any thoughts please?

R.P.Rozema (4/5/2016)

No, that's not the point being made. "They" should have monitoring in place on the operation of the SAN. At the very least, the SAN sends out emails when...

R.P.Rozema (4/5/2016)

No, that's not the point being made. "They" should have monitoring in place on the operation of the SAN. At the very least, the SAN sends out emails when...

Jeff Moden (3/17/2016)

---

Worse than that, there was a bad disk that slowed the system down...

Grant Fritchey (3/8/2016)

---

With no details on what the job does, the best thing would be to capture the wait statistics before and after the job runs. You can then compare...

Jeff Moden (3/11/2016)

---

There's something else going on here other than just the double-hop. Using RAISERROR with a severity level of 16 should not prevent remote execution. The original...

tony28 (2/26/2016)

---

I think that you have to write whole procedure. will be better for understanding why will be catch and when ..

And I am not sure if this is problem...

Ok. Thank you very much. Let me try these.

Thanks for the response.

tony28 (2/26/2016)

---

I think that you have to write whole procedure. will be better for understanding why will be catch and when ..

And I am not sure if...

Helloooo.... Any comments please.

Hello All,

Do I need to post this message somewhere else to get some clue?

~Shaiju

Hello,

I think the issue is here. I have a code as below in the stored procedure. If remove RAISERROR from the code, I am able to alter the sp.

From the...

Done :). Thank you very much.

SELECT @lCommand = 'bcp "SELECT text FROM ' + DB_NAME() + '.dbo.syscomments WHERE Id = ' + CAST(@lObjectId AS NVARCHAR(100)) +...

Hi,

Please check the below link. It is showing how to get the user details who deleted the data from Transaction Log.

http://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/

dan-572483 (10/2/2013)

---

I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed,...