It is a datetime field.

I figured it out. Thanks for all the help. It is greatly appreciated.

The script worked great. I tried setting up a job to run this script, but it fails each time. Do I need to change something in the script in order...

I figured it out.

Thanks for all the help and guidance.

Sorry for such a delayed response but I have been pulled off every project I start. I am now back to this again. Here is what I have, setup on...

Thanks!

I appreciate all your help. Thanks.

In order to test, I just followed your instructions using the SSMC. I still don't know how to create a stored procedure. Any help would be greatly appreciated

I tried testing the db permission "Execute", but it returns an error stating that the user does not have Select permissions on the table.

I am new to SQL Server and can certainly navigate through the GUI, as you instructed, but I would really like to learn how to setup a stored procedure. Where...

I would like the count of licenses in use, returned from the script, to be saved in a log file or something for viewing. Will the instructions you sent cover...

Got it. I appreciate all the help.

The IDENTITY column is our NonConforming Material Number. This is a unique number manually assigned when the reports are setup. Moving forward we will be using an Access database and...

Thanks for all the help.

Ok, I see what you are saying and I tested. I entered in some data and hit my save button. It didn't pull the NMR_No into the form, even though...