sql server programming: I need a query to put the database into a single user
mode. I tried this there was an error near SET.

Alter Database [Goldmine_Sales_and_marketing] SET
Single_User with rollback immediate

Hi,

[quoted text, click to view]
ALTER DATABASE permissions default to members of the sysadmin and dbcreator
fixed server roles, and to members of the db_owner fixed database roles.

you have permissions, TRY OLD STYLE
EXEC sp_dboption 'Goldmine_Sales_and_marketing', 'single user', 'TRUE'

-------
SHINICHI YONEDA MXL04371@nifty.ne.jp
Microsoft Most Valuable Professional
MVP for SQL Server 2002-2003

[quoted text, click to view]