>Hi,
>
>If i send this with SPT on MSQL:
>

>USE pub
>

>next send:
>
>

>USE Master; SELECT ?par  ; SELECT DB_NAME()
>

>
>VFP ask me par, i put 1.
>On MSQL Profiler i see:
>

>exec sp_executesql N'USE Master; SELECT @P1   ; SELECT DB_NAME()', N'@P1 int', 1
>

>
>Now i send on connection:
>

>SELECT DB_NAME()
>

>
>I get Master !!!!! why ?
>
>But if i send:
>

>USE pub
>

>and
>

>exec sp_executesql N'USE Master; SELECT @P1   ; SELECT DB_NAME()', N'@P1
>

>and
>

>SELECT DB_NAME()
>

>
>I get pub. I aspect this.
>
>Where is VFP trick ?
>
>Thanks

Fabio,
Are you sure second executed w/o any errors ? I actually expected it to return Master and after correcting the code I get Master.
Cetin