Hi,

I have around 30 dbs i need to store the details in one table and to monitor?

its liek collecting information about Cpu usage,

could you suggest some queries

smm

Thanks,very helpfull

hi,there are around 20 dbs in this server,and all the databases recovery model is full.

only the one db we are getting following messages

Message

Error: 3041, Severity: 16, State: 1.

BACKUP failed to...

Thanks ,really helped this

hi,

Thanks ,this is great helpfull

Iam not having much exp on curson,could you please give a script

i have tried with both but select * from sys.databases

it is not giving details about size,

and the other one not giving all the db size details,we need to run...

HI chandru,

I posted one topic ,could you please help me

Thanks alot,Also I would need couple of details ,could you help me

---

This is what I needed,

1)Objects which do not belong to DBO

This is the query we are using to find...

hi,

Is there any method to find out

Database users which do not have DBO as their default schema.

Any query

Smm

Hi,

What i would need is i would like to know each databases,Which are the Objects(Tables,Stored Procedures Etc.)not belong to the schema DBO.

Fist i need to know which are the objects...

Hi,

Thanks ,is it possible to get the result in Excel,I am getting the result in .text format

Please help me

Hi,

I have not noted on Jan-07,Is there any where in system files it will be stored,

i can able to get the detail about the creation date,from the creation date to...

hi,

what i want to get the details of growth rate is from Jan -07 to Dec -07

is there any method to find out

Regards,

Shine

thanks alot buddies