January 25, 2002 at 11:27 am
Can I create a aspx file from the change(insertion) of database in a user-defined format, e.g. retrieve a field's data into a hidden type variable. Where can I have more info about web assistance of SQL 2000?
January 25, 2002 at 12:44 pm
Have spent no time with .Net - but I think you're wanting to create a text file each time a value is inserted? You can do this in a trigger if the file will be fairly small, if large or frequent you should probably do it in a job and mark as done once completed.
Andy
January 25, 2002 at 1:24 pm
I agree with Andy, but what you are asking is a little unclear. If you are expecting a SQL message to be sent when data changes, this is really a trigger, but you would need to configure your server to call the ASPX page. This is dangerous in a trigger as any error in the page could cause the data change to rollback.
Can you explain better what you want to accomplish?
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 20, 2011 at 8:20 am
Hi guys !! I'm in a serious trouble with SQL Web assistant (SQL 2000). I need to create an XML file once a record is inserted in a table (typical trigger). I've tried with BCP started via cmdshell in a Stored Procedure launched by a trigger but it doesnt work (never finishes). Now I'm trying with sp_makewebtask but I received the following message: "Error 16804 ... SQL Web Assistant: Could not establish a local connection to SQL Server" What can I do??? I couldnt find any information about this kind of issue. Thank you. Mary. 🙁
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply