Viewing 15 posts - 1,396 through 1,410 (of 1,583 total)
I don't believe the length of it matters. I used your code and made up a string of nearly 6400 characters and it still ran just fine...
Either there's...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 3, 2011 at 12:10 pm
I checked your code and ran something similar on SQL 2000/2005/and 2008 servers and it worked perfectly. Please run the code below on your system to see if you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 3, 2011 at 11:44 am
Please post an example string and usage...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 3, 2011 at 11:14 am
The issue was actually related to several consistency errors on a non-clustered index on the replicated data. All way needed was to drop the index and recreate it everything...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 3, 2011 at 11:08 am
Although I am not 100% certain of this, I believe the issue to have been that the service broker at the OS-level was hung...which from my understanding is what relays...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 3, 2011 at 8:01 am
Is the data relatively simple? Meaning easily exported to a flat file? If so, BCP is your best (and probably fastest bet). If not, create the linked server...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 3, 2011 at 12:21 am
Sounds like it's still being taken offline. Did you check the box to close the existing connections?
Also, check your default trace file for your instance, and check your SQL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 1, 2011 at 9:23 am
Sounds like you have a REALLY large transaction attempting to be committed and you either have your tempdb and ldf files sitting on a disk that's just about out of...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 9:58 pm
You are missing the full colon ":" in your path
FROM 'c\data\tempfile.txt'
Should be:
FROM 'c:\data\tempfile.txt'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 9:55 pm
Do you have the option to use SSIS?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 9:54 pm
CHECKDB came back without any errors.
Issues resolved.
Thanks for the point in the proper direction!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 7:28 pm
Rebuilt successfully.
Should I run another CHECDB to be sure there's nothing else lurking around in there?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 5:58 pm
Just in case there's an issue with the zip file:
Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 953106486, index ID 9, partition ID 72057594683392000, alloc unit ID...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 5:25 pm
Attached is the output from the CHECHDB...doesn't look too good at a first glance...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 5:23 pm
On second thought...attempting to redo replication like that (dropping the DB, then recreating the subscriptions, etc) gives you an error that you can't drop a database when it's being used...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 4:18 pm
Viewing 15 posts - 1,396 through 1,410 (of 1,583 total)