Post reply

Need Help with a Question

  • August 9, 2011 at 12:47 pm

    #245943

    Does anyone know,

    What are the system tables accessible from DML triggers? Describe them?

  • August 9, 2011 at 12:51 pm

    #1366171

    What did google turn up?

    This sounds like an interview / exam question.

    What did your research find out, where are you getting stuck and where do you need o go with this?

  • August 9, 2011 at 12:55 pm

    #1366176

    I can't anything on google about this.

  • August 9, 2011 at 12:56 pm

    #1366178

    Weird!

    http://msdn.microsoft.com/en-us/library/ms189799.aspx

  • August 9, 2011 at 12:59 pm

    #1366181

    I did went to this link but I doesnot tell the system tables accessible for DML trigger. does it ? if it is then where

  • August 9, 2011 at 12:59 pm

    #1366183

    All the system tables are visible from triggers. And everywhere else.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 9, 2011 at 1:01 pm

    #1366188

    All of them... http://technet.microsoft.com/en-us/library/ms179932.aspx

    Are you reffering to the inserted and deleted tables only available in the triggers?

  • August 9, 2011 at 1:09 pm

    #1366195

    I am referring to system tables accessible from DML triggers. please name them.

  • August 9, 2011 at 1:11 pm

    #1366198

    suhailtajraja (8/9/2011)

    I am referring to system tables accessible from DML triggers. please name them.

    ALL OF THEM.

    Check the link I posted, they are all listed there.

    You might get more usefull help by describing the task you need to complete.

  • August 9, 2011 at 1:13 pm

    #1366199

    suhailtajraja (8/9/2011)

    I am referring to system tables accessible from DML triggers. please name them.

    All of the system tables (well, they're system views these days) are visible from everywhere, ad-hoc queries, procedures, functions and triggers,

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 9, 2011 at 1:14 pm

    #1366200

    Ninja's_RGR'us (8/9/2011)

    You might get more usefull help by describing the task you need to complete.

    Homework, exam or interview.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 9, 2011 at 1:16 pm

    #1366203

    Ninja's_RGR'us (8/9/2011)

    What did google turn up?

    This sounds like an interview / exam question.

    What did your research find out, where are you getting stuck and where do you need o go with this?

    😀

  • August 9, 2011 at 1:18 pm

    #1366205

    suhailtajraja (8/9/2011)

    I am referring to system tables accessible from DML triggers. please name them.

    SELECT * FROM sys.objects WHERE type='S'

    Execute this on a any database you are reffering to gives the list of system tables.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • August 9, 2011 at 1:20 pm

    #1366209

    interview

  • August 9, 2011 at 1:21 pm

    #1366211

    @SQLFRNDZ (8/9/2011)

    suhailtajraja (8/9/2011)

    I am referring to system tables accessible from DML triggers. please name them.

    SELECT * FROM sys.objects WHERE type='S'

    Execute this on a any database you are reffering to gives the list of system tables.

    However those are not visible from anywhere,

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply