new to SQL - create table command question

hi

can someone please explain the following please

why does this fail with specified owner testdb does not exist or you do not have permissions

create testdb.testtable (

testval int

)

yet if i create testdb and then run the following against this new db

create testtable (

testval int

)

command command completes successfully......what am i not understanding or doing wrong?

thank you

oooops....sorry

im so new i cant even type the command correctly

this command fails....

create table testdb.testtable (

testval int

)

this command works....

create table testtable (

testval int

)

|||Depending on the version of SQL Server you are using, the prefix testdb indicates either the owner of the table or the schema name that the object / table will be stored in. it does not identify the database where the object has to be created in. For the database identifier you will have to you the three partname which would be (assuming that you want to store the object in the users default schema (for SQL 2k5) or within his owner "schema":

CREATE TABLE testdb..SomeTable
(SomeColumn int)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

New to Clustering - 2003 Server Enterprise & SQL 2000

I am new to clustering and would like to implement and active/active SQL
cluster, which would allow the functions of one of the nodes to fail over to
the other in the event of a problem.
I have two identrical servers in terms of hardware connected to a SAN and
running Windows Server 2003 Enterprise and will be using SQL 2000.
What are the steps for setting this up?
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
> to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?
1. Attend training to support your extremely expensive cluster with
extremely important databases.
2. Build your cluster
3. Install SQL on your cluster
http://support.microsoft.com/Default.aspx?kbid=243218
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||What do "you" mean by Active/Active? In a clustered configuration, you
install SQL Server to all participating nodes, but then a virtual server is
hosted by only one of them at any given time. If, however, one of the nodes
becomes unavailable, one of the other nodes can host the resources.
Active/Active on Microsoft Clustering means you have multiple cluster
resource groups (i.e., virtual servers) running at the same time with
multiple nodes all hosting different resources.
Anthony Thomas

"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?