calling SQL Server trigger from ASP page

Hi all,

I'm real fresh with ASP, so please bear with me.
I have a trigger in SQL Server, which specifies how the records will be inserted into multiple tables.
I also have an ASP page that allows the user to select a table/view/etc to insert into.

In my asp code, do I exlicitely call the trigger, or do I just specify the insert statement, since the trigger is on the server already?
In other wordd, can I just insert without mentioning the trigger at all in my ASP code?

Thanks

>> In other wordd, can I just insert without mentioning the trigger at all in my ASP code?

Yes, that's how triggers work. A trigger will automatically fire off whenever the event that it is set up for occurs, so you DON'T explicitly have to call the trigger. It doesn't matter if you insert using ASP code, query analyser or whatever, the trigger will automatically work when the insert happens.

Scorpions4ever, thanks for the responce.

The reason I'm asking is that it DOESN'T do that from the ASP page, but works fine in Query Analizer.

Little background: I'm using INSTEAD OF trigger to insert into multiple tables from the view. Works like a charm in QA as long as you set IDENTITY_INSERT to ON if you got identity fields in your tables.

When I try to insert from asp page (I'm testing "1 Click DBPro" pre-made asp package), it comes back with:
"can not inseart into multiple tables, blah blah"

But the trigger is there

BTW, i love Maiden, they played here 2 years ago and kicked butt.

>> When I try to insert from asp page (I'm testing "1 Click DBPro" pre-made asp package), it comes back with:
"can not inseart into multiple tables, blah blah"

Maybe the 1 Click DBPro login doesn't have permissions to insert into the tables that your trigger is trying to work on. Are you using a different login, when you're using Query Analyser?

>> BTW, i love Maiden, they played here 2 years ago and kicked butt.
I'm going to see them again in Long Beach Arena, August 24th

>>Maybe the 1 Click DBPro login doesn't have permissions to insert into the tables that your trigger is trying to work on. Are you using a different login, when you're using Query Analyser?

Good point, I checked and I'm ok. 1 Click DBPro allows me to insert into one table at a time, but not into multiple tables.

I actually don't know of any other way to insert into multiple tables other than with Instead Of trigger. If anyone out there has any ideas please let me know.

Use a stored procedure perhaps?

you mean rap the trigger in a stored procedure?
If so, do I have to call that stored procedure from the ASP code?

Or do you mean create SP for inserting values, and call it from asp code?