on 2007 Sep 07 11:38 AM
Hello Experts,
We have created multiple company databased to test certain functionalities. Now we have to delete the unwanted databases. I have observed that deleting databases from B1 screens is not possible.
What is the procedure to carry out this activity? Are there any dependencies?
Thanks in advance
With Regards,
Kaatss
hi kaatss,
close your SAP B1.
in SQL 2000
-
1. Start =>Programs => MicrosoftSQL server =>Enterprize manager
2. Click on Database options.
3. Select the database you need to delete.
4. Right click and delete the database.
in SQL 2005
1. Start =>Programs => Microsoft SQL Server 2005 =>SQL Server Management Studio Express.
2. Click on Database options.
3. Select the database you need to delete.
4. Right click and delete the database.
then
Open your SAP B1
Administration => choose Company
Press the refresh button.
you can see the deleted database and company will be removed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.