We use a lot of virtual machines. I have a base VM with SQL 2005
installed. I rename this VM (i have multiple copies running) and run
an old application (VB code, iterates through recordsets, etc.).
I get: Microsoft][ODBC SQL Server Driver][SQL Server]Could not find
server '2K3VM-DG' in sysservers. Execute sp_addlinkedserver to add the
server to sysservers.
This makes sense, and I can fix it with sp_dropserver / sp_addserver
[local]. Good.
The next error is puzzling though:
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not
include the table being modified or the table is not updatable through
the cursor.
Any suggestions on how to fix this?