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....
Nope, server name will remain the same. I just need to move it off of the C: since it's almost out of space.
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...
hmmm, DDL triggers can't detect a TRUNCATE TABLE? Basically it's a safeguard in case the administrator (me and one other guy) accidentally run a...
Also, is it possible to prevent a DELETE with no where clause and UPDATE with no where clause?
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...
That's a really good idea! I'll give that a try, thank you!
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...
I apologize for the formatting. For some reason it's not doing carriage returns when it renders.
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...
For anyone else who might have run into this problem, the sp_getapplock procedure worked perfectly! Thank you very much FrankKalis for your great...
Thank you kindly for the reply. I've gone through this page already and tried the various types of locks, but nothing does the job. I either get...
Separate names with a comma.
