T-SQL - SQL statement type

• kmc_senthil_452

  Grasshopper

  Points: 10

  More actions

  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

• x002548

  SSC Enthusiast

  Points: 112

  More actions

  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

  😎

• kmc_senthil_452

  Grasshopper

  Points: 10

  More actions

  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