Actually in SQL I think it's:

'''' + Format(FieldName, '####') + '''' to output a leading zero suppressed four digit number surrounded by apostrophes.

And you can't remove the delete button?

Great, I'll try it!

You got that right!

Unfortunately I got stuck at the second step where I detach msdb. Since I think I followed the first step exactly as laid out by Microsoft I will give them...

Just thought you would like to know it works great. The only other change was the insert into A also had to be a list of columns.

Otherwise it worked as...

Thank you for all of your time!

Thank you! Much better than the solution I came up with!

Wow, that's a tough one. My guess would be security/privileges. Has someone recently changed group policy for your systems?

So instead of answering his question you flame him on syntax?

I learned a lot about T-SQL from this post!

Thank you very much!

The lists and arrays article is perfect! Thanks!!!

Thanks for the information; that was what I was missing! I will try an alternative.

Thanks Luke, works perfectly!

Sure, I have four stored procedures that create stored procedures (prMakeDeleteRecordProc, prMakeInsertRecordProc, prMakeSelectRecordProc, prMakeUpdateRecordProc)  and they each take a table name is an input parameter. I want to loop through all...