If PHDwin crashes and gets stuck in single-user mode, use the following steps to switch it back to multi-user mode.

1.Close PHDwin and Eco Engine.

2.Open SQL Server Management studio if it is not already open.

3.Close any tabs/queries in SQL Management studio associated with the database you  need to fix.

4.Click on New Query.

5.Copy and Paste this text, replacing DatabaseName with the actual name of your PHDwin database:

alter database PHD_DatabaseName

set multi_user

with rollback immediate

6.Click Execute.

The proper settings for the database cursor is local. If it is set to global, unnecessary error handling may slow the database response. If a database seems to be slow, this setting should be checked because it can be overwritten by administrators.

To check the cursor settings:

1.Open SQL Server Management studio if it is not already open.

2.Expand Databases, right-click on the name of the database you need to check and click Properties.

3.On the Options page, find the setting for Default Cursor and change it to Local.

If the database is crashing each time you log in, but you CAN log in as another user, it may be necessary to delete your user record. Be careful when using this option, it will delete all private items that you have created. You may want to try deleting the view first (need instructions for this)

To delete the user record:

1.Open SQL Server Management studio if it is not already open.

2.Click on New Query.

3.Copy and Paste this text into the window that opens; replacing DatabaseName with the actual name of your PHDwin database and UserName with the login name you use for PHDwin:

use [Phd_DatabaseName]        

go

delete from PhdUser.Users

where Label = 'UserName'              

go

4.Click Execute.