replication databases and reporting - best practices?
Mon, 26 Jul 2010 16:30:05 -0700
We're a small SQL Server 2005 shop. We don't use Reporting Services, and we
do very little OLAP, and quite simple OLAP at that. Instead we've got a set
of OLTP databases on our production server, and a distantly-located set of
reporting databases, which include databases replicated from the OLTP
databases. W ...
|
GHD Rare Styler New Hair Straightener Set
Sun, 25 Jul 2010 19:35:19 -0700 (PDT)
The Public Theatre struggled to raise the $5.5 million budgeted for
the Broadway transfer, because of the severity of the economic
recession in late 2008, but it reached its goal by adding new
producing partners. Director Diane Paulus helped keep costs low by
using an inexpensive set. The show grossed a healthy ...
|
jameelmossly@yahoo.com
Sat, 24 Jul 2010 20:00:52 +0200
ãÍãÏ ÇáíæÓÝ mahmdyosef35 Skype ÈÑÇãÌ
ãÍãÏ ãæÕááí ÇÍßí ãÚ ãÇãÇ
...
|
Merge Replication: access right issue
Fri, 23 Jul 2010 05:57:40 -0700
Hello all,
We have merge replication up and running. But we have used admin rights at
subscriber/publisher/distributer because we were testing.
Publisher: SQL Server 2008
Subscriber: SQL Server Express Edition
We use pull subscription and for running merge agent at subscriber, we run a
batch file which ...
|
Merge Replication: subscription problem
Tue, 20 Jul 2010 06:00:27 -0700
Hello all,
We have a merge replication set up and we are facing problem with a
subscriber.
Publisher: SQL SERVER 2008 Standard Edition. Instance Name: Lapi1/Comp
Subscriber: SQL SERVER Express Edition. Instance Name: Pup/Num
Note: Subscription is not on same server as publisher
We have built a pull ...
|
Snapshot Agent not Starting
Fri, 16 Jul 2010 22:35:56 GMT
Currently trying to replicate between two servers. The publication database
on one server was recently restored from a copy of the database, but a copy
in which the database wasn't set as a publication. well, I wanted to try
starting from scratch so disabled the distributor and re-created everything
(distribu ...
|
Replication between SQL Servers 2003 and 2008
Fri, 16 Jul 2010 12:58:10 -0700
I have a push merge replication running well on 2003 and we're trying to
migrate to a 'cloud' server running 2008. Before we switch all sites to
2008, I need to replicate from 2003 to 2008 and I can't register the 2008
instance in SQL Enterprise Manager and can't seem to find any way of
replicating to the n ...
|
|
|
Transactional replication
Fri, 16 Jul 2010 13:51:51 -0300
I have to create a replication between three SQL Server where each one is
the main server of three different stores. Each store have its own number.
This number is what identify data to each one inside the tables. Which type
of Transactional replication best fit this project? Updatable Subscriber or
peer-to- ...
|
merge replication: suggestion on deploying my application
Fri, 16 Jul 2010 05:54:38 -0700
Hello all,
We have an aplication in .net which we are planning to deploy on our workers
laptop so that they can work offline with their own copy of database.
We planned to do merge replication and have database replicated across
workers machine.
We have tables, procedures and triggers to be replicated. ...
|
Merge Replication: user trigger issuu
Thu, 15 Jul 2010 08:38:25 -0700
Hello all,
We have a trigger defined on table x which gets executed when an update is
on a column. The trigger is executing properly on publisher side.
But when we do update on subscriber side to that particular column, trigger
doesnt execute.
While publishing I had user defined triggers true for the ta ...
|