Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

1.7k questions

3.2k answers

401 users

Categories

1.7k questions

3.2k answers

401 users

I once created a batch type spec and then tried to unload it. As the Loadspec tool cannot unload batch type specs I tried to do it manually. I tried to delete and drop the following rows and table to do it but still could not drop the staging table and batchtype spec. I executed the commands from the bottom. Any help with this would be appreciated.

drop table USR_BATCHITEMADD
drop table dbo.USR_BATCHITEMADDBATCHSYSTEMMESSAGES
drop table dbo.USR_BATCHITEMADDAUDIT
drop view dbo.USR_BATCHITEMADDBATCHSYSTEMMESSAGE
drop table dbo.USR_BATCHITEMADDBATCHSYSTEMMESSAGESAUDIT
drop table dbo.USR_BATCHITEMADDBATCHUSERMESSAGE
drop table dbo.USR_BATCHITEMADDBATCHUSERMESSAGEAUDIT
delete from BATCHTYPECATALOG where ID='5AD654F2-D64D-4F35-86DC-4742AB93FE5E'
delete from dbo.BATCHUSERSETTINGS where BATCHTYPECATALOGID='5AD654F2-D64D-4F35-86DC-4742AB93FE5E'
delete from dbo.BATCHTEMPLATE where BATCHTYPECATALOGID='5AD654F2-D64D-4F35-86DC-4742AB93FE5E'

delete from dbo.BATCH where BATCHTEMPLATEID='135A9402-E783-42DD-BCC7-5EE9DEECD393'

asked by kayes (110 points)

Please log in or register to answer this question.

...