[ask] sql server 2005 (cendol inside)

[PHPmaster]

case solved






melon buat yg bisa jwb duluan+bener ya gan soalnya melon terbatas neh :ganteng:



gan, ane lg nyoba2 sql, pk sql server express edition 2005 (os win 7)

pas bikin tabel gini(sblmnya tabel ini blm pernah di create)




Quote:





CREATE TABLE MsEmployee(

EmployeeCode char(5) PRIMARY KEY,

EmployeeName varchar(50),

EmployeeAddress varchar(50),

EmployeePhone varchar(12),

EmployeeSalary numeric,

constraint k1 check(len(EmployeeCode)=5),

constraint k2 check(EmployeeCode like 'KK[0-9][0-9][0-9]'),

constraint k3 check(len(EmployeePhone)>=10),

constraint k4 check(isNumeric(EmployeePhone)=1)

)





pas di execute kok kluar error kayak gini ya??




Quote:





Msg 262, Level 14, State 1, Line 1

CREATE TABLE permission denied in database 'master'.







</div>