Viewing 15 posts - 721 through 735 (of 1,583 total)
It depends on how your replication is architected. I'm pretty certain the subscriber only needs to be able to talk to the distributor. Any "external" server needing replicated...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 4, 2013 at 8:53 am
I would check 2 things:
1) On your SQL Server, have you allowed remote connections to the server?
2) In your linked server set up, did you set the Data Access to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2013 at 11:16 pm
Table A: (Master)
PCID (PK)
ComputerName
OS
OSVersion
Manufacturer
Table B:
PCID (FK)
SoftwareName
SoftwareVersion
SoftwareLiscencekey
Installedversion
?
Or you could go really crazy and create an OS, Manufacturer, Software table - but that'd probably be overkill 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2013 at 11:10 pm
I think you're on the right track with the "meds", get them and relax a bit, or meet with a therapist 😀 Then again after reading your mini-novel, maybe both...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2013 at 10:56 pm
Tables that involve a lot of "changing data" aren't always the best candidates for Transactional Replication. In the past we had a table for "Transactions Not Processed", or a...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2013 at 1:52 pm
Is there any chance that your subscriber databases are near the maximum file size that's been set, and due to the amount of data being replicated, the files are constantly...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2013 at 10:50 am
Thanks for the clarification, it is greatly appreciated
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2013 at 10:48 am
As long as you're the person who's responsible for the outcome, I don't think it ever goes away.
Recently, in our busiest Production environment, I had to relocate several large (+1TB)...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2013 at 10:47 am
In trying MS's adive (re-installing the 2.0 framework), it won't allow me to do that - it errors out stating it's required and cannot be uninstalled - any suggestions?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 26, 2013 at 7:41 pm
Glad the question was well received 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2013 at 10:54 am
Do you have a linked server set up and allowed remote connections to it?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 24, 2013 at 11:23 am
Note, it's only required for the very first time either you or the account that will be used runs it. If you ever change the proxy account you'll need...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 24, 2013 at 11:11 am
Lutz, ironically enough, that's the exact same piece of software that we use (TotalHTMLConverter) and unfortunately, you will need to use the code I provided in order for it to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 24, 2013 at 11:10 am
@@ROWCOUNT is overwitten after each statement is executed (its scope is therefore lost). Create a variable before the transaction declarations and assign the @@ROWCOUNT to it for each statement...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2013 at 6:25 pm
Perhaps this will help:
SELECT
a.publisher_db,
a.article,
ds.article_id,
ds.UndelivCmdsInDistDB,
ds.DelivCmdsInDistDB,
CASE WHEN md.[status]...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2013 at 6:21 pm
Viewing 15 posts - 721 through 735 (of 1,583 total)