That works great Greg.

Jorge, I end up using your approach. Thanks guys.

The sp_helptrigger report all triggers irrespective of whether they are enabled or diabled. I would like to know if the trigger is enabled or disabled. Is there a way?

Thanks Greg and Clive.

BTW, a trigger can be disabled Clive. Here is the command:

alter table table_name disable trigger trigger_name

Thanks Andy and Brian. I will go with one trigger.

Ok, how do I create the database for my application.

1. Login in as SA or create new login, grant sysadmin,db_owner and create the databse using the new login?

2. If I...

I have other question with regard to the ownerships?

If I create a login A with sysadmin role, is it not equivalent to SA? If yes, then why not use SA...

Antares, even the begin/commit trans does not seem to work. Test the below code:

create table test(blah varchar(100))

begin tran one

declare @x varchar(10)

select @x = 'tran one'

print 'x:' + @x

begin tran two

insert...

I log certain information to table frequently through the whole process that should persist a rollback so that the end user can get a report on why the process failed...

Thanks Antares. This is good idea but I can't use a global temp table because other users will be waiting to access the same table and if I use a...

Thanks a lot Antare and Andy for your valuable inputs.

Are you all saying that I should only create objects with dbo as the owner? Pardon my ignore, i am only couple of days into sql server. I am planning...

Thanks Andy for the quick reply.

So is it a good practice to create all my application objects with dbo as the owner logged in as say, user A?