All makes sense John. Thanks

Just some more background. I am a one man test in our company. I am a business user who has B- technical skills through some training...

All good stuff here. Again, i'm the dba-wanna-be.

So as i start to learn and see that every index and key is completely fragmented, i am doing defrag. My database before...

I knew i could count on you smart people!!!! 🙂

A few follow ups---

What is the best way to view fragmentation? Is it sys.dm_db_index_physical_stats??

If it is, what is the key indicator...

thank you Matt

i will do that and let you know how i make out.

That did the trick my friend.

I owe u a beer!!!!!

😀

tyvm

Peter

AN update on my problem.

The script also has not worked. I am going through an exercise today to archive some data out of the database to free up disk...

I miss-typed my problem. the second part should read it returns to restricted growth.

Thanks again everyone for the input.

Keep it coming!!!!!!!!

Thanks Mike

The little bit i found on the web was problems with .adp's and SQL2005. But i have yet to find an exact comment on what the problem is. There...

in the db i want the data, i right click, tasks, import data, then enter the approprite data in the import/export wizard