Viewing 15 posts - 8,446 through 8,460 (of 9,707 total)
I'm going to assume you've already activated database mail & set up your profiles & accounts. However, as Tracey posted, test the dbmail proc in SSMS without an attachment to...
March 9, 2009 at 6:14 am
I would start off by getting the company a data modeling tool. Reverse engineer all the databases and then sort them in the diagram by purpose. We have a database...
March 9, 2009 at 6:07 am
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
Viewing 15 posts - 8,446 through 8,460 (of 9,707 total)