Actually, I just found it.

I added

USE db_bmdata
GO

to the top.




>Kevin,
>
>It is definitly taking some getting used to.
>
>I just ran this SQL:
>
>

>
>IF OBJECT_ID ('Clients') IS NOT NULL
>	BEGIN
>		DROP TABLE Clients
>	END
>
>CREATE TABLE Clients
>	(Rec_Id			INTEGER IDENTITY PRIMARY KEY NOT NULL,
>	 ClientName		VARCHAR(40) NOT NULL)
>
>
>

>
>Yes, I do not see the table listed in the object explorer. Where is my table?
>
>And, how do I ensure that the table is being created in the correct database?
>
>
>
>
>
>
>
>
>
>
>>I found it. Thanks!
>>
>>Glad you found it.
>>
>>Management Studio takes some getting used to, but in the end you should like it.
>>
>>By the way, if you want a nice overview of all the new features in SQL 2005, you might want to check this out: (author is the technical editor for SQL Server Magazine)
>>
>>http://www.amazon.com/gp/product/0072227761/sr=1-9/qid=1153722872/ref=sr_1_9/104-6217512-7451143?ie=UTF8&s=books
>>
>>Kevin