lunes, mayo 05, 2008

Sql Server 2005 Restricted User

This is a option from access to database that it can throw the error : "Lock request time out period exceeded". To resolve this problem, you have execute the next code in your Sql Server Management.

Code:
ALTER DATABASE  SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE SET MULTI_USER
GO