Have you looked at the logs? Do they have any more information? If you haven't looked, have a look at the job history (right-click the job under SQL...

In Query Analyzer/SQL Management Studio you can output the results directly to a file (Query menu).

You could use a cursor and while loop as in the following example to avoid the extra table you have with the list of table names in it:

use...

Where's the query?

Sounds like you didn't select the Maintenance Cleanup Task when using the wizard. This task will delete the files of the disk after a specified amount of time. ...

Some errors immediately get passed out of the code block to the calling procedure/application (they don't get caught by the catch at the same level as the code block). ...

We had no problems on a cluster with using mount points but we found monitoring disk space was a problem. We have a drive letter for a small disk...

You can try cast. This example will transform a varchar to an int:

create view text_vw (itm, sile, eqty)

as ...

Books Online for SQL 2000 has an example script in it under DBCC SHOWCONTIG, but it does an indexdefrag based on a parameter for the logical fragmentation. It should...

or you could have done the following:

1. ALTER DATABASE SET OFFLINE;

2. Move/copy the database file to the new location

3. ALTER DATABASE ');

4. ALTER DATABASE SET...

Have a look at http://www.microsoft.com/sql/downloads/trial-software.mspx#EIB

You can download a trial version of SQL Server which will run on XP or some of the books come with it on CD.

Personally, I prefer the study...

Only thing to think about is that SQL Server in the Cluster may not be able to see all the disks that are in the server - it can only...