yes i understand there is DBCC INPUTBUFFER(spid) and fn_get_sql but both has some limitations like 256 char for imput buffer and fn_get_sql will not return if it is not exist...

Adam

I am trying the same but getting hard time to change the single quotees i have in the trigger while wrapping double EXEC

still same problem

I am still getting the erorr , may be i cant use this in a single query batch

USE DB1;ALTER TRIGGER.......

USE DB2;ALTER TRIGGER.......

USE DB3;ALTER TRIGGER.......

USE DB4;ALTER TRIGGER.......

'ALTER TRIGGER' must be the...

I dont think we can create trigger ON DATABASE for DML acitivities by using event class.

I thought i have mentioned that before, anyways it has to deny for every one except 2 windows groups.

is there a way i cna create a trigger in model database so that it fires when ever a table is create with a name like "secure%" and the functionality...

I want to do that in the model database so that it would take effect into all databases created.

I can do that same DENY on model because tables are created...

I am doing the same right now but i would like to automate the process so that every database newly created gets this effected and the imp thing is the...

Also what would be the benefits of 64 bit over 32 bit for sql server?

NO i havent but still the error, i thi it probably because of the " USE database"

I get this error

I dont think i could create the above trigger either using dynamic sql (sp_executesql) or sp_msforeachdb, any help ?

If i am creating a trigger for each database, is it possbile to create the same trigger which also includes

prohibit following permissions

DROP TABLE,ALTER TABLE,INSERT,UPDATE,DELETE.

if so how woould i do...

Hmm thats a pain if i have to add trigger to every database there are more than 400 db's. any trick?