also, only a login 'bob' can be made a dbowner or a user 'bobuser' mapped to that login can also be made a dbowner by using:

can this be done---sp_changedbowner...

dear ashish sir,

i created a login :

create login bob with password='bobpass'

i did not create any user for the above login

i logged into sql server using above credentials

then i entered...

THANK YOU VERY MUCH MR.AVINASHILY FOR YOUR REPLY

HELPED ME A LOT.

THANX A LOT

WOULD BE LOOKING FORWARD FOR MORE HELP FROM YOU.

THANX FOR THE GREAT FAVOR.

thanks a lot sir for your reply,

but when i uncheck the database and click ok, then it shows an error as :

Rename failed for user 'dbo' (Microsoft.SqlServer.Express.Smo)

An exception occurred while...

thank you sir,

ok can you tell me this much:

I CREATED A TABLE:

create table importdata.dbo.guesttable(guestname char(5))

I DENIED THE SELECT OPERATION ON THE ABOVE TABLE:

deny select on importdata.dbo.guesttable to guest

I EXECUTED THE...

dear sir,

i need to know the reason that why stored procedure is taking more time than simple query execution.

my query is:

insert into employeedetails values('amit')

insert into employeedetails values('amit')

insert into employeedetails values('stark')

insert...