It sounds as though tempdb is in single user mode. To verify this, run
sp_helpdb tempdb. The "status" column in the output will tell you if
tempdb really is in single user mode. If it is, you can fix this by
running "sp_dboption tempdb, 'single user', false" Hopefully, that will
fix you up.
If it's in production, it's out of date.
> I am using SQL Server v.6 run on Windows NT 3.51 server without any
> pack. Now I got a error message "Database tempdb is already open and can
> only have one user a time."
> I have try start up the server use single user mode but it still doesn't
> work. Nobody can access the server now. Can any one help ?
> Thanks !