| Thread | Last Post | Replies |
|
| 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,
|
| case sensitve master, case insensitive replica | 26 Feb 2010 19:00 GMT | 1 |
Is it possible to build a replica db case insensitive while the master is case sensitive? I have setup a replica database using collation CI , still the data is handled as collation CS .
|
| Updatable subscription and Linked Servers. | 26 Feb 2010 17:00 GMT | 1 |
I just realized that when I sever the connection between the publisher and describer, writes fail b/c it complains about not seeing the other server!! Is this something that changes, does updatable subscription require 100% uptime?
|
| Credentials for Mirroring | 24 Feb 2010 22:30 GMT | 1 |
We are mirroring a SQL Server 2008 Entreprise database over to another SQLServer on another server. We had issues setting this up due to the credentials the SQLServer service runs under (LocalSystem) seems it didn't have permissions to write over to the target server. To solve ...
|
| 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/ 鏈接網站的內容:
|
| Replication Failure-Cannot drop replication | 21 Feb 2010 19:17 GMT | - |
My distribution server failed. Because of that my publishing database log file will not shrink because it is waiting to push out the transactions. I re-set up the distributer, all linked servers and logins. I still get the error below when I try to drop or do anything that matter ...
|
| Peer to Peer replication for partitioned table using sliding windo | 17 Feb 2010 04:59 GMT | - |
I have 2 servers (server A and Server B), both with one database that contains two tables (we'll call them MainTable and StageTable). These tables are partitoned using the same partiton schema (1 partition per month for the last 2 years using range left = 25 file groups and 25 ...
|
| Updatable subscription issue - Either no algorithm ... | 16 Feb 2010 17:43 GMT | 1 |
SQLException: Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of Windows. Replication was running fine and this morning all subscriptions were failing
|
| Peer2Peer. Dist to Sub 'Query timeout expired' | 14 Feb 2010 11:34 GMT | 2 |
Greetings all I have P2P set up, SQL 2008 Ent, 2 peers, been working well for a month or 2. After a recent large 'update' statement affecting 25k large records, data hasn't made its way to the subscriber after some 10 hours. These records can
|
| Error: 17832, Severity: 20, State: 8. | 11 Feb 2010 21:46 GMT | 1 |
All servers are Win 2003 & SQL 2005 I have a SQL Server that has many publications (30) & subscriptions (+/- 75). There are is a publication that has several (4) subscriptions & 2 of them work fine & the other 2 report the message
|