Thank you Mike for the reply; yes it helps.

Jennifer

No, both our log files and data files reside on striped and mirrored Raid 10 sets (not the same ones though).

Thanks Mike for the reply. The database is a little over 3 GB in size with only 303 MB of data so your answer makes sense. I had just hoped it...

Thanks for the help Rich. I'll give that a try.

Jennifer

Thanks Greg for your response. As far as I know, the file path is UNC, but I'll check the package and see what the mapping is.

Jen

Thanks to all of you for the help. Both the web page idea and query to a table in the development database were great alternatives. I wasn't logged on this weekend, so I'm...

Thanks Steve. Both your answers have convinced me to move the dev database off to another instance.

Jen

Thanks for the help, especially on the log schedules. Right now I believe we're waiting on other hardware, and once that's in place, we'll be able to put more disks...

Thanks Newbie for your recommendations.

Jen

Thanks fhanlon and Andy for the additional information. Andy, what in your opinion, would be the optimal way to handle this? Using windows authentication and having only one connection to...

Thanks fhanlon and Andy for the additional information. Andy, what in your opinion, would be the optimal way to handle this? Using windows authentication and having only one connection to...

Thanks Steve for the response. I did a lot of reading since I posted this and your answer makes perfect sense. I'm having a difficult time convincing the developers of...

Thank you 5409045121009. I'll try that and post the results.

Jennifer

OK, I found out how to not get duplicate methods, but now I have another issue.

Here's the current query syntax:

select Number, Method, Application, Computer, MinSubDuration, MaxSubDuration, AvgSubDuration, SubEventCount, s.section as...

Thank you for all of your ideas and suggestions. Really appreciate the feedback.

Jennifer