Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. singularity

    trigger failing

    1) How can i detect (record) when a trigger fails? 2) Is there a time-out period for triggers? And if a SQL-statement in a trigger times out, will the entire trigger be rolled back?
  2. singularity

    Help on triggers

    I need some input on this. I have an INSERT-trigger on an order table, but sometimes a record will be lost. I suspect that this is caused by the trigger causing an error, thereby rolling back the entire INSERT. But I can not find anything wrong with the SQL-code, and the values used in the...
  3. singularity

    store procedure naming

    If u use the sp prefix, SQL Server will first look for the stored procedure in the master database instead of the current one when it is executed. Obviously, this which wastes time.
  4. singularity

    Triggers

    Simple question: If a trigger fails, ie causes an error, will the INSERT statement that fired it be rolled back?
  5. singularity

    distribution of files

    I need to distribute a file (specifically: normal.dot in Word) to a specific directory on every computer in a network from a server. I'm thinking a small app or vb-script, but have no idea how to begin. Any suggestions?

Part and Inventory Search

Back
Top