Hello,

NT AUTHORITY\NETWORK SERVICE - Security Admin and DB Creator

NT AUTHORITY\SYSTEM - Sysadmin

my jobs are running trough DBAdmin (running SQLAgent), if remove the access will it affect the jobs

Hi Anthony.green,

Thanks for your reply.

What about this users listed below, why they require access to SQLserver/databases. what is the impact if i remove the access from SQL server?.

NT AUTHORITY\NETWORK SERVICE

NT...

can i remove DBAAdmin which starts SQL server, SQL Agent, Analysis services, Fulltext Search and browser

ClusterAdmin which starts cluster services.

what is the impact i i remove the below mentioned...

our top mangement asked me to remove access of IT server team.

they have most of the user's password so they might access the data but i have to restrict the...

anthony.green,

The drives that you proposing can i know it deeply, we have a virtual server and base configuration i dont have if i ask them to add a drive, what...

when a maintanence plan is available why are you using this query.?

if the table grows the statistics will grow is it right then in that case the query has to...

There is a posiblity they may have enabled secured SSL connection in SMTP.

check this as well.

thanks for information about clustering.

can you give some link or doc on virtual terchnologies.

As far as i know is they are using HP technology to sertup serveral virtual servers on...

current deploying the archive stratergy in some tables and making the changes in report as i am moving it to different DB. this is an activity monitor table.

As i have...

PaulB-TheOneAndOnly (5/1/2012)

May I ask what are you trying to accomplish by partitioning...

Hi aakash,

i to want to create partition as the data in some tables are more that 50 Lakhs.

i was about to create partition but dropped it due to parition to...

another question if i atleast want to block their select and update access is it possible.

can we track DDL, DML statment updation directly on DB with user name and time(should...

can i add individual accounts in sql and block there access will this work.

If i have the service login though which the SQL service is running with that i can...

Thanks all

That makes me much clear

Do we have to check XACT_STATE() on catch

If it comes to catch wont that be definitely error.