cox1ray (7/26/2012)

---

is essential to take your company’s uptime during and after the disaster. begins with the development of an urgent situation plan. The first thing is pulling together...

capn.hector (7/26/2012)

---

vchandm23 (7/25/2012)

---

CREATE PROCEDURE [dbo].[myProc]

@whereSql nvarchar(256)

AS

EXEC('SELECT [fields] FROM WHERE ' + @whereSql)

GO

From stackOverflow website. This is what i was looking for. I am sharing this...

Stefan Krzywicki (7/26/2012)

---

Sean Lange (7/26/2012)

---

Stefan Krzywicki (7/26/2012)

---

Sean Lange (7/26/2012)

---

Here's a chuckle for you security types out there. I was trying reset my security questions today on the ADP site because...

manub22 (7/26/2012)

---

It is true you can make cursors more optimal than a while loop but why bother with them at all? In your examples there is absolutely nothing that can't...

manub22 (7/26/2012)

---

Who said CURSOR is slower than WHILE loops? Didn't you asked them...

morepainot (7/26/2012)

---

Jeff and Sivaj, thank you guys for your help.

@jeff; I understand what you said and I will keep that in mind for the next post. The reason for the...

Stefan Krzywicki (7/26/2012)

---

Sean Lange (7/26/2012)

---

Here's a chuckle for you security types out there. I was trying reset my security questions today on the ADP site because apparently the available questions...

Here's a chuckle for you security types out there. I was trying reset my security questions today on the ADP site because apparently the available questions change from time to...

ChrisM@Work (7/26/2012)

---

Sean Lange (7/25/2012)

---

Phil Parkin (7/25/2012)

---

Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong...

edward_hall76 (7/25/2012)

---

I figured out how to get my software to update without having to close the program I was able to add a button that did a windows refresh with...

Welsh Corgi (7/25/2012)

---

I thought that it could be as simple as a return code to indicate that there was an error.

This procedure will be executed in an SSIS Package.

If someone...

Welsh Corgi (7/25/2012)

---

Sean Lange (7/25/2012)

---

What is the question? I am not sure where you are stuck. You built your proc to log the error. Now just raise it again inside...

I think the OP is having problems with his application and not sql. In other words the 3.5 Million rows is too much for his .NET app. I suspect the...

What is the question? I am not sure where you are stuck. You built your proc to log the error. Now just raise it again inside your catch to have...

That looks correct. Did you try it? It might make things more clear if instead of calling RAISERROR yourself change the try block to something that will raise and error.

BEGIN...