Viewing 15 posts - 8,461 through 8,475 (of 9,720 total)
You might want to check that the OS sees the RAM first. If it wasn't properly inserted or if the new RAM is bad too, that could cause a problem.
Also,...
March 9, 2009 at 5:59 am
Did you GOOGLE the error or "database_mirroring_state_change" yet? I see lots of articles on this issue just by googling the later.
Try this to see if one of those articles helps...
March 9, 2009 at 5:53 am
It's not just hardware & environment you need to be aware of. Things like available Firewall ports and security access are "need to knows" for installing third party products. How...
March 9, 2009 at 5:42 am
I ended up populating a single variable with the full path and qualified name. Then used a script task within the loop to populate two more variables, source & destination....
March 3, 2009 at 11:31 am
It's always good to see the "legacy" effects of old threads. @=)
Glad it helped.
February 25, 2009 at 10:33 am
DAMN!
It didn't completely work. Now it's padding the flat file with two SPACES after each dollar amount and truncating 2 zeros off the front of the fields.
GRRR.
EDIT: DOH! When I...
February 19, 2009 at 12:33 pm
WOW!
That was beyond complicated.
Here's what I did:
Changed the Output metadata column to decimal with a scale of 2. (Yes, I still had to do that).
Add 2 Derived Column transformations instead...
February 19, 2009 at 12:18 pm
Hmm. Now that's something I hadn't thought about.
When I tried this idea, I ended up, yet again, with 2 extra zeros at the end, but I can get around...
February 19, 2009 at 11:34 am
Right. I got that part.
The question is, what did he do after he found that information? How did he fix the "0" problem?
February 19, 2009 at 4:01 am
Thanks for posting in such detail! That will help others.
February 19, 2009 at 4:00 am
How did he fix the index problem?
February 17, 2009 at 5:30 am
What service pack are you on?
And have you tried searching TechNet to see if there's an existing bug yet?
February 17, 2009 at 4:30 am
sunny1_liu (2/16/2009)
But in my opinion, profiler may consume many system resources, so we hardly turn it on unless really necessary.
If you do profiler right, it won't consume as many resources...
February 17, 2009 at 4:23 am
Try switching the Model DB back to FULL recovery for a moment, backing up the transaction log, then switching Model back to SIMPLE. Then see if you can add the...
February 16, 2009 at 7:41 am
Granting references to DBO schema will indeed grant the ability to see the definitions to all DBO objects in that specific database. And remember, DBO doesn't own all schemas unless...
February 16, 2009 at 6:38 am
Viewing 15 posts - 8,461 through 8,475 (of 9,720 total)