Perry Whittle (7/29/2013)

---

starting SQL Server 2008 there is an option available when using the -m parameter which sets the app name that is allowed to connect in single user mode.

This...

I have found without using SQLIO to really drill down into writes vs reads that generally RAID 10 will help with transactions log, but if there are equal or significant...

In order to do a disk level defrag you will need to be certain that no one is using the databases (in most cases) in order for the defrag to...

Thanks to all. That did the trick. I new I was missing something obvious.

As for our environment, these scripts are run manually from query analyzer, so I dynamic...

Jobs are not created automatically in SQL2000 or SQL2005 when creating a DTS Package. You will have to create a schedule in SQL2005 once the DTS Package is created.

I would definitely add the SQL2005 tools to your laptop. I believe you will then have the latest ODBC driver for SQL2005. Also, SQL2005, with a default install...

Thank you so much for the quick response.

Can I also only have 1 backup?

Thanks again!!!