I have experienced Msg 7311 "Cannot obtain the schema rowset ..." before querying a SQL 2000 database via a linked server from SQL 2008. For some reason I has...

If i understand correctly you want to run SQL 2000 on a server that is not on a domain. If you create identical local user accounts/passwords on both the client...

Unfortunately I'm still on SQL 2000 so I get the following error:

Server: Msg 197, Level 15, State 1, Line 12

EXECUTE cannot be used as a source when inserting into a...

 I don't believe its as simple as Carl's SQL above. At least it didn't work in my case. That is, disabling or deleting in AD didn't update the syslogins. I...