The .ActiveConnection needs to be an open ADODB.Connection object. You have to explicitly open a connection and that seems to be what's missing. Something akin to...

    .

    .

    .

    Dim oConn

   ...

Mark and I have been trading PMs... looks like the briefing was discussing the 64-bit version of SQL Server. There's a KB article from the 9th of Jan that also talks...

Does any of this help?

http://support.microsoft.com/default.aspx?scid=kb;EN-US;317012

The Win2000 server doesn't happen to have an ASPNET account locally, does it?

Without modifying the system stored procedure sp_addsrvrolemember, there's no real way as triggers are not guaranteed to fire on system tables. You could audit the role periodically, but that doesn't...

IIS is on the same system as SQL Server or different systems?

What errors are you getting?

You can run the script through Query Analyzer. You may have to make a few small changes here and there to reflect differences between the server, but it's a basic...

You can script all jobs in Enterprise Manager.

Management | SQL Server Agent | Jobs.

Right Click.

All Tasks | Generate SQL Script...

It is entirely possible that the installation of the second network card is slowing down the queries, etc. However, it's hard to say with this little bit of information. Are...

Enterprise Manager is available and I'm not aware of any issues with DTS though I don't believe we've migrated any DTS packages over as of yet. Are you sure your...

What do the last few lines of your sqlstp.log report? It should be in %SYSTEMROOT%. You can go from SQL Server 2000 RTM (the CD) straight to SP3 without applying the...

If you really lock down master, then true, you've mitigated most of the rest. Most folks don't think to do this, unfortunately.

If you really lock down master, then true, you've mitigated most of the rest. Most folks don't think to do this, unfortunately.

What this means was something else was using port 1433. Generally, if you can figure out what program is, if you get it to release 1433, you can simply stop...

Well... with cross-database ownership chaining, there is still quite a bit of recon an intruder can do. Hence the reason to use Command objects or the equivalent thereof as well...