ok thanks.

that i'll do it..

thanks for reply

we have so many databases and also thousand of logins.

creating roles in each and every database and assign logins to that db is some what difficultly...

hi,

i am new to this company , previously no sql dba is there,

so they given like that sysadmin permissions.now i am try to disable that permissions.

end users having...

hi,

in old server the AWE is disabled, and also i run the rebuild and reorganize the index on that particular database only . remaining application databases working fine .

wht is...

thanks for u r valuable Suggestions.

i present company i don't have that much work. it's an bpo company.

simple checking backups and check for sizes of dbs.

i want to learn like...

thanks for reply .

it is suitable to generate script in production time in old server .

if we generate script the existing logins are there in old server or both in...

hi , if we run the script in the old server, existing logins or not

thanks for reply..

yes, Automaiton db is there in server 2005. i dont known y it shows error.

how can i copy entry logins thr dts