I would like to suggest that anyone interested in leaning more about SOPA and it's potential effects should read Mike Masnick at techdirt.com.

Steve Jones - SSC Editor (8/24/2011)

---

jcrawf02 (8/24/2011)

---

Why the surprise? Pop-Tarts are quite possibly the perfect food. Box of pop-tarts, box of Twinkies, jug of water and a cockroach for company,...

I also bicycle commute as often as possible when the weather here in Minnesota is good. It’s 7 miles into work but I take a longer more scenic route home...

You'll want to stop replication - stop the log reader agent job.

Then remove the tables, the ones that you need to alter, from replication.

Make your table altercations on the publisher.

Then...

"And politicians LOVE and ENCOURAGE every bit of it. The answer to it all is: TERM LIMITS."

I think a better solution is to limit campaign contributions. Eliminate all business, individual,...

"Business are better off staying out of politics or deciding who is worthy and who is not. Public Corporations have a fiduciary responsibility to their shareholders: to make good business...

Using transactional replication for DR is not easy. You'll likely run into issues with identity columns when you switch to the subscriber instance. Please see the following:

http://www.replicationanswers.com/DR_Using_TR_in_SQL2005.asp

When we need to use linked servers, we use a script. Generally that script will add the linked server, perform some data manipulation across the linked servers (i.e. copy a...

We have about 100 old 5.25 inch floppy disks. Let me know if you need some. 😀

Use compression, too - zip/unzip.

Thanks for the new v2 version. It looks great! This will be very helpful.

Ninja's_RGR'us (1/31/2011)

---

Phil Factor (1/31/2011)

---

A great deal of space in the internet is being taken up with he debate about climate change. It isn't really a database topic, and I don't...

djackson 22568 (1/30/2011.....so called health care reform has reduced payments from goverment to hospitals, while increasing regulations and decreasing reimbursements from the one source they can use to pay bills...

Here's a script that we use on a SQL2005-SP3 setup for transactional replication...

USE master

EXEC sp_adddistributor

@distributor = N'MyServerDISTDB\MyServerDIST',

@password = N'SomePW'

EXEC sp_MSupdate_agenttype_default @profile_id...

There are basically 3 types of replication: Transactional, Merge, and Snapshot. Transactional is the most common of the 3.

Think of it as a newspaper or magazine publication that's delivered to...