"Ibrahim Mesbah" wrote:

>  I have been reading about SQLExpress User Instances.  I deployed a C# app
> that uses sqlexpress' user instance functionality.  I need to deploy an
> upgrade with a fix to certain stored procs..
>
> I figure I could use sseutil or sqlcmd to run a .sql script upgrade file
> that has a lot of t-sql in it.  Modifying stored procs, schema (adding
> tables), etc. etc.
>
> What is the best way to do this?  Ideally I'd like to use a Custom action,
> call sqlcmd and pass it the mdf file (installed by setup if not there) along
> with my script file (.sql).  Any help would be very very appreciated.
>
> The only way I can see to pass in a script/command file using user instances
> is in the console mode, which doesn't seem to run...
>
> Thanks in advance!!