Then, unless it had all optional parameters, the tutorial was wrong. Service Broker passes no[/b] parameters to the activation procedure, so if it requires any, the activation will fail.

kambanjet (2/8/2010)

---

Good Day,

I would like to ask for help on setting up auditing in SQL 2005 for any updates, deletions, and insertions done through the back-end or through SQL...

Bob Hovious (2/9/2010)

---

Crap! My wife just...

OK, I think that there is a very important conceptual block that you must address first, before you can ever be comfortable with this. Let's start here:

Dave Winchester (2/9/2010)

---

...Would...

Barkingdog (2/9/2010)

---

Under sql 2008 creating a new database creates a schema called db_datareader. The owner of this schema is "db_datareader". The owner of the role named "db_datareader" is "dbo".

1....

BrainDonor (2/9/2010)

---

Instructions on how to use the tags would be nice, possibly emailed as part of the initial registration or as a pop-up within the Post Reply screen.

It took me...

Crap! My wife just called me "Bob"!...

CirquedeSQLeil (2/8/2010)

---

Bob Hovious (2/8/2010)

---

[h2]Urgent![/h2]

Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC...

[h2]Urgent![/h2]

Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC Timewarp[/font], but something has...

Yes....

(Oops, bad post. Please ignore)

I fixed up the other function as it had some problems too (two parameters it wasn't using, really inefficient statement structure, etc).

ALTER FUNCTION [dbo].[DebtorProfileGet_New] (@TotalPaid float, @TotalDue float) RETURNS int...

I also cleaned up one of the two functions as it had a lot of issues (an internal cursor, and referencing that missing table). Its not valid without that...

OK, I had nothing better to do today, so I went through and pared your proc down by 1) reducing the number of output tables from 6 to 3, 2)...

I should add also, that if multiple tables are treated in a logically identical way in the proc, then should also be able to eliminate the logically redundant tables.