When trying to troubleshoot DTS problems this is one of the problems you can run into.  To try and find out exactly what DTSStep_DTSExecuteSQLTask_6 is and what it is doing...

You can change the type back to system from user by using an undocumented procedure called sp_MS_ marksystemobject. Permissions will then default to members of the sysadmin server role, the...

Pretty sure you cannot do this.  You cannot even restore a version of the master database to a different service pack of the same version.  Presumably if you are simply upgrading from...

One thing you may want to look at is if there are any hypothetical indexes.  These are created when the database tuning wizard runs and can sometimes end up being left...

When I move DTS packages I save them as a Structured Strorage File(.dts).  Then from the other machine that I want to open them on I right click Data Transformation...

When I need to shrink the database I always do it on a file basis first.  This way the data is compacted before the database is shrunk.  The code I...

Off the top of my head, this would probably work:

CONVERT(TEXT,REPLACE(fieldname,'0',''))

FROM tablename

I am using the SQL Server 2005 CTP and it has some nice new TSQL features like PIVOT and UNPIVOT which take care of this very nicely.  However, I have...

  I used to use a number of queries against the system tables to derive this information but I found a link on this site to a very nice...

When choosing the installation type you can choose advanced and the select the option to create a recorded Unattended Intsall File .iss.  I have not actualy tried this before but...

I have had the same problem recently with one of our servers.  I tried stopping the SQL Services and agent seperatly but that did not fix the problem.  We ended...

The only time I have ever experienced a lock timeout while browsing surrent activity it ended up being a situation where tempdb had expereiced exxcessive locking.  You may want to...

Just like this:

UPDATE tablename

SET columnname = (SELECT columnname FROM tablename WHERE ?????)

WHERE ?????

Not sure if this is what you are looking for but, you can adjust the timeout for Login Time out and Query time out.  You do this by Clicking Microsoft...

You can do this by executing the stored procedure sp_changedbowner '?'.  Just replace the ? with the new owner you would like to assign.