When you say change the recovery model, from what to what?

I don't think you need to mess with replication. If you are moving from simple to full, you need to...

Shouldn't that be server=?

You can redistribute the DTS DLLs onto the client machine if you need to. If you just want to run the program on the server, but initiate from teh client...

A security alert was issued because the way SQL Server works is to respond to 1434 with the port of the instance and what it is. Since you are disclosing...

If you have date feilds in your tables, you can delete based on dates, but you cannot "rollback" all changes based on a date with the SQL Server product.

If you...

I swear that I've had this working before. We had all kinds of servers attaching to the AS/400, but perahsp the SQL tools were installed last. I'd try a reinstall...

What if two rows are inserted?

You need someway to determine what the "order" of the rows i n tank is. Perhaps the date? (assuming this is datetime)

create trigger ...

insert...

What version of client tools are you using? I can register my SS2K servers, SP3a on W2K from my W2K3 server.

What error are you getting? # and msg?

I'm not sure if this helps the server, but dbcc freeproccache will clear the cached plans from SQL Server. Might allow some memory...

Might try here: http://www.vba-programmer.com/

Once SQL Server has the memory, unless the operating system requires it, it will not get released. How much memory on the server and what does SQL grow to?

QA and...

select * from information_schema.columns. Sort, rearrange as you like, then save the data into a file. (CSV) and open in Excel.

T-SQL, or Transact-SQL is from Sybase and I've been working with it since 92, when it was SQL Server 4.2 on OS/2, ported from Sybase v4.2 on *nix. I'd suspect...

select

case when t.type = 'D' then t.amount

end 'Debit'

, case when t.type = 'C' then t.amount

end 'credit'

from Transactions t

gets you them...

You should have your maint plans create a jog. The error code in the job is worthless, check the log.