thanks martin i have seen this case happen many time on other projects with batch files but was unable to confirm this. now that i know someone else has come...

hahahahahahahaha. my bad. 🙂

thanks for the response. i do have logging and for this issue yesterday i have found an error in the logs for a sql script failing which that file did...

who ever posted this "

You can use BBCodes to format your content.

Available BBCodes include: code, b, i, u, s, center, right, left, justify, hr, sub, sup, color, pre, blockquote, div,...

thank for this reference to look at but that is not what i am wanting. i would like to know what are the possible reasons why powershell works some of...

Thank you Mr. Pletcher....

yes the original code is doing a select into. Your answer is what i was suggesting but a coworker mentioned that their was a filter or...

thanks for an attempted answer but i think i was not clear on what i am asking.

ok so you are wanting to manipulate table A and table B from Database...

the idea is to be able to touch, view or manipulate data from the other tables that reside within that same database that is being locked by the linked server....

thank you n79799 and Evil Kraig F for your responses with helping me understand my scenario. 🙂 i have made some changes to the sprocs and now the process...

yes steve you are right. a script component can do the job but you would be up the creek if you do not know VB as in this case i...

update:

i just wanted to state that i read a lot of forum posts and articles and the one thing that the "Experts" say is that the derived column is powerful....