Great - sorry about not mentioning the parantheses earlier...that's the first thing I should've noticed...

at any rate...better late than never

RCoston - one more thing - enclose your exec @sproc_call within paranthesis..like so...

exec (@sproc_call)

sorry if i'm stating the obvious but are you sure the spelling of your stored procedure is correct ?!?!

have you double-checked in your sysobjects table in the database to...

farrell - if what i posted doesn't work and you want to take a stab at this, i'm posting the insert statements per the sample rows that salvatore sent so...

salvatore - I have reached an impasse with this query....in the sample set provided -

a) barring one aspect_id which is common between acw_score and compliance_with_id tables, I don't see...

OMG rg - where did you learn to speak "American" ?!?!

raj - you didn't delete one of the system tables, did you ?!

I just "experimented" by deleting a user table directly in sysobjects and it worked just fine!

as remi said...

could you pl. post the select statement that you're using ?!?! thx!

this could just be a syntax error - i ran this through the parser and changed it to:

declare @p1 int, @p2 int, @server varchar(16), @dB varchar(16), @sproc_call varchar(2000), @cust_code...

remi - not sure why you changed it to "FROM Inserted"...

shouldn't it still be...

CREATE TRIGGER trgInsertIntoNewTable
ON test2
FOR DELETE
AS

Insert INTO dbo.test3 (columns list) Select ColumnsList FROM Deleted

GO

smruti - I have...

this link is specifically for homebrew01 (you don't actually have a "still" by your shed in the backyard do you..

backup files can...

"I learnt here by reading answers."...

each to his own rg - i learn more by trying out solutions for myself before posting them than by just reading answers..that way my...

"Really, Remi, you are too fast..."

thinking out aloud..."maybe we should all gang up against remi and ban him from this site - or at least a couple of the forums...

erik - what user account did you set up in the securities tab ?!

here's what i have from one of my sql bibles...

"if you took the default path and...

nice timing erik...did the other post with (what seemed to be) an identical issue not help at all ?!