Viewing 15 posts - 8,461 through 8,475 (of 9,725 total)
What kind of job are you executing? Sounds like an SSIS package error.
What version of SQL Server are you using (including service pack)?
March 9, 2009 at 6:29 am
If the databases are being modified daily, there is something seriously wrong with the development process. There should be an SDLC (software development life cycle) process in place which forces...
March 9, 2009 at 6:27 am
So far as I know, SQL Server itself does not change the min value of the memory setting.
Are you sure you're the only person with the security to go in...
March 9, 2009 at 6:19 am
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
Viewing 15 posts - 8,461 through 8,475 (of 9,725 total)