[dba-SQLServer] trigger help

Thanks

Just checking for email

Of now. Let me know if it works. Will have a look tomorrow anyway

Martin



-----Original Message-----
    From: "Susan Harkins"<harkinsss at bellsouth.net>
    Sent: 1/14/06 7:33:25 PM
    To: "dba-sqlserver at databaseadvisors.com"<dba-sqlserver at databaseadvisors.com>
    Subject: Re: [dba-SQLServer] trigger help
    
    HAPPY BIRTHDAY!!!!!!! 
    
    Why are you on the computer????? :) This may be an Express problem, but I
    wanted to check first. I do remember having this problem with SQL Server 200
    in the Query Analyzer -- but I don't remember how I eventually resolved it.
    The problem may not have been the temp table at all -- I just don't
    remember. 
    
    The problem is that I can't create the trigger. 
    
    I'm going to create a temp inserted table and see if that keeps MS from
    throwing this particular error -- if it does, as David suggested -- it's a
    workaround. I just want to make sure it's necessary and not some silly
    mistake or assumption I'm making. 
    
    Susan H. 
    
    
    The table exists within the life time of the trigger. 
    
    Try it using query analyser and see if it works. Its my birthday party now
    so if it dosnt work give me a shout and I will check in the morning.
    
    U sure this isn't  an sql express issue not a trigger issue?
    
    
    _______________________________________________
    dba-SQLServer mailing list
    dba-SQLServer at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
    http://www.databaseadvisors.com