i am seeing the sp_executequery and i can to pass it a declared parameter but i dont know if i can to pass a parameter with values like a variable...

i will take a look to sp_ if you may give me a example i will be very owe, thank you

Yes i know but is for multiple sessions and if i use a global table, it will crash with the others sessions,and i dont want to create table into tempbd...

Thanks but itisnt that i was looking for

well but i found like to solve my problem look

DECLARE @iCount int

DECLARE @table sysname

DECLARE...

For example

begin tran

.... other code

exec @ret = sp_myprocess @data

if @ret = 1

begin

print ' error'

exec sp_LogIsql ' insert into MyTable value (' + @data + ')'

roll back

end

...other...

Well because i need to do a insert inside of a transaction with rollback, well i do that insert using the isql in a cmd shell using the xp_cmdshell

CREATE PROC...

I found a vb script that scrip out all dts into a txt file, well then i need to parse it to do a dependencies file, well i think that...

i am using table variables

for example

declare @tablecursor table ( [idi] [int] IDENTITY (1, 1) NOT NULL

...

MMMM perhaps i didnt let free the cache, mmm but i wanted to know if for some reason the executions into dts is faster, well i thought that dts have...

oh you have saved my job, well if you come to Chile i will invite some beers, thanks friend , you have saved my day

Oh it is a pity, and not exists some trick?

mmm but the examples that i found only they show the ip from server but i need the ip from my local user

is possible?

Thanks, today i learned a new word thanks my friend

Thanks well now i have some problems with net permissions but that i will see myself, thanks for your helping