ODBC and SQL Hostnames as seen by Profiler

[tdudley]

Just an FYI,
In looking at the current activity in SQL Server 2000, I came across a machine logging in with my userid but a very old hostname. It turns out that a Batch machine was running a scheduled query via an ODBC connection. The Access application, using the ODBC connection, was created on another machine and copied to the batch machine. SQL was using the machine name affiliated with the ODBC connection not the actual machine that was running the query. I know I should optimize the query and use ADO and this will go away. This has been running for a long time but I've just never noticed. Hope this is helpful to someone.

[Rawhide]

You should also note that DTS Packages store the name of the machine that it was created on in the package properties and will report that it is on this machine when running even if it is not.

You can change this property by going into the disconnected edit of the package.