Viewing 15 posts - 1,396 through 1,410 (of 1,584 total)
October 3, 2011 at 12:34 pm
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...
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...
October 3, 2011 at 11:44 am
Please post an example string and usage...
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...
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...
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...
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...
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...
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'
September 30, 2011 at 9:55 pm
Do you have the option to use SSIS?
September 30, 2011 at 9:54 pm
CHECKDB came back without any errors.
Issues resolved.
Thanks for the point in the proper direction!
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?
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...
September 30, 2011 at 5:25 pm
Attached is the output from the CHECHDB...doesn't look too good at a first glance...
September 30, 2011 at 5:23 pm
Viewing 15 posts - 1,396 through 1,410 (of 1,584 total)