My issue was fixed by the information at this link:

http://www.writebetterbits.com/2008/09/debugging-sql-server-service-broker.html

Specifically, retaking ownership of the database back to the SA account.

Now who changed it, that's not a...

While the physical issue related to IT are well covered, what is not covered is 'stress.' I believe IT is one of the most stressful occupations you can have....

Update. Some problems still exist. Management brings in a consultant. Guess what system works likes a complete champ while the consultant was here. Our development system....

Reality is sites like this have real people that need to make a living behind them.

Furthermore, as a professional, having someone outline such a product doesn't take away...

Actually, I resolved the problem. What was throwing me off was the proc's first parameter has a default.

The problem was the code calling the procedure. ...

I use functions all the time. In our database we deal with a lot of issues with measurement and currencies that require changes on the fly to different measurements....

Rob,

This is kind of like the SQL equivalent of a House episode. Nothing against Access developers; however, I often find that these are built by people with business knowledge...

I agree with a lot stated here. Couple of comments from my general experience:

Not sure I necessarily agree with prefixing objects

with t for table, v for view....

And part of this solution is changing the way we all live and that's an endeavor that will unfortunately have to be forced upon us.

One idea I had was...

Developing nations should be steered towards other alternatives beside nuclear energy.

Windfarms, solar cells could all be used in places like the Sahara desert.

The world just doesn't...

To be honest, you have done an excellent job for the SQL Server community. This is my first stop when I'm wanting to learn something new about SQL outside...

Yesterday when I visited the forum site, for some reason everything below the 2005 was not there or at least did not show up on my screen. So I...

Depends on the web technology and a lot of other factors.

I used centralized routines to make connections, get recordsets etc. In those routines, I have error checking and...

I'm curious, how would you check a status table in the database if the database was down in the first place?

I suggest you look at the code. I'd offer to bet you have two resources locking each other or you have a lock on a table not being released.