Re: Trying to move SBSMontoring
Tech-Archive recommends: Fix windows errors by optimizing your registry
Have you tried to stop the service using services.msc?
On Tue, 4 Mar 2008 07:32:46 -0600, "wedor"
<mwedor@xxxxxxxxxxxxxxxxxxx> wrote:
I am following the article about moving databases but when I execute the
commands I get an error that the database is in use and cannot be detached.
The Server Management Console is closed.
What am I overlooking?
.
Relevant Pages
- Re: List Users Permissions down to table.column action
... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ... (microsoft.public.sqlserver.security) - RE: copy permissions from one user to another?
... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ... (microsoft.public.sqlserver.security) - Re: copy permissions from one user to another?
... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ... (microsoft.public.sqlserver.security) - Re: Cannot pass NULL to SelectParameters?
... out which order to load in is very useful.If your database is not finished, ... commands, but falls apart in too many instances. ... IDENTITY to INSERT without the primary key and let it autogen. ... My TCATEGORY table does have one row where TCATEGORYPARENTID is null ... (microsoft.public.dotnet.framework.adonet) - RE: List Users Permissions down to table.column action
... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ... (microsoft.public.sqlserver.security) |
|