Just to clarify on the scope of stored procedures, as I am new to SQL*Server development --

When executing a stored procedure, the scope of that stored procedure is contained within...

Yes, I believe there is a place in each database which indicates which "grading modules" will be a part of that database.

It was discussed a long time ago about putting...

Yeah, it would be nice if it were that easy.

Our environment is such that each database is a lego-creation of different applications. We evaluate or grade images of eyes...

We have the database creation and object creation scripts already taken care of. I simply need to figure out a way to efficiently create the metadata within the tables....

I am in need of a very similar situation and agree that hard-coding the database name into the procedure is a bit pointless. I would like to create such...