Susan Harkins
ssharkins at bellsouth.net
Mon Jul 11 20:00:53 CDT 2005
Michael -- that's pretty cool. Thanks! Susan H. Susan, I think Arthur got it slightly wrong. '#' denotes a temp table. Just use inserted/deleted. BTW you can use QA to debug triggers by creating an sp that will trigger the trigger and when you debug the sp it will step into the trigger... HTH cheers Michael M What version are you using Arthur? I'm using 2000 and inserted works, #inserted does not. Susan H. It is #Inserted not #Insert. _______________________________________________ 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