Thank you so much !!!

Thank you.

thanks for the tips

Yeah I know, I already changed it but i was trying to see the history which has been discarded. Thanks for your answers anyways.

I want to execute it, I dont want to get the statement itself. Thanks for your response

What I am trying to do is;

If my class_desc returns OBJECT_OR_COLUMN, I want to get the grant statement which works. However if class_desc returns DATABASE_ROLE then i want to execute...

Then how im suppose to see the open transactions ? do you have any useful sql scripts that can help me out in order to find out what my problem...

as far as i know if sys dm exec requests returns nothing there is no open transactionn. isn't it ?

This is the sql that how i query blocking sessions

SELECT blocking.session_id AS blocking_session_id ,

blocked.session_id AS blocked_session_id ,

...

Since there is no open transaction it should've been committed.

I was gonna post something about system tables updates then somehow i end up asking the same question. my bad. I will consider your warning next time

Hi Perry I want to do this:

in SQL Server 2012, i can make audit filter for sa user. However i can't do it in sqlserver 2008 I want to audit...

Hi Koen, the reason why i want to do...

DBCC LOGINFO and you will see your last virtual log status is 2. I guess you need to make it 0 and then shrink....

Hi,

Yes they come in under different accounts and it is easy to differentiate if you do SERVER AUDIT since they have different login accounts under instance. However, it is not...