Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 object creation problem

Author  Topic 

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2009-05-15 : 02:37:32
when iam trying to create table for the user "HR1USER" using SA login the following error occurs:

The specified schema name "hr1user" either does not exist or you do not have permission to use it.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-15 : 04:03:14
Have you created the schema hr1user?

CREATE SCHEMA hr1user
GO
CREATE TABLE hr1user.MyTableNameHere



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -