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...

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

DECLARE C_sql CURSOR FOR

SELECT '' AS [-- Notes --],
2 AS [-- print output --]

UNION
SELECT '--...