Hi guys,



I'm trying to do the above. I've looked at the sampledatainstaller and DatabaseMigratorClass info. Still have a few questions though.

1. Is it possible to install a database to a filegroup programmatically? IOW supply the value at runtime?

2. How can I select a database to apply a profile script to that's not in the drop down? Is it possible to change that value on the fly as well?

3. If I want to do a Grant EXEC on PPMUserSecurity_Delete to SOMEID in the script for stored procedures, is it possible to pass in the SOMEID value on the fly?



Thanks

Funny thing happened this evening on the way to the bathroom at Subways. I was thinking, you know, that wildcard value pre-filled in that field with the instructions next to it, probably takes care of the database naming issue. I tried it out, and then looking at the xml files for the Profilescripts I noticed that it reference the Database key, not the name, so I figured I bet that takes care of that too. It did! Later I got home and thought, let me reply to my message before they respond. Arghh!! too late.



Anyway, thanks (though I can't promise that later I won't have another question if I'm nowhere near the epiphany chamber.)



However, I got a little issue now. I have two databases in one profile. I added the wildcard to the filegroup for the first database. I left the filegroup for the second database blank, because it wouldn't let me put the wildcard in it. That worked for a while, but then suddenly the name of the last database I installed appeared in the 2nd database's filegroup. When I try to give the 2nd database the same wildcard value it won't let me. Neither will it let me leave it blank. What gives? Is there a "wilcard" type of way to force both tables in same filegroup using your interface?



Marcel