Unanswered: New Login Genetated when a script is run
First of all, I should say that I wrote this code in Delphi. but it seems that the problem is more general and relates to Ado or sql server engine.
I have a query component that is opened in server and I want to run a script in server from my delphi program. when i do that , i saw in sql profiler that a new login to server has been generated(Audit Login) and i don't now why. the problem is that I want to run some sql code in this way and whenever a new login is generated in sql previous codes are lost. Please Help Me!
Yes, Exactly. After opening a query in server I want two run some scripts for example Begin Tran Save Tran T1 ... RollBack T1 and ... .
but After running Begin Tran, Save Tran T1 generate Error that says there is no active tranasaction, something like that.
One thing I can guarantee - this is nothing to do with a problem with the SQL Server. It accepts connections and executes requests, that's it. Something else in your application is causing multiple connections. If I had to bet, I would bet on your code. Are you closing and recreating connections, or destroying and recreating ADO objects?