The status code contains a decimal representation of the bit mode data.

In your case, value 28 = 4 + 8 + 16

Which means all of the conditions below.

4 = select...

My guess is you're probably referring to the multiple rows result set.

If so, you want to limit the query by index id type.

Try append this clause to the query

...

Your BCP format file should look something like this.

(Substitute the appropriate SQL version number and collation name)

8.0

1

1 SQLCHAR 0 1024 "\r\n" 2 data SQL_Latin1_General_CP1_CI_AS

You can turn off logging by changing the database recovery model to 'simple', using ALTER DATABASE command.

Not recommended during online processing window, as it affects all other processes.

1) The code page option allows you to specify the format of the output character type when you export from SQL Server, and input format when import to SQL. One...

The error suggests there is problem with the destination table definition. Make sure the column name and data type match.

It would also be helpful if you post the table definition...

1) Typically, you'd have multiple files when you have direct control of seperate physical disk devices for data placement, and for the purpose of performance. But since you're already on...

You need to code the cmd file to something like this:

echo open ThisFTPSite ThisPort> Tempfile

echo MyUserName>> Tempfile

echo MyPassWord>> Tempfile

echo bin>> Tempfile

echo put File1>> Tempfile

echo put File2>> Tempfile

echo put File3>> Tempfile

echo...

Deleting old backup file is one of the last step that gets executed.

It gets executed only after all of the backup steps are completed sucessfully.

Any prior error would prevent this...