Christopher, can you explain a bit more in detail what the conversation you and Jeff are having is about?? I don't want to get lost here.....(ok, anymore lost.....)

Thanks guys!!

I am getting an error msg:

Msg 208, Level 16, State 1, Line 11

Invalid object name 'sys.sql_Modules'.

do I need to run it against a certain DB?

You rock! Thank you!!

thank you!! That worked!!

Hi...I was just trying to find constraints that existed and I did it this way:

SELECT * FROM dbo.sysobjectsso

where so.name = 'DF_SortsMtfSendingProcessConfig_SShKeyFile'

and so.xtype = 'D')

I then built a test...

thankyou, I am headed there now!!

thank you!!

thank you! That is exactly what I want to do...it is just for my own information anyhow...

Thank you again...

thank you for these suggestions on error handling. Do any of you know a good "template" for writing the error information to a log file??

Thanks again!!

Fair enough, and thank you for the reply. Now.....

I moved the error code under each statement.

select @ErrCode = @@ERROR, @TranNumber = @@TRANCOUNT

print 'error inside the...

I have to agree with you, that feature is really nice! Now that I can comment/uncomment, I am a happier girl!!

At least it is there...just something else new I need to remember!! Thank you so much!!

thank you! in looking at it to be sure, I realized that the script I was running I had numbered wrong and the fk table was being populated first...

God Bless you!!

thanks a ton!!!!

thank you eveybody!! I appreciate the help! :hehe: