thanx frank and satya.........for giving the links<br /><br />hi databaseanswers.org and the case study in<a target="_blank" href=http://www.developer.com/db/article.php/3526161>http://www.developer.com/db/article.php/3526161</a><br />r too good...<br /><br />i am rookie in this DBA world....<br />i just had my training in sql server 2000 ....currently i have no work in my organization..[<img src='/community/emoticons/emotion-6.gif' alt='' />]....may be i am in live project next month ...that's why i want to utilize this oppurtunity to apply my concepts that i have learnt in training ....that's why i asked for case studies...[<img src='/community/emoticons/emotion-1.gif' alt='' />]...<br /><br />u people help me a lot........this forum is too good as there r lot of real-time problems and issues r present...<br /><br /><br />thanx once again.....<br /><br />krishna chaitanya.s<br />project engineer-SQLDBA<br /><br /><br />

True and glad to know our help is useful [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br />Sometimes you may not find all the case studies are useful for your training and by all means you can develop your own project as a case study within your perimeter for more experience.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided â€œAS ISâ€ with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>