Thank you for this info, I had the same problem and this resolved it.

Thank you for your reply. I actually did use the google search for date ranges, but didn't really hit on anything that helped. I use this site a...

Thanks, Mark. This looks like what I attempted but couldn't quite get. I will try it first thing Monday morning.

Thanks.  We realize the risk and decided the two people who need to run this insert can have the permission. 

If it was an SP for general use, I'd have to load...

Adding the user to the db_ddladmin role worked!

Thank you for your help.

I was getting that same message when I was trying to pass in the table name and use dynamic code.  I also got it because I had "set nocount off/on"...

Thank you for your reply.  Yes, I have read Books Online and am qualifying the table with the owner.