hi Dugi,

Thanks buddy

i added to datawriter role and now drop permission is denied.

One more question?

When i tried to create table ,i am getting following error

Msg 2760, Level 16, State 1,...

Hi steve

do u have any idea

hi dugi

one problem delete permission is restricted but the testuser can drop the table

any idea how to fix this issue?

Hi dugi,

Thanks for the reply

now u have restricted for delete same way can i restrict for drop permission also right

use Database

go

deny drop to user

Thanks,

Anjan

Steve thanks for the reply, but the same code has been implemented in others servers also.

The code contiains the ansi padding setting before the create trigger line.

Same thing has been...

Hi,

running under admin account only

hi,

if some other databases already exists in the new server then

u can restore the database and create the role and in the security logins already user mapping might have done...

Hi,

have u made changes in webconfig file through which application works

just check the server name,usr name ,password and database.

it may work chekc this.;)

As per book online steps

we should go to db-> table->right clk and select full text index option,but here full text index option is not highlighted i,e we can't select...

hi murali,

i ran the query

select spid,loginame,program_name,hostname from master..sysprocesses

where dbid = db_id(' '

no body is connected

but still i am getting the error wat to do?pls help

May be the backup job is scheduled in remote machine check it and

if they are using 3rd party tool vertias backup then u can make the presence of this...

I restarted the sql service by still it was giving error.

For time being i can restore the database.

so any idea how to overcome this.

After creating user

assign db_owner right using sql management studio by using sa login

no need of script its easy

just double click on logins-> click on concerned user and change the permission.

😉

gila,

recent error is

Operating system error 32(The process cannot access the file because used by another proccess),

occurred while creating or opening file 'G:\mydb.ldf'

tell me wat to do

Recovery pending error is for user database only.

User db is not detecting at all.

Yesterday there was server shutdown and restarted by admin people.

so wat can be the reason

Log files are...