Michael Maddison
michael at ddisolutions.com.au
Mon Jul 11 19:23:55 CDT 2005
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