I am getting the list of all the table with above query.

I basically want to know the list of new table created in last 5 days as compare to table...

Thanks it worked for me

Thanks once again

Thanks just want to make sure what if index is created in a file group can we restore that only?

Thanks I will check all the option you mentioned

Thanks it got clear

My requirement to keep track of how many logins we have in total in entire server, so I want to get any distinct Login name with othew column.

basically I am trying to get only one Login for each person not matter how many host or CMD he has connected

I am not getting Distinct Loginame with the solution you provided.

THis is also including Log space as well, can we just get the sum of data file only?? and Log as seperate

This is the code is working for Single Database, I want this for Multiple DB

DECLARE
  @note VARCHAR(2048)
  ,@id INT
    ,@command varchar(2000)

DECLARE...