Michael, Regarding the typo, that's what I get for writing the select statement on one system and typing it on another (didn't use cut and paste).

Thanks

I think it would help if you could post the DDL for the table and index.

Sounds like a permissions issue on the file or directory.  Is the S drive local or on a san?

Here is a rough outline:

1. Create an empty database with all requisit tables, call it reportdb_new.

2. Load reportdb_new.

3. If load successful:

     Drop all active connections to reportdb

     Rename reportdb to...

As this is posted under SQL Server 2005, you could also use SSIS and the filesystem task to move files around based on information in your database.

What version of SQL Server 2005 are you trying to install?

Or try this:

select dateadd(dd,datediff(dd,getdate()),0)

We are building a data warehouse where I work, and we are using schemas to identify the source systems in our staging environment.  Once the data actually moves to the...

Be sure you read the license agreement.  If I remember correctly, if you install Reporting Services on a machine other than the one where you installed SQL Server 2005, you...

I had my pattern and expression reversed.  Also note that I had to add a single quote to the sixth string due to the single quote in the company name:

create...

Worth a shot.  That was the only way we could get our DTS packages to run as scheduled jobs at my last company.

If I think of anything else, I add...

If you use Windows Server 2003 R2 as the host OS, you can use the same license for up to 4 Virtual Servers on the same box.  Not sure if...

Just for the heck of it, set the owner of the job to sa and see what happens.

Try replacing the variable @string with the column you are trying to split into 2 seperate columns.

There is a way, unfortunately, I can't remember how or where I saw it.  I will, during my free time, try and see if I can find it again and...