| Thread | Last Post | Replies |
|
| Cannot insert explicit value for identity column in table x | 16 Mar 2010 20:49 GMT | - |
I am reposting this from the Sql Server Forum. We are using Sql Server 2005 9.00.4035. We have a hub and spoke topology which includes 6 tables with identity columns.
|
| Preparing for replication on sql server 2000 | 15 Mar 2010 21:19 GMT | - |
Hello all I am using sql server 2000 sp4 (boy do I feel obsolete) I am trying to prepare for replication (transactional Replication ). The manual I am following tells me that I need locate identity columns in the schema and adjust them to "NOT FOR REPLICATION" The below query
|
| SQL 2008 - Merge Replication - Filtered Publication - Updating Par | 13 Mar 2010 21:31 GMT | - |
SQL Server 2008 Standard SP1 Publisher and Server 2005 and 2008 Express subscribers. I have merge replication setup and working great, except for a single issue that I’m hoping someone can help me with – it involves filtered articles and
|
| Replication Skipped Records | 03 Mar 2010 20:35 GMT | - |
Win 2003 Server / SQL 2005 SP2 Std Ed Pub/Subscribers(7-LAN, 1-WAN) / Distr (dedicated) I have a pub w/ 200 tables, approx 30gb Subscriber is across WAN. I use log shipping to sync instead of snapshot
|
| deleting failed replication commands | 03 Mar 2010 08:25 GMT | - |
I've a transactional replication, now this replica hangs because of a command that has generated an error. With sp_browsereplcmds I have found the cursed command: exec distribution..sp_browsereplcmds
|
| SQL database not accessible during transactional replication | 02 Mar 2010 08:09 GMT | - |
I've setup transactional replication between two SQL servers. The publication database is on a standalone server and the subscription runs in a live environment where the database has to be accessible during replication. The subscription has some stored
|
| Perform only schema change replication and avoid data replication. | 02 Mar 2010 07:34 GMT | - |
I am having typical scenario in sql merge replication. I need to synchronize table with data and schema changes. But for one column in the table should not be replicated. Schema of the column should be replicated but data should not be.
|
| New article - snapshot not applying at subscriber | 01 Mar 2010 16:07 GMT | - |
Last Friday, a request came to add two new articles to our transactional replication setup. I did things as I normally do (i.e. sp_addarticle & sp_addsubscription for each article, then generate snapshot), but the subscriber would not pick up the snapshot. Here's
|
| Tx Replication Issue - Syntax error, permission violation | 28 Feb 2010 17:14 GMT | - |
I am facing an issue at the Tx replication side. Pub. & Sub are in the same server [sql 2005+sp3 standard] Typical error msg is as follows, Replication-Replication Distribution Subsystem: agent DEV-DB-DEV-17 failed.
|
| BUY FAKE PASSPORTS OF NETHERLANDS,FAKE DUTCH PASSPORTS FOR SALE! FAKE UNITED STATES(USA) PASSPORT | 26 Feb 2010 19:04 GMT | - |
Our team is a unique producer of quality fake documents. We offer only original high-quality fake passports, driver's licenses, ID cards, stamps and other products for a number of countries like: USA, Australia, Belgium, Brazil, Canada, Italia, Finland, France,
|
| Error ' Could not obtain information about Windows NT group ' | 24 Feb 2010 16:18 GMT | - |
I have upgraded several databases from 2005 to 2008. I configured replication (created publisher and subscriber) and log reader for a database in question was failing because of 'Could not obtain information about Windows NT group/user ...' error. Now I am trying to drop ...
|
| using a UDF as a filter in trans replication | 24 Feb 2010 15:50 GMT | - |
All servers are running SQL 2005. I created a UDF that returns one value ~~~~~ create FUNCTION dbo.WhatLocationIsThis() RETURNS numeric AS
|
| Synchronise replication agents | 23 Feb 2010 19:48 GMT | - |
I have performed a transactional replication in my company. However, replication agents are idles. I need a script or a command sql to start the three agents (snapshot, journal and distribution). I write a script to create the transactional agent; however, these three
|
| Script to start replication agent | 22 Feb 2010 19:45 GMT | - |
I have performed a transactional replication in my company. However, replication agents are idle. I need a script or a command sql to start the three agents (snapshot, journal and distribution). I write a script to create the transactional agent; however, these three
|
| 下載免費的反病毒 8375 | 22 Feb 2010 19:28 GMT | - |
許多性能問題和安全性您的計算機造成惡意病毒,最好的辦法對付,這是得到承認和防病毒在計算機上安裝更新 殺毒軟件免費下載: http://antiviruscn.blogspot.com/ 鏈接網站的內容:
|