It says "RECOVERY" but i would like to know how much it recovered already

Also i am not getting the original user name, I am getting my own id who ever logs in under "sUserName".

and since all our users connect to sql server directly...

It is working fine for me in 2005 also but how can i filter this code so that i get email only when the user is connected through "ApplicationName Microsoft...

the link is not the problem because i might missed while writing in the forum. now its corrected.

yes, i can and i see activity "create database" for this attach database but it is not blocking anything

attaching the db is still runing from the past 3 hrs and is locking every one that server, i can t even open any database from the SSMS?

After creating the trigger as you gave, i coulnd not connect to the instance, the trigger is kicking out any login to access the server.

I am getting the error...

I am doing this but i am sure this is not sufficiant.. Let me know.

GRANT VIEW SERVER STATE TO EctApp;

GO

CREATE TRIGGER connection_info_trigger

ON ALL SERVER WITH EXECUTE AS 'EctApp'

FOR LOGON

AS

BEGIN

IF ORIGINAL_LOGIN()=...

yesi have database mail ready and tried to use the same code from the above link provided.

I created logon trigger but it not allowing the user to logon which i dont want,I want to allow them to logon and may be email me who logged on...

I think "xp_restore_verifyonly" will work only in sql 2005 but not in sql 2008, it should be something different, right?

I would like to explain the problem in another way..

Lets say the account(windows) i am using which is in problem is "OBBEAVER\SQLBAY2" and sql agent service run with this ...

yes, SQl Server, Agent and all other sql related services use the same windows account which is a sysadmin.

Looks like the problem is only when i run the job but...

does this mean

applies to only employee_2 table but not for all the union results.