Post reply

T-SQL - SQL statement type

  • December 21, 2004 at 8:27 am

    #60624

    Hi all,

    Through VB application i am executing t-sql statements for create/alter/drop database objects like table, procedure, function and view.

    i want to update the object type, transaction type in one table .  please help me how to find out the Transaction type (CREATE/ALTER/DROP ..)  and object type (VIEW/TABLE/PROC/FUNCTION ..)   of last executed statement from Sql Server or VB.

     

     

     

     

     

     

     

    Regards,
    S e n t h i l

  • December 21, 2004 at 11:06 am

    #534647

    You'd have to use profiler...or wait for 2005 when they have database level triggers.

    But why do you want to do this.

    I would think it wouldn't be a good idea to do dba worj through a VB Application.

     

     


    Brett

    😎

  • December 22, 2004 at 8:36 am

    #534775

    hi Brett,

    thanks for ur reply..

    i want  to update one table that have 3 columns. ( sql type , object type , object name)

    sql type - create / alter / drop

    object type - table / view / function / procedure

    object name - table/view/fucntion/proc name.

    Any possible way through sql server or from vb  please let me know.

     

     

     

     

     

    Regards,
    S e n t h i l

Viewing 3 posts - 1 through 2 (of 2 total)

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