How can I specify the schema I want the table to be created in with
Enterprise Manager 2005?

It justs asks for a table name and if you put a schema name in it just
treats it as part of the table name

Hi Paul,

"Paul Hatcher" discussions.microsoft.com> schrieb im
Newsbeitrag news:4A37D2A1-9FEC-483E-846B-1C80B0AB635B@microsoft.com...

when your are in the diagram of SQL Server 2005 Management Studio, you can
open the Properties Window , View-Properties Window or . Highlight the
new table in the diagram, then the schema of the table is shown in the
Properties Windows. (The SelectBox in Properties Windiws has to show the
table "[Tbl] ... for this".)

Paul Hatcher (PaulHatcher@discussions.microsoft.com) writes:

CREATE TABLE schemaname.tbl

Let the graphic tools be. They are some funny toys that have ended up in
the wrong place. And, whatever, never use them to change your tables.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx