This made me chuckle. We have...

This gets my vote as what you after is a denormalised version of the data which logshipping and replication is not going to give...

You cant convert so you will have to recreate the package in SSIS or run it as it is under 2008.

Read this for further information

http://msdn.microsoft.com/en-us/library/ms143755.aspx

Steve Jones - SSC Editor (9/21/2012)

---

GilaMonster (9/21/2012)

---

Stefan Krzywicki (9/21/2012)

---

capnhector (9/21/2012)

---

ok im breaking out my "Realy? WTF" card on the behaviour twards the end of http://www.sqlservercentral.com/Forums/Topic1357081-392-3.aspx. did we really hit...

How big is the table? How frequently is it changed and what percentage of rows? How frequently is it accessed?

8 years ago was pre 2007. They were .mde files then

S_Kumar_S (9/21/2012)

---

Hi

We have a tableA with around 100 million records and it is being replicated to table B.

Now since the size has grown significantly, we plan to archive the tableA...

Brandie Tarvin (2/11/2011)

---

I almost forgot to add my favorite Access activity. Creating new tables in Access that aren't in SQL Server (without telling anyone), than getting upset when another user...

Assuming we are talking replication. Do this.

/* ************ */

/*RUN ON DISTRIBUTOR*/

USE master

GO

EXEC sp_adddistributor @distributor = 'distributorname' , @password='pa$$word';

GO

EXEC sp_adddistributiondb @database = N'distribution', @security_mode = 1;

GO

/* Make sure the UNC is...

Or add another file to...

muthyala_51 (9/17/2012)

---

Hi,

I have setup replication with sync type-replication support only and it's working fine. If I need to reinitialize the subscriptions of any publication, do I need to completely drop...

muthyala_51 (9/18/2012)

---

MysteryJimbo (9/18/2012)

---

Running a snapshot is not reinitializing. The only time this will generate any sort of snapshot is if you add 1 or more new articles then a...

Thats nothing to do with replication.

How are you trying to enable replication?

Thats nowhere near enough information. How long is a piece of string?

What servers will you buy? What specification? Do you have any licence agreements?

Once you've done the work...

You need to enable the db for replication.

You can do it through publisher properties or this TSQL

exec sp_replicationdboption @dbname='dbname', @optname= 'publish', @value= 'true'

GO