How can I rename a user-created SYSUSERS table?

Question

Someone renamed our Users table to SYSUsers, which is a key sql table name. Is there a way to rename this table?

I've tried right-clicking the table and going to rename, and running sp_RENAME on it, but both are trying to rename the system sysusers table instead of the user-created one. I can't even select or export data from the [MyDatabase].[dbo].[SYSUsers] since it reads from the sql server sysusers table instead of the user-created one.

We're using SQL Server 2005.

Answer 1

SYSUsers doesn't cause any such problem for me because I work on a case sensitive instance (however creating a table called sysusers does!).

Perhaps you could try temporarily altering the collation of the database to a CS one and switch it back after?