Are you sure there wasn't something else added to Server A by the PSFT product?

Not so easy since the sysdepends information isn't dependable. I guess you could search out the code for all objects in sysobjects and perform an alter on all of them,...

For the sysadmin, you can run a query on syslogins and check for administration with a function (isadmin(), I think?). Same for dbo, although you'll need to query each sysusers...

That's a tough one. What about putting the SQL Server at their sites and you vpn in to admin it?

Since 65 mimics a v6.5 server, some of the keywords that are used for advanced functionality, like TOP, INSTEAD OF triggers, etc, do not work. If it works for you,...

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/