Whatever it is I would stick to an sql server backup to disk then copy that to tape.

You can format the rows yourself and insert them into a global temporary table and then do the output from that.

You can then use bcp or isql for the output.

...

Something like this.

Could put it in a function.

declare @i int, @j-2 int, @end int

select @i = 1, @j-2 = 0, @end = 0

while @end = 0

begin

select @i = charindex(@i+1,',' +...

What format are the text files in?

I would try to do this using bcp.

Treat the import as a separate step to anything else and have the staging table the same...

You can use a kill command to get rid of them.

This will terminate the connection as soon as it can.

If the connection is in the middle of a query it...

I use dynamic sql for converting hex

set@sql = 'set @bin = 0x' + @char

set@parm = '@bin varbinary(' + convert(varchar(10),len(@char)/2) + ') output'

exec sp_executesql @sql, @parm, @bin output

And for getting the...

I never rely on the number of records copied as reported by bcp.

I always get a control file from thye source which contains summary info (e.g. no. of recs) and...

SELECT ITEMID FROM ITEMS

WHERE ',' + @Rule + ',' like '%,' + convert(varchar(10),itRULE) + ',%'

This will only scan an index though.

see

http://www.nigelrivett.com

Administering SQL Server Release Control

direct link at the moment

http://home.btclick.com/NIGELRIVETT/SQLServerReleaseControl.htm

You are trying to use English format dates. With v6 if the server or operating system were installed as American then sql server would default to mm/dd/yyyy and it was...

To get the error message you need to look at the output buffer as the substitutions are not held anywhere.

An example of how to do this is at

http://www.nigelrivett.com

direct link...

see

http://www.nigelrivett.com

Access Temp Tables Across SPs

Which includes a bit on accessing temp tables created in d-sql.

Sorry to advertise another site here but you might look at

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=12229

Which was concerning someone else trying to build an audit trail trigger.

Also info that might be applicable at

http://www.nigelrivett.com

sp_executeSQL

Columns_updated()

Generate Trigger

p.s. I...

try a

use sharan

statement.

One difference in being a dba to most other work (similar to networking though) is that a main part of the job is protecting a company from it's own incompetence.

You...