the problem consists in that if exists some 'select' before the print, the print can not be captured, it does not show nothing...........

with this...

Ok sorry, i will say to the wemaster that delete this

I tried with that  but it continues displaying nothing...

Alas, why this proc i cant capture the print 'hello' ?????????

create proc SP_test

as

begin

select '1'

print 'hello'

select '2'

end

----------------------------------------------------------------------

My visual script

--------------------------------------------------------------------------

Set cnn1 = New ADODB.Connection

  cnn1.ConnectionString = "driver={SQL Server};" & _

      "server=" &...

i need Only a visual basic code...

for example

set objsDB = Server.CreateObject("ADODB.Connection")

'oConnDB.CursorType = 3; //adOpenStatic

objsDB.CursorLocation = adUseClient

objsDB.ConnectionString = AppCacheRead("DSN_OPTIONAL",msUserID,mlSiteID,msSessionID)

objsDB.Open()

set oCmd = Server.CreateObject("ADODB.Command")

oCmd.ActiveConnection = objsDB

oCmd.CommandText = "exec CP_IncidentReassign " & cstr(mlSiteID) &...

Friend, Do you have some scritp of  example to do that???

i need to display the print into a  messagebox... thanks

Well that dll is sick, but i think better to build a new dll, i need to build a dll to show me the prints of sp , do you...

Hello, sorry my bad english , this dll is sick with the selects, the dll must to display in the webinterface the print messages like  ( print ' Wellcome our...

Ok it is a large history... well have you heard a system of CRM called Onyx?

well occurs that this system is made with a flow of sp encrypted, the encrypted sp...

Ok it is a large history... well have you heard a system of CRM called Onyx?

well occurs that this system is made with a flow of sp encrypted, the encrypted sp...

yes i coud do it, but mmmm i have read that the  distributed ransactions not will be affected into rollback but they are too,well by the tests that i have...

Great you are a giant, but is possible to recover the values of another sesion??? thanks

mmm is posibble if the table table2 would be in another server?

using a  distributed transaction ???

for example

begin tran

insert into table1 values('a')

use server.base

insert table2 values('B')

rollback

the table2 will be affected with the rollback?????

if...

Thanksssss Master  i didt know that trick

 the force is with you