thank you. now I have a clear idea. I know sql server can have one default instances and more than one named instance but I had the idea that as...

so on both installation I would have to create named instances - servername\sql2008named_Instance and servername\sql2012_namedInstance and I cannot have a default instance on any of them?

thank you again but i got the user db name. i used ORIGINAL_DB_NAME() and it returned me the user database name in the db column.

hi again ,

is there any way to get the user database name in the db_name column instead of "master"?

thanks

thank you for all the help. i am getting the data in the table now but as you said it still shows the db name as "master" and not the...

changing the insert statement in the trigger worked but why in the SYSTEM_USER column and the DB_NAME column I see only sa and master respectively.

i clicked options and changed the...

i got the same error message after creating the revised trigger

the sql server error log shows the same error even after creating the revised trigger.

but if i create the Audit table in the master database and then it works fine....

I changed the trigger but got the same login error when I tried to log in and the SQL Server error log also has the same error.

but I found out...

sorry for not making myself clear but that is what I saw in the SQL Server error log.

Logon failed for login <login name> due to trigger execution. [CLIENT: <local machine>]

Error:...

the error message:

"login failed for login <login name> due to trigger execution."

if I change the trigger (see below) then also I get the login failed error.

create trigger [LoginAudit]

on all server...

you mean use impersonation on that trigger?

this is the schema and this table is created I the user database

[SPID] [int] NULL,

[LoginName] [varchar](512) NULL,

[HostName] [varchar](512) NULL,

[HostID] [int] NULL,

[LoginTime] [datetime] NULL,

[ApplicationName] [varchar](512) NULL,

[DatabaseName] [varchar] (10)

which login should...

yes thru PerfMon we can get "Disk Bytes/Sec", "Disk Write Bytes/Sec" and "Disk Read Bytes/Sec" and we do have just one database on that server but PerfMon will give us...

thank you Jeff. that will be a good idea. will dump the records in a table