Viewing 15 posts - 7,096 through 7,110 (of 9,720 total)
Do you have the same number of columns in the table as are in your file?
October 25, 2010 at 10:48 am
The suggested code only works if all your dbs are on the same instance. You have to re-run this for every instance you have if the databases are split between...
October 25, 2010 at 10:46 am
Informational is not an error. It's just giving you information. It's not even a warning.
Are you having problems?
October 25, 2010 at 10:22 am
There are lots of big names. If I were you, I'd google it and compare prices, options, and hardware requirements.
October 25, 2010 at 10:21 am
GilaMonster (10/25/2010)
You can restart the instance. If the rollback is hung that usually helps.
I can definitely attest to Gail's comment here. But I don't advise restarting until you've exhausted...
October 25, 2010 at 10:19 am
I take it you weren't running into issues before you started processing on a batch level?
What else is running when you're doing this?
TempDB holds the result sets of your...
October 25, 2010 at 10:16 am
So far as I know, MS Bing is not native to SQL Server, so does not have any procs designed for it. If there's an add-on or extended proc that...
October 25, 2010 at 10:09 am
I don't even understand the poll.
October 25, 2010 at 10:07 am
Also look up the following in Books Online:
ALTER PROCEDURE
CREATE PROCEDURE
DROP PROCEDURE
October 25, 2010 at 10:06 am
It's not a prestige thing for me. It's a "be nice to have a door to shut when people are having an impromptu conference right outside your workspace (at the...
October 25, 2010 at 10:04 am
Thanks, Gail. I just wasn't sure if R2 was being treated as a separate version or as the "upgrade" to the regular 2k8.
October 25, 2010 at 9:58 am
Datetime settings usually default to what is set in your server / database collations. That's what you need to check.
Not quite sure how to check it off the top of...
October 25, 2010 at 9:34 am
Do you have a workspace mapped to your local drive?
If not, you need to define your workspace, map it to your local drive. If you already have a folder where...
October 25, 2010 at 9:32 am
Chances are the comma is what's making the insert not work properly. You need to either regenerate your csv file with different delimiters, regenerated it with text qualifiers (so the...
October 25, 2010 at 9:27 am
CirquedeSQLeil (10/25/2010)
If the [fish] market is closed, just steal it from a bear.
I seen that movie. It did not end well.
October 25, 2010 at 9:03 am
Viewing 15 posts - 7,096 through 7,110 (of 9,720 total)