I was able to get it to work with this syntax:

BEGIN

erp_systemerror;

END;

Thanks for the response. It doesn't return anything. I tried qualifying it with the schema name. Several variations of execute etl_onk.erp_systemerror;. Still the same error. But...

I don't want to run report server on another box. I would rather use the report viewer control in asp.net and hook up to a server side report. ...

I don't think you understand. I don't want to make an xml configuration file. I am storing my configs in a database. I'm just looking for a...

In my organization, we as the developers don't do the deployments to production. Instead we automate them and hand them off to the DBA. I like using the...

Yes, we do have different dev/test/prod environments. I interpreted the email to mean that they plan on using different schemas for security reasons.... could that be it?

I should probably...

For those of you actively following this thread:

I gave my input, and here is the rebuttal I received (see below). I've decided to leave the argument be for now...

True, I do agree that hard coding things in general is not a good thing. I recently needed to restore a backup of a db to a different server and...

Thanks for the replies so far.. I actually agree with including the db owner, but I work with a bunch of geeks who are afraid to "hard code" anything... so...