You might take a look at log shipping.

FYI, Books On-Line is your friend. You will find many of your answers thee.

If you need to work with this database on your computer you may want to consider spending $50.00 (USD) and buying the Developer Edition of SQL Server.

You indicated in your original post (I belieive) that you are using SQL Server Express? I don't think you will be able to access the database. The Express...

First, your data provided does not match the diagram.

Here is some code to play with:

create table dbo.bom (item_id int, item_name varchar(15), qty int, parent varchar(10),parent_id int, has_child int, primary key(item_id));

insert...

I really expected that you'd have data for this year and last year as well. You do want to be able to compute the YTD and Previous YTD Sales...

As i get started at looking at this, I just want to confirm you are using SQL Server 2000, not SQL Server 2005. I don't want to use any...

Florian Reischl (5/18/2009)

No problem :-). Take the time you need or give me a short hint...

Simple answer. Yes.

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2...

The only other change I would make to Option #3 is to make the EndPeriod an "open end" on the range. Example:

StartPeriod ...

Could you provide the code (stored proc and function), table DDL (target table for the stored proc and the UDF)?

There may be a better way, but we'd need to see...

The reindex operation is a fully logged operation, that is why it writes to the transaction log. If you...

Check out Books On-Line (BOL). You want the REPLACE() function.

Need more information. What versions of SQL Server are being run on the two servers and what is the database compatibility modes on the databases in question?

Try...