Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 3,544 total)

  • RE: need to execute bcp command through C#.net - URGENT

    ramesh.tce (9/8/2008)


    I also have same issue.Can anyone help me to export data from sql sever to the temp file in sever using bcp? in c#.netThanks

    If you are using c# in...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Organizations With No DBAs

    p.s. I also want to say that when I say "developers", I'm talking about the greater populous... there are some individual developers that I'm NOT including in my rant,...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Single Page Restore

    OK, the author (me), can't type

    Well at least they did not flame you about the actual question 😉

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: SQL Bulk Insert - using " to wrap text fields

    Change the terminator on the last line to

    "\"\r\n"

    If your data contains the header row you will need

    FIRSTROW=2

    to ignore it

    If you wish to keep the header then note that DATE_ORD is...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: SQL Bulk Insert - using " to wrap text fields

    btw Jeff, I have tried your params and it worked :w00t:

    Don't know why it did not before, but then it was a while ago, maybe I was too green then...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: SQL Bulk Insert - using " to wrap text fields

    Also, know your data. As long as the data is structured and delimited properly then many problems can be avoided. This sort of problem is normally caused by the...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Congratulations to Our New MVPs

    what I'd really like to do is raise a glass at the bar!

    Yeah, you do that, you deserve it :rolleyes:

    And a tip for you....

    When you get there lower the bar.........

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Congratulations to Our New MVPs

    Outstanding! 😀

    You've raised the bar again Jeff 😎

    Gosh it must be dizzy at those heights :hehe:

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: CLR Assemblies

    Greetings!! 😀

    are you going to make the trek to Pass

    Unfortunately not :crying:

    Wish I could 🙂

    Just cannot seem to get the company to splash out the funds...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: CLR Assemblies

    "If you don't write the bloody things, you don't have to worry about stuff like this!"

    ever the cynic eh Jeff 😎

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Text Column Updates

    Just to get me point 😀

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Is a Temporary Table Really Necessary?

    Control disk space and where it is used

    Reduce interference from other apps/databases ie locks

    Minimise effect of rogue apps/databases filling tempdb

    I did state ir was off the cuff.... didn't say it...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Is a Temporary Table Really Necessary?

    :ermm: Out of the blue... off the cuff remark...

    Wouldn't it be nice to create a temp table and be able to specify the database in which is created 😀

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Finding Available Keys When Merging Two Tables

    Good approach, I think... my question would be, how do you find and change all the references to such a table?

    Trust you to think of that one :rolleyes:

    Now THAT...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Moving Databases

    Nice article Andy.

    re:

    First, you need to know how to move logins. I won't go into details here, but read this MS article on how to move your logins

    I have...

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 15 posts - 1,441 through 1,455 (of 3,544 total)