>Hi All,
> I this simple t-sql statement:
>
>
>Declare @Meet char(10),
> @cmd varchar(20)
>
>set @Meet = 'Meet152'
>Select @Cmd = 'Use ' + @Meet
>exec(@cmd)
>
>When I execute this in a query analyzer, it completes successfully, however this does not opens a Meet152 database.
>
> What am I doing wrong here?
>
>Thanks so much!!!

It does, but not in your current batchm becuase you use dynamic SQL it open Meet152 DB in separate batch, if you try:

Declare @Meet char(10),
        @cmd varchar(20)

set @Meet = 'Meet152'
Select @Cmd = 'Use ' + @Meet + '; SELECT * from SomeTableWhichIsInMeet152'
exec(@cmd)

You will get result set