SQL 2005 on windows 2003
When try to detach a database I get the error message that it cannot be detached because it's used for replication.
Under replication There are no replications or publications specified.
I have found a few places that suggest running this:
But it also says this which makes me cautious::
"This will remove all replication objects in the database"
Does this refer to the SQL server objects that control replication or my data?
It may be overly cautious or literal to think that this may mean the tables in my database
that were marked for replication when I had a failed attempted to set up replication,
but the language is ambiguous. Plus I found reference some other guy wrote
that said something about it deleting his database, and "good thing I had a backup"
I tried to disable replication from mamagement studio, the wizard at the end tells me that it can't because
"the distributor has not been installed correctly"
What does this procedure "sp_removedbreplication" really do ?
I need to free up this database to detach and move it.
I need to get this done today of possible