Thank you.  Unable to put the db in single-user mode now; I have to try it this weekend.

How?  DBCC DBREINDEX is not supported for use on system tables.

What about a repair index -- can this be done on the fly for the master db?

info from checkdb (master):

Server: Msg 2534, Level 16, State 1, Line 1

Table error: Page...

Sounded good, but did not work....

All of the db are on the same server, as is the package itself. 

All tasks are already running in serial.

How do I find out about quotas?

Not using Lookups, and have the latest SP4.

C drive has 8 GB free.

The maximum number of records before each commit is only 33 rows.

Nope -- tempdb and other two db involved are all unrestricted filegrowth.

I had a similar problem awhile ago.  The only way that I could find to overcome it was to disable Named Pipes, and only use TCP/IP. 

I'm having the same problem during the optimization step of one on the db on a server.  The server has 300 GB free space and nothing else is running at...

Thanks, but this didn't help much.  I have MDAC 2.8 sp1 and am using TCP/IP, and this was not quite the error I got.  I think it was originally caused...

I found it because I was looking at some new SharePoint db that just came to me, and I noticed that they were using SQL Server's full-text searching capabilities.  I was trying...

Thank you. 

The warning is on the Microsoft site: http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stse08.mspx

Jill

Any information that I can get helps.

Thanks,

Jill

I used the file copy method listed on the link earlier.  Somewhat to my surprise, it worked almost without a hitch -- I only had to fix a few (but not most) logins...

There is a script by Joseph Gama which should help you:

http://www.sqlservercentral.com/columnists/jgama/sqlserverpasswordauditing.asp