I know... that one was reffering to the other loop version.

Please tell us if you can avoid the problem using alter instead of drop/create.

I'd like to see one of these cursors and give it a shot at a set based approach .

HTH.

This is where it pays to know the systables by heart (almost) .

What is it with you guys and loops today??

This is a freaking basic select from one table. Why do loops, inserts and reselect from a #temp table??

That's it... there's a refference to the trigger in the table's row of sysobjects, hence modifying the table (however slightly). Try running both at the same time to see...

I know... redirected all other posts to this one.

Actully was posted 4 times... next time give the server a chance if he's slow... even if giving an error message, the...

You know your system better than me... but I still have to find a problem that can't be resolved with a set solution (administrative task aside).

Thanx for the definition.

As the users table been modified in any way recently (that means anyone running any script, or even pressing save in EM even when it seems no changes were made).

Are...

I meant in here . I'm not the only one who needs this info to help you.

You can acutally send an ADE (compile module). where the user will only access what you want them to (with menus/forms). They won't be able to access anything...

Hmm. Can you send the code of the procs (complete)

I see why... you are using them a lot, even if you try to avoid it. I can only imagine someone who doesn't want to learn the set based...

It means that the datatypes allow that to happen. It throws an error when you try to insert data that is too long :

create table #test (a varchar(8000),...

Quadruple post, finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=211788