I understand the part about testing/validating and agree with it, but sometimes that is your only option. I run 24x7 Unix databases on DB2 and sometimes we have to bite...

Inside SQL Server 2000 (Kalen Delaney)

The Guru's Guide to SQL Server Architecture and Internals - Ken England.

We've had similar issues with using IBM's Client Access drivers for the AS/400. The only resolution was to reboot the server, both from IBM and MS. The memory size of...

Systernals has PsTools which will allow you to psexec( execute a remote command) on another computer.

http://www.sysinternals.com

Set a DSNless connection to a full qualified domain name. Like mydsn.sqlservercentral.com as the server name. Then change the name in DNS when you migrate.

Are you sure they are being backed up? SQL Server will hold the mdf and ldf open just like Word, Excel, whatever. Most backup software doesn't handle this or doesn't...

or

create trigger mytrig on mytable for update

as

insert myhistory( myval1, myval1)

 select i.myval1, i.myval2

 from inserted i inner join deleted d on i.pk = d.pk

 where i.myval1 <> d.myval1

repeat.

You need to be able to run the app without interactivity. Can you modify to take parameters?

BTW, using a trigger is a bad idea:http://www.sqlservercentral.com/columnists/sjones/worstpracticetriggeringexternalevents.asp

Deny should work. Have they disconnected and reconnected? Not that it should matter.

I'd make a role that has DENY access and add them instead of their individual permissions.

Not sure you can clear the roles, but I'd change to a strong one time password and then rotate that every 30 days.

Alternatively, if you can, disable SQL Auth.

We are looking at a similar issue in migrating two AD forests to a 3rd new forest. Fortunately the network guys have prepopulated all accounts in the new domain/forest.

the fix...

Wow, that surely isn't about SQL.

I know Andy has an IP phone at home, but not sure if he knows. He's a...

The above suggestion is correct. ANY user, including yourself that has a session open to that db has a shared lock on the db.

Not in your area, but there are a few online places, like IMG University (http://www.imguniversity.com/WebUPublic/default.asp). I took a remote class and it was ok.

http://www.sqlservercentral.com/columnists/sjones/imguniversity_olap.asp

Suggestions above are good. Be sure all connection options are the same. I'd also be wary of dbcc freeprocache as it wipes all query plans out and could cause performance...