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
