hi Lowell,

Thanks for the script. Just need help to filter on the columns"

Only columns I wants are:

Date

Object Name

DatabaseName

Starttime

ServerName

User_name

ApplicationName

DDL operation

Can you please post updated script?

Jack, you said "Another way to explain it that the included columns should be columns that you don't search on, but will return" , I got it, thanks for that....

IN GENERAL, Since 0 users seek,high users_lookups and high users_update, should PK be removed?

Thanks for the reply one more thing, can you join sys.objects on your original script?

Hi Lowell,

in the result header there are 2 columns 'date' and 'Start_time' what are these can you put specific column name? plus if I want to filter by date like...

First of all thanks guys for your replies. I think I need to be more clear. just say, out of the blue I found A log file (.trn) is...

my question is, looking at the log file size at certain time, how to find what occurred that time such as insert, delete, ope tran etc... is that any way...

Thanks Alexander and Lynn. One more question, which option is better? if option 2 is better then why not add firstName and Middlename in Include?

Cool. Thanks SoHelpMeCodd!!!!

Thanks Alexander and SoHelpmeCodd for taking time to reply. My question was if I have 7 databases on my instance but i just want to setup job for 'Database1' and...

Thanks Lowell.

@Grant. I had posted my questions, I am not looking for Powershell script.

Server 'Myserver', 'default instance' with 'window Authentication'. I want below queries to execute on CMD.

1....

Wow. Just asked simple questions, no answer but too much noise!!!!

Just some questions, with different scenario. Would appreciate if you post answer

Cool!!! After I changed to 'TextData VARCHAR(8000)' it worked. Thanks smart people.

doesn't tell me that, I posted the error