Definitely a bug, but interesting in the way the type conversion works well for 10 9s and 8 9s, but not 9 9s.

What indexes are on the table? How many rows? Are you sure statistics are up to date?

Can you create a new db, detach it, and then attach it back right away? Almost seems like something's wrong with your install. Are the mdf/ldf from the same version...

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...