Viewing 15 posts - 8,446 through 8,460 (of 9,715 total)
From what I understand, SQL 2008 has more Administrator tools than 2005, but most of the developer tools have remained the same. Therefore, it would behoove your company to upgrade...
March 9, 2009 at 6:51 am
The biggest issue will be performance. SSIS is a memory hog and each instance of the package (if it even allows you to kick off the package multiple times at...
March 9, 2009 at 6:42 am
Just add a flat file connection manager for each different file. Then, in your data flow, use them as multiple sources, join them with a UNION (works faster than a...
March 9, 2009 at 6:39 am
Timestamp is a really poor data type to use for any sort of date comparison. It isn't really a date, but an incrementing number that mimics an approximate date/time. It...
March 9, 2009 at 6:36 am
I had a similar problem a few times in the past when I was on SP1 for SQL 2005. I had to write out a T-SQL Statement instead of using...
March 9, 2009 at 6:32 am
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
Viewing 15 posts - 8,446 through 8,460 (of 9,715 total)