That's what we WERE doing, but now all groups will be on ONE domain, so that won't work. Perhaps you mean creating an NT Group for each Location?

I think I do, it was years ago. Not sure what you mean by connecting and then query over to sql?

When I run either of the scripts below, I find the table named jos_contact_Details, which is in the database named tctl_01.

EXEC sp_tables_ex 'MYSQL'

SELECT * FROM OPENQUERY

(MYSQL, 'SELECT * FROM INFORMATION_SCHEMA.TABLES')

When...

I'd try that, but cannot look at the table to find the columns, lol. It's a catch-22.

Thanks for your reply.

Unfortunately, I get another error:

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "MSDASQL" for linked server 'MYSQL'.

Could it...

Variable_name ...

I'm not sure what version of MYSQL it is, as it's coming from an external website.

I'm using the MySQL ODBC 5.1 driver.

KB, I"ll try your method and hope that works on 2000. I was hoping it would be that simple, but everything I found on researching it produced all kinds...

Our new domain does have the same user id's. However, I don't think I understand what you're saying about SQL. Updating the SID would fix the domain logins?...

I can't this to return anything for SQL 2000.