Viewing 15 posts - 6,361 through 6,375 (of 9,707 total)
Jpotucek (2/25/2011)
What OS collation are you using?I do not know how to determine the OS collation. :blush:
Try Control Panel under Regional and Language Options (I'm looking at this in XP,...
February 25, 2011 at 6:36 am
Hm. That is odd. What OS collation are you using?
How is the data being inserted? Via a client front end, SSIS, Bulk Insert, etc.? Has that changed recently?
Is the data...
February 25, 2011 at 5:30 am
I know this is a stupid question, but did you uninstall it first? Did you try the repair utility?
As far as Messages go, message is a keyword for Service Broker,...
February 25, 2011 at 4:48 am
Did you use a #Temp table or a regular table that you deleted afterword?
February 25, 2011 at 4:25 am
How do they prove they posted the link if it gets deleted?
February 24, 2011 at 12:44 pm
I think BAPIs is the way the webservices I know of do it. There's no direct table involvement.
I don't think I've tried the SSIS adapter, though.
February 24, 2011 at 12:37 pm
Management Studio is just a client tool. If it's corrupt, try reinstalling it.
February 24, 2011 at 12:34 pm
And don't forget the possibility out-of-date statistics. While most people only think about them when it comes time to read, my opinion is that bad stats can also affect inserts...
February 24, 2011 at 12:33 pm
As Ninja said, it's a guesstimate, not a science. But you can average out your monthly growth as a baseline, then talk to the business about upcoming trends. If the...
February 24, 2011 at 12:31 pm
Latin collation will not allow Polish characters. It sounds like you need to change the database collation. Look up "collations [SQL Server], about collations" in Books Online. (without the quotes)....
February 24, 2011 at 12:27 pm
Aaaaahhhhh. Good catch.
For some reason, I had it in my head that all I had to do was leave it at "Report and Continue" and that would cause it...
February 24, 2011 at 12:23 pm
I'm only assuming. I could never get the cube to process so long as "Key Not Found" was left as "Report and Continue." But as soon as I changed that...
February 24, 2011 at 11:55 am
Koen Verbeeck (2/24/2011)
SSIS doesn't have a date datatype, so in my opinion the best option is to do the conversion immediately in the source query.
The name is deceptive (database timestamp)...
February 24, 2011 at 11:50 am
Viewing 15 posts - 6,361 through 6,375 (of 9,707 total)