That rocks:-D

only i'd missed the statement

execute as user='masterpiece't

our lecturer never said anything about such a kind of stuff:angry:

anyway

thx u all guys helped me(':-D');

hi dude i'm a newby for roles,it's little bit hard to understand, would you have any suitable tutorial links for a newby

masterpiecebeta2 (3/5/2010)

---

create login qwe with password='BigL0ngp@ssword'

create user masterpiece for login qwe

go

create schema schema1

go

alter user masterpiece with default_schema=schema1

go

create table schema1.paramore1(a int,b int)

go

create role doctor1

sp_addrolemember doctor,masterpiece

revoke insert ,update on schema1.paramore1 to doctor

go

now...

i just try wat u send to me but unfortunately still it's inserting the values

its really infuriating

anyway thanks for your vital contribution

its Microsoft SqlServer Management Studio 2005

hey pal the user is= masterpiece

i started new project with user masterpiece2 still got the problem

this is the sequenece that i used in management studio express sql 2005

create database asa

use...

I just want to check the existing schemas inside the sql server 2005

oh i understood

Artist_ID would'n implicitly get into the Table Band

thank u very much

sorry pal i just misplaced it

alter table Band add Constraint fk_Band Foreign key(Artist_ID) references Artist(Artist_ID)

thx before dude now i hava another problem

The Foreign key constraint cannot be created

go

create...

thx dude

What a stupid question that was

Thanks all you guys