You can get the full DTS Designer environment in SQL 2005.  This allows you to create new DTS packages on SQL 2005, and keep them in MSDB.

Download the DTS Designer...

You can do everything tha SAC does for SQL Server database services using sp_configure.  Check with BOL for the required syntax.

"Also, remember you can change from 8.0 to 9.0, but you cannot change from 9.0 to 8.0." add "if you have enabled any features new to SQL 2005" .... d'oh!

Ultimately the question of putting Test and Production come down to the value of the application to the business.  The Infrastructure guys should have very little say in what is...

The decision to connect with Named Pipes or TCP is always made by the client.

For short network pathways, there is not much performance difference either way.  If your clients have a...

You are updating the database Schema(s), so you will need a schema update lock.  This is another way of saying changing compatibility mode on a database can only be done...

I have seen people report issues with very large IN lists that were fixed by explicitly loading the IN list data into a table and doing a join.   I cannot remember...

If you are looking at SQL memory use with Windows Task Manager, remember that Task Manager cannot report on any use above the 4GB line.  SQL may be using 6GB...

Log on with the SQL service account.  Check the following:

1) Can you start Outlook manually

2) Check the mail account.  Everything should be stored in the Exchange mailbox.  If you are...

A long time ago since I did this in SQL7...  I seem to recall that the account name is fixed, and must be CMDEXEC (or whatever).  BOL should have the...

No, the problem remains.  Feel free to raise it with Microsoft if you want.  IMHO SAC is one of the least reliable of the SQL 2005 tools, and I try...

There are various levels of both Technet and MSDN, with different prices.  Technet Plus gives you all MS operating systems and Office software.  MSDN gives you the application development tools,...

If you copy the install media to disk into the same folder, make sure you copy the Tools CD first, followed by the Server CD.  If you copy in the...

You should treat SQL as a means of obtaining data, and treat the VB (or other) application code as a means to format it as you require.

Although you can use...

First, Simple recovery mode in SQL 2000 does not reduce the amount of information logged in any way compared to Full recovery mode.  What Simple mode does is allow that...