jungle.ed (7/26/2012)

---

Any chance we can see this bulleted list? Thanks. I also need to convince my boss that cross database joins are just as fast as long as its on...

Matt Miller (#4) (7/26/2012)

---

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...

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 knows of...

I'm confused.:unsure:

If I execute:

EXEC .usp_Insert_Into_Problem_Type_Codes

I get:

Command(s) completed successfully.

But the CATCH Block fired of and Inserted a record into the Error Table because I did not TRUNCATE the Table which resulted...

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 your catch...

Sorry. I did mention that I had converted the SELECTS to an INSERT INTO TABLE but it was not obvious.

In the CATCH Block of the offending Stored Procedure I'm calling...

Sean Lange (7/25/2012)

---

Welsh Corgi (7/25/2012)

---

I did that and it worked fine.

I have a...

I just got the same error.

I had created jobs perform backups and I'm the owner.

I'm backing up to the local machine.

I'm sysadmin and all of I sudden the job...

Sean Lange (7/25/2012)

---

Welsh Corgi (7/25/2012)

---

I did that and it worked fine.

I have a...

I did that and it worked fine.

I have a very basic question.

If I...

Sean,

I got this code from your link. How would...

Sean Lange (7/24/2012)

---

Matt Miller (#4) (7/24/2012)

---

Sean Lange (7/24/2012)

---

This thread has a good example of using OUTPUT with MERGE.

http://www.sqlservercentral.com/Forums/Topic1325508-391-1.aspx

There is nothing magical about try/catch blocks in t-sql. They work just like...

Sean Lange (7/24/2012)

---

This thread has a good example of using OUTPUT with MERGE.

http://www.sqlservercentral.com/Forums/Topic1325508-391-1.aspx

There is nothing magical about try/catch blocks in t-sql. They work just like the same constructs in every...

Lynn Pettis (7/22/2012)

---

Or you could do either of the following:

begin try

create index IX_NotNullID on dbo.TestUpd (

TestUpdId,

...