The product is definantly a good idea and is off to a nice start.

A few of the lines between object came up in maroon, this color isn't in the key,...

Plus if your stored procedures are ANSI compliant then your application will port to other databases quicker.

I always wondered why anyone would want to keep the integrety of a database...

Mike c, that is a good interview question, how do retrieve a GUID after an INSERT. Perhaps you can do a writeup on it and post it to the...

Please send to script to help others who may wish to utilize it

Brett

You need to extend the connection timeout period for ado. The default is 15 seconds.

assuming you are using a connection object of cn:

cn.ConnectionTimeout = 30

Extend it more if you...

Dyslexia strikes again. I am embarrassed to admit it, but I will anyway.

sproc is sp_checkDeductionsAtDiv

referenced as sp_checkDeducitonsAtDiv

I new it just didn't make sense.

Thanks for the...

So There isn't anything else that could call this?

Both sprocs being called have been in the database for weeks, hense the reason that I am confused on why this is...

Thank you for the responce, Remi

This is the whole reason I posted this; I did recreate the sprocs as you listed and I still receive the warning.

Thank you...

Thank you for the responses, I have over 160 sprocs in this database stating with sp_, so it's a little late now. I have tried mydb.dbl.sp_name and it...

I often restore the database to the same server under a new name. 

In our .NET applications, every database query, every SqlDataAdapter command object uses a stored procedure.  It helps maintain an n-tier environment.  Why have your queries in code where you will...