BAM: don't use spaces in view names!

Posted Tuesday, August 15, 2006 4:02 PM by Jean-Paul Smit

if you're familiair with BAM in BizTalk 2004, it is easy to notice the changes between 2004 and 2006 while setting up a BAM environment in BizTalk 2006.

Changes can be found for example when defining the activities and views. Besides textual changes (on for example buttons) I found out that it is no longer prohibited to use spaces in the names of activities and views. I thought that was a nice improvement to increase readibility.

I still feel that way, but it turned out not to be so handy when you want to remove the views with the BM tool. When you try to remove a view with a space in the name, it gently informs you that such a view doesn't exist! In the BM tool in 2004 it was also possible to remove deployments based on a number, but in 2006 that is no longer the case. Strangely you can view the changes but not remove them anymore.

I tried to remove the views using the stored procedures in the BAMPrimaryImport but I couldn't find an SP to remove the view. I did find one to remove an activity, but there seem to be none for views.

Finally I decided to remove tables, views and so from the database. Obviously that isn't a nice way to solve it.

Does anyone know how to remove a view with a space in its name?

Filed under: