A serious error in running scripts from delphi.

The thing is that I want to have these scripts  run in seperate places in sqlserer. to clarigfy it needs to be described more.
What I really want is a Transaction Management which is written in sql  on my application and wrap all of the sql opearations using ADO that run in my application.
Suppose this:
AdoConnecton.Execute('Begin Tran');
AdoConnecton.Execute(Save Tran T1');
...
we can have here some ado operations.
--
AdoConnecton.Execute('Begin Tran');
---
...
in some case
  AdoConnecton.Execute(Rollback Tran T1');
or
  AdoConnecton.Execute(Commit Tran');
.
.
.
As you see my problem is broader than that. Having Considered this, I concluded that the problem relates to opening server side cursors from ole-db provider. whenever you do that sqlserver ,as the Microsoft's sqlserver support site said, create an implied login in a current login and the problem is generated.
By the way, Having Sad all of that, I am still hopefull that perhaps there is a solution.
Any Help Would Be Apprecated, Dear Friends.
Thanks for reading.
With Regard.

You can begin/end and rollback transactions with an ADOConnection object, without using database executes...

  adoConnection.BeginTrans;
  ...
  do what you need here...
  ...
  adoConnection.CommitTrans;
  ...
  or
  ...
  adoConnection.RollbackTrans;

This should mean that you're back to the easiest choice of having your changes in a separate ADOQuery, rather than lots of individual executes.

John

Thanks for your attention ..
I know What you mean , but the question is this , Using ADOConnection to start and finish a transaction , can u use the nested transactions ???
These are all to use the nested transaction ....

Yes, and no.

You cannot use the method I mentioned above for nested transactions - it simply won't work.

The only way you can do it is within an sql script that you execute via ado (query, command etc.).  This, I suppose, brings you back to the root of your question.

You can do what you are asking, but it must be done by 1 single script that gets executed in 1 hit.

Can you create a single script in query analyzer (or similar) that does what you need?  That's what you need to do, and then execute that script from your app.  Chances are, there is a way to do what you need, but you need to figure it out in a script, rather than in Delphi.

I've answered your question mate - the link in my previous post has a code example of the exact thing you've asked for.

My recommendation would be to mark this as the answer...

http://#a23361261

...but give the guy his points back.  I'm not a points hunter, and he's obviously reluctant to give them out.  I think this matters more to him than me, but it *would* be a shame to let the answer to a fair question just get deleted.

Cheers.