September 5, 2001 at 10:21 am
hello there
ihave a problem with this stored procedure (sp_makewebtask). I want to create the file in an other computer then mine and i proceed like this :
create TRIGGER _TRIGGER_TEST ON [dbo].[Table_SAV]
FOR INSERT, UPDATE, DELETE
AS
execute sp_makewebtask
@outputfile='\\MyserverName\MyDirectorie\test.xml', @query='select refclient from table_sav for xml auto',@username='TELECOMPARTNERS\HADDAD',@dbname='TPAccessSQL',@templatefile='D:\DATA\Multiple.tpl'
But evry time i have an ODBC error message from sqlserver which says me that there is an other user which use this table
I don' t understand
help me
September 5, 2001 at 7:45 pm
You're creating a new web task each time instead of running it using sp_runwebtask? Can you explain a bit about what you're trying to accomplish and why?
Andy
September 14, 2001 at 10:37 am
i try to save the result of an insert in a file, the stored pc is in the network.
And for this i use a triigger wich called the stored procedure sp_makewebtask.
I suuceed in a local computer but not in the network.
ps : sorry for my english, i make my best.
i uselly speek french
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply