How about specifying EOFCRLF as the row terminator when you BCP in? Then it shouldn't bring the EOF into the field.

-Dan

Antares is right...you must call it like this:

select * from OPENQUERY(TSTCMDDB1,'select * from master.dbo.usysprocess(51)')

-Dan

One trick you may be able to use if the flat file is fixed width or comma/tab delimited is to create 1 large column in a work table, named "text1"...

Ah, the never-ending debate...I worked on Sybase/UNIX platform for 5 years and now I work with SQL Server, and I can say without a doubt that MS SQL Server 2000...

You could use an insert trigger to put a record into a control table that holds those needing the backorder process run on them. Then a SQL server job...

Try:

SELECT [contact-date], FROM custlog

WHERE Convert(varchar,[contact-date],101) like '07/01/2002%'

OR

-- This will use the index, if there is one...

SELECT [contact-date], FROM custlog

where [contact-date] > Convert(smalldatetime,'07/01/2002')

and [contact-date] <=...

I think this is a bug with Microsoft. You may have to convert it to a char and pad it with spaces or zeros.

-Dan

Try This:

IF NOT EXISTS (SELECT * FROM sysobjects WHERE [Name] = 'TAB1' AND Type = 'U')

BEGIN

CREATE TABLE TAB1 ...

END

-Dan

Thanks, that's exactly what I needed!

-Dan

Dynamic SQL is slower due to the fact that the execution plans cannot be re-used. Even with sp_executesql, the execution plan can be re-used if the query stays the...

Typically data can be returned in the order of the clustered index without the use of ORDER BY, but there are some exceptions:

1) If the optimizer determines that the cost...

Keep in mind that doing a SELECT inside a transaction still does not put an exclusive lock on that row. You must do something that involves a logged operation...

I find that this does suppress the count messages:

set nocount on

exec master..xp_cmdshell 'dir *.txt'

How are you calling the extended proc? By the way, I'm on SQL 2000.

-Dan

The field that is being updated needs to be checked in the WHERE clause. For example, if you are updating the InUse field, then it must say in the...

Thanks, I'll give it a shot!

-Dan