do you have DMV script which i can use with my linked servers

Thank you for reply John

i just want to know when these databases used last time so ill take their backup and detached them thats why i am using the index usage..

you think if...

hi Gianluca Sartori

The Script run perfectly and output looks great..

I just encounter one problem when i run the script, it gives this error on 5 of my servers and...

Thank you very much Gianluca Sartori...

you are a life saver ...

No i mean all the data in each table.column...

Here is the situation .. i migrated my database from old domain to new domain and it migrated successfully but the data...

No No!

not additional column ... there is a column name RPTBO_HTML column in the table, in the result it getting the same data as other database are but it...

its should not include the Application version in the result.. and its hard coded so its not like someone doing it when entering the data..

Hi Jason..

I haven't check the issue with try...catch block.. ill do that ...

Let me add one more thing in this... This procedure/script run through the 69 steps and from...

ok Let me do that and ill get back to you

Thank you

yes they are all similar steps in this job.

here is the steps. ( so 69 steps have the same code )

Insert into dbo.MU_New_bak select * from dbo.MU_New

go

Truncate...

yes its a single stored procedure.

well when i execute this procedure through query window it didnt give me error but when i run it through agent it gives error....