Djabarov, Robert
Robert.Djabarov at usaa.com
Thu Apr 1 11:34:54 CST 2004
Script the entire database and look for the table name. Show Dependencies may not show it for different reasons. Robert Djabarov SQL Server & UDB Sr. SQL Server Administrator Phone: (210) 913-3148 Pager: (210) 753-3148 9800 Fredericksburg Rd. San Antonio, TX 78288 www.usaa.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Thursday, April 01, 2004 11:29 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: RE: Re: [dba-SQLServer] Web Assistant thats what I thought but I can't see a trigger for that table in my database, where would it be ? Message date : Apr 01 2004, 06:11 PM >From : "Djabarov, Robert" To : dba-sqlserver at databaseadvisors.com Copy to : Subject : RE: Re: [dba-SQLServer] Web Assistant You have an UPDATE trigger on that table. Robert Djabarov SQL Server & UDB Sr. SQL Server Administrator Phone: (210) 913-3148 Pager: (210) 753-3148 9800 Fredericksburg Rd. San Antonio, TX 78288 www.usaa.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Thursday, April 01, 2004 11:03 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: Re: [dba-SQLServer] Web Assistant it errors from a vb6 front end when trying to update the record.... Message date : Apr 01 2004, 05:00 PM >From : "Francisco H Tapia" To : dba-sqlserver at databaseadvisors.com Copy to : Subject : Re: [dba-SQLServer] Web Assistant Never having used web assistant I do no know all the things it does do... so My question for you is... when does this error occur?, what task were you doing, do all you users see this error? paul.hartland at fsmail.net said the following on 4/1/2004 7:42 AM: >To all, > >A couple of weeks ago I decided to use the Web Assistant to create a simple web page when the data in tblPersonnel was updated (just to test it out)?.. > >When you use this it create?s a stored procedure?..I have since deleted the stored procedure and my web assistant jobs and now I get the error message on my application as follows: > > Run time error ?-2147217900 (80040e14)?: > SQl web assistant : web task not found. Verify the name of the task for possible errors. > >Anyone any idea how I can rectify this??.PLEASE > > -- -Francisco _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month www.freeserve.com/anytime _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month www.freeserve.com/anytime _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com