so u mean to say that if i see the SPIDs repeating many times then it means that the process for that id has lot of connections..right...

got the solution..its easy..just right click on the report and you will have an option to save it in excel and pdf..thanks.

i did check that..it mostly talks about using performance dashboard rpt..i would like to know how to calcultae buffer cache hit ratio using dashboard and also to calculate pages/sec using...

thank you.

thank you.

i really dnt know how xyz is connecting...but her id is a windows ID and this the error msgs shes gtng when she is trying to login..Connection timeout...thank u so...

thank you so much Adi..i will try to ask her password and try using her login...i see that the login is mapped to that db ..my one more question was..how...

thank you..got this error

Msg 208, Level 16, State 1, Line 1

Invalid object name 'Tmp_DatabaseLog'

i rlly dnt know where is it gtng 'Tmp_DatabaseLog' from..ders no such table der..thx

THANK YOU for your reply..could you plz explain me in detail dat how wld i do dat...

thank you....and when i select the group the default db should only be the db which needs access instead of master right...

thank you for your reply...i did by right clicking on the table and den design ...i was trying to uncheck the allow nulls and it gave me an error..but i...

thank you.

found the answer on ms website...it does work...thx..any suggestions most welcomed.

http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx#sysreqs

thank you.

thank you..