Hello, Just wondering if anyone has any recommendations for 3rd party peer-to-peer replication? Our goal is to synchronize data across 8 or so...
Hi Guys, We had a major problem over the weekend where a specific process seems to have gotten stuck for about 12 hours before I killed it and...
Hello, We have the following replication scenario: 2 master servers that are involved in P2P communications. We'll call these Server A and Server B....
Hello, is it possible to move the distribution database without having to drop and recreate all publications/subscriptions?
Hello, I'm currently building a new SQL 2K8 server that will act as a replication publisher/distributer and will replace an existing one that we have...
Hi Guys, Is there a way to prevent TRUNCATE TABLE in a DLL or DML trigger? Basically I want to prevent all TRUNCATE TABLE operations unless the...
Hi Guys, Here's my current situation. We have some tables that have over 1 billion rows and they've never been partitioned. We need to partition...
Hello,I currently have an alert setup as follows:Object: SQLServer:TransactionsCounter: Longest Transaction Running TimeAlert if counter: rises...
Hello, I currently have an alert setup as follows: Object: SQLServer:Transactions Counter: Longest Transaction Running Time Alert if counter:...
Hi Guys, We've been randomly receiving the following error message about 5 times a day: Callback A transport-level error has occurred when receiving...
Hello, I've got a Data Flow that uses an XML Data Source to retrieve data, which then extracts into a table. Works great for smaller data sets,...
Hello, Last night we had 3 separate applications (running on the same server as SQL2K5) log error messages stating that an INSERT they were doing had...
Hello, I've got a fairly simple table: CREATE TABLE MyComments ( UserID BIGINT, Comment VARCHAR(50), CreateTime DATETIME ) Pretty simple...
Hi Guys, I've got a problem with regards to a race condition in one of our stored procedures that is causing duplicate rows. The script below does...
Hello, Oracle and DB2 have options you can set to determine how often transactions are flushed from the log buffer. This greatly improves...
Hi All, I'm experiencing some odd behavior on one of our new 64 bit SQL2K5 boxes. This box has 3 physical drives, one for the OS and applications,...
Hello, I've created a very simple test app that calls a stored procedure (which does nothing, just takes a few parameters and returns nothing)....
ok, I have some weird behaviour on our new 64 bit box. When I do this: WHILE @Counter < 5000 BEGIN INSERT INTO Table VALUES(...) SET @Counter...
Separate names with a comma.
