Forum Replies Created

Viewing 10 posts - 31 through 40 (of 40 total)

  • RE: Changing a Server from Case Sensitive to Case Insensitive.

    Agreed, you can alter the a database but not the server default.

    Just make sure you run the command in master!  Otherwise, you get an error message.


  • RE: Is this Possible?

    Why use a temp table or view?  Just use the bcp query out like this


    bcp.exe "select CustomerID, CompanyName From master..Customers" queryout C:\Data\Customers.txt -S %isqlserver% -U %isqluser% -P %password% -c >>C:\DATA\LOG\customet_bcp.log




    Why not ftp the files from the Sybase server to MSSQL server?

    Or, use DTS to connect and have it pull your data for you?




  • RE: Creating an Out File with BCP

    Although I have never used the -o switch, I do run a similar batch update.

    Within the batch file I log the results to *.log to provide an audit trail.

    bcp.exe "Select...

  • RE: SP to create a BCP format file

    Yes that is quite odd. I just ran it under the pubs db on my test server and here is the result.  I removed the collation just to reduce the...

  • RE: SP to create a BCP format file


    Kudos for using the information schema provided by SQL server.  I  see your point about the provided script and that it maybe confusing.  However, it is a example and can be...

  • RE: SP to create a BCP format file

    I have used this myself. I'm no not recall where I picked it up from but, it is very helpful.  Use it in Query Analyser and just cut and paste...

  • RE: New Server what spec

    I may not have used the term 'honking'.  But, yes legacy data is a generic term for information that has been accumulated in a system that is beign replaced or...

  • RE: New Server what spec

    I just installed two new servers that handle mulptile database that are accessed by different front ends.  Here are the specs:

    HP Proliant DL380G3 Dual Xeon 3.06 GHz<O

  • RE: Question of the Day for 14 Oct 2004

    Server: Msg 208, Level 16, State 1, Line 1

    Invalid object name 'foo'.

    Clearly the table name is invalid.......and should be People

    If the query had been correctly coded as:


Viewing 10 posts - 31 through 40 (of 40 total)