Viewing 15 posts - 1,051 through 1,065 (of 1,583 total)
FYI, this all began after installing Service Pack 3. While at the end of the installation it said everything was successful and to reboot, after rebooting it hasn't worked...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 31, 2012 at 11:16 am
Download and use the 64-bit one
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 30, 2012 at 2:48 pm
OP, have you tried my suggestion?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 29, 2012 at 12:13 am
@lokesh - agree, SSIS is ideally the way to go for this type of process
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2012 at 1:47 am
1. Install Office 2007/2012 Data Connectivity Components (http://www.microsoft.com/download/en/confirmation.aspx?id=23734)
2. Change the extension of your excel file to .xlsx
3. Enable "Ad Hoc Distributed Queries" on the server this is running on
4. Run: EXEC master.dbo.sp_MSset_oledb_prop...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2012 at 1:46 am
#1 you run those on the distributor (they won't work anywhere else anyway)
#2 While I can't say 100%, this is most likely caused by the limitations of you replication setup....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2012 at 1:43 am
Do not drop and re-add the articles or you will have to go through it all over again! In the replication monitor (or in the SQL agent monitor) navigate...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2012 at 1:39 am
So now..
Reporting server 1 appears ok but significantly behind on reporting server 2. I need to understand how I can get server 2 catch up.
Reporting server 1 – undistributed transactions...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 27, 2012 at 11:03 pm
Need a little more information here...
Is this synching happening as the result of the first time you turned on replication (i.e. the very first sync) or has it been set...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 27, 2012 at 10:52 pm
Thanks! That's kinda what I was thinking but wasn't 100% sure on any caveats/gotchas that may arise from doing it
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 27, 2012 at 11:20 am
Agree with everyone's replies and wanted to add the obvious tidbit: autofilegrowth introduces a significant amount of contention (as it is a very costly IO activity) and depending on how...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 27, 2012 at 10:21 am
Of course it doesn't work on the Primary Server...It's not supposed to. The OP asked for an automated notification of all log shipped DB's. Log shipping is in...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 25, 2012 at 1:59 pm
I created a simple test and never ran into any issues (however this omits the table partition). Can you script out your partition so I can see which how...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 26, 2012 at 10:42 am
Assuming you are using a linked server...in the linked server setup, under server options, did you set the remote procedure calls to true?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 25, 2012 at 1:20 pm
So the table is a heap (no clustered index), there are no unique constraints whatsoever, yet you get an error inserting a duplicate row...Can you please post the exact DDL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 25, 2012 at 10:30 am
Viewing 15 posts - 1,051 through 1,065 (of 1,583 total)