Triggers and Auto serial number in sqlserver

-------------------TRIGGER CONCEPTS-----------------------



create trigger Prevent1(Trigger name)
on database
for Create_Table
as
Print 'U cant create the table'
rollback

-----For Enabling Creating Table
disable trigger Prevent1 On database


---------For Disabling Creating Table

enable trigger Prevent1 On database



----------------------------Using Trigger U can stop creating Prodedures also




------------------------Automatic Generaion Number Using query in a table
select row_number() over(order by column_name1) as SR ,* from table_name