"Carlos Eduardo Rojas" <carloser@mindspring.com> wrote in message
news:OXT6EphBEHA.1732@TK2MSFTNGP12.phx.gbl...
> We have an OLTP database here with heavy reporting activity, and what we
do
> is that we have transactional replication configured from the production
> server to the reporting server. This also allows us to create different
> indexes on the reporting server to optimize reporting queries.
>
> --
> Carlos E. Rojas
> SQL Server MVP
> Co-Author SQL Server 2000 Programming by Example
>
>
> "Bon733" <anonymous@discussions.microsoft.com> wrote in message
> news:D7BF7CBD-C499-47C1-807C-CEE306FAA291@microsoft.com...
> > We are looking into setting up a SQL Server system that will be used in
a
> manufacturing environment (i.e. production runs, accounting). I would like
> to get an idea as to the design that would allow us to run two servers
with
> SQL Server in order to produce the best response time. My goal is to have
> one server for production and another server as a reporting server. Should
I
> set them up in a clustered environment (active/active), log shipping, or
> replication? If anyone has some good technical srticles, please let me
know.
>
>

"Bon733" <anonymous@discussions.microsoft.com> wrote in message
news:D7BF7CBD-C499-47C1-807C-CEE306FAA291@microsoft.com...
> We are looking into setting up a SQL Server system that will be used in a

>Great. Thanks for the input.
>
>Have you had any problems with the transactional replication adding the
>timestamp column to your tables? I have had some bad experience because of
>poorly written software using INSERT INTO ... SELECT * FROM ... so the
>stored procedures or coding bombs out.
>