I did have Management Studio running at the same time, so I will close that and try it. I will also check the memory. There isn't actually much running on...

You can easily find this information by using SQL Server Management Studio (SSMS). Go to Databases/{the data you need info about} Click the database name and right click for the...

I saw this response posted somewhere to a similar issue:

Thank you for contacting Microsoft Press.

Please make sure you are downloading the correct AdventureWorks database for SQL Server 2005. The CodePlex...

Try the Setting Up Windows Service Accounts topic in Books On-line.

For instance, it says to use Database Engine Tuning Advisor, on first use a user with system administrator privileges...

When we went from 2000 to 2005 we created scripts of the jobs and ran the scripts to re-create the jobs on the new 2005 server. If you create scripts...

In one of my databases, I do something similar to what David mentioned: I have a facility table that has a date_added column, a date_updated column, and added_by_manager and updated_by_manager...

When I run the Wizard I only see checkboxes for the following:

Check DB Integrity, Shrink DB, Reorganize Index, Rebuild Index, Update Stats, Clean Up History, Execute SQL Server Agent Job,...

The version # is Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07. I didn't restart after applying it because it gave me the option to shut...

Thanks - I checked and the property was already set to Multiple.

Nevermind - I just realized I don't see the Deadlock graph because I'm using the 2005 tools to access a 2000 server. We've put 2005 on development but not production!

Mike, you're right - that worked for me too. Thanks for the the workaround. We shouldn't have to do this tho!

Got it - thanks

You could convert the TSQL statement into a stored procedure with an input parameter, and then call the stored procecure from the DTS task. 

For example: execute pr_editmanager ?

We have a web application originally done in ColdFusion 5 with fusebox, with a SQL Server 2000 SP3 database on NT, edited now with Dreamweaver. One of our ColdFusion developers is working on...

I just read this from the Microsoft SQL Server page about how to buy licenses

"Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a free, redistributable version of SQL Server...