Maintenance plans execute DBCC commands including DBCC CHECKDB to check database integrity and DBCC SHRINKDATABASE to shrink the database files and free up space.  As far as I know, they...

Either arrange the steps in the package to load the tables in order i.e. parent tables then child tables, or create drop and create scripts for the foreign keys and...

Are you using DBCC CHECKDB?  It doesn't require the database to be in single user mode because it used schema locks on tables rather than shared locks.

Greg

Please don't cross-post.  Your post in the DTS forum, http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=340467,  is in the correct location.

I've found this type of DTS error message to be pretty accurate, so my only advice is to check your destination connection and make sure you're transferring to the database...

Move packages stored in Meta Data Services to SQL Server storage or to structured storage files.

Download SQL 2000 DTS Designer components from http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

It's widely recommended to run SQL Server...

FYI: There is a maximum capacity spec page in the RTM BOL.  Keep in mind that Steve's article was published in October 2004.

Greg

Use a UNC filepath in the source connection e.g. \\server\folder\file rather than a mapped drive.

Greg

SQL Server gets it's time from the OS, so there's no patch for SQL Server.

See these threads:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=332998

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=331667

Greg

I wasn't really suggesting having a database user mapped to two logins.  In fact, that's impossible.  We actually drop the old login and all of it's associated database users before...

The funny thing is, the query works even when the string I'm searching for is in the 5th row in syscomments.

Greg

I grew up in a small town in Washington and have never lived more than 25 miles from it except during college.  I agree with Stephanie Brown in that I...

I wonder if DTSRun.exe was restored to a different location.  This KB article describes the error: http://support.microsoft.com/kb/322746/en-us

Greg

Here's a simple script we use that does two joins to syscomments to search stored procedure text that spans two rows:

Greg

select distinct so.name from  sysobjects so

 join syscomments sc...

We're also migrating to a new domain one person at a time.  We've found that you can add a login to SQL Server for the Windows group in the new...