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.

JerseyMo.

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

Place...

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?

--JerseyMo

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...

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...

Wayne:

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...

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...

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...

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

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:

SELECT TOP 1 WITH...