.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> VB.Net >> Post New QuestionBookmark and Share Subscribe to Forum

how to use trigger in bulk insert

Posted By: Santosh     Posted Date: March 17, 2011    Points:5   Category :VB.Net
Hi Friends,
plz anyboby help me on this.....

i am inserting the records in a table using bulk insert and i want to insert the same records in another table using trigger.
my trigger is working if i m inserting records in backend but it's not working through bulk insert.
even i tried to fire trigger front end(in vb.net) also same result .

how can i fire trigger in bulk insert...........


Regards
Santosh




Responses
Author: Mahesh             
Posted Date: March 17, 2011     Points: 20   

on bulk insert, you cannot have a trigger raised.
Firing triggers using Bulk insert:

Using bcp
-h "FIRE_TRIGGERS"
Using T-SQL
BULK INSERT .... WITH (FIRE_TRIGGERS)

For DTS Data Pump Tasks click off Fast Load check box.
For more information:http://msdn.microsoft.com/en-us/library/ms187640.aspx

Author: Santosh             
Posted Date: March 18, 2011     Points: 20   

hi mahesh

can u plz give me a example on this.....

Regards
Santosh

Author: Mahesh             
Posted Date: March 18, 2011     Points: 20   

Hi

u can check the link below as example

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22666342.html

Thanks,
Mahesh



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend