homebrew01 - the db came from another server but i already checked there is no SID mistmatch.

thanks suneel kamavaram for the script and many thanks to Sean Lange.

Issue resolved by...

Dear Sean,

from the very beginning i am trying to understand "how to check that any user or domain group have deny connection to the database?"

and i guess its not limited...

Sean,

this user probably be a member of multiple groups(domain group) that i will check with windows team.

but how can i check at SQL level that any groups "have deny connect...

Dear Sean,

thanks for your quick response, after checking a lot on google i asked my question here when i didn't get any appropriate solution.

Please can you help checking "The...

Yes SQL Express would be the best choice for this purpose.

feel free to ask if any further details required.

Thanks Perry for the response.

1. But what the Microsoft best practice says about this.

2. If we consider from security point of view - SQL server should be on domain or...

Dear Friend,

No of DBs, Servers and database size always depends on the environment you are working. There is no fix size of databases or servers.

One DBA can manage one server...

why don’t you recycle SQL error log by exec sp_cycle_errorlog.

SQL will recycle the log and the physical log file will be inactive (it can be deleted).

my recommendation would be .....recycle...

Thanks all for your valuable inputs.

As per "The front end must protect the database from injection if you're not letting the database protect itself by disallowing the process in the...

Thanks Craig for reply but it doent meet my requirement i have couple of users in one group which require permission on a particular job to stop/disable/start and enable this...

Thanks GSquared for your reply. But for this i need to create a group at domain level if I am not mistaken.

Alex you didn't understand...the code I have mentioned (posted by me initially) working perfectly fine. The only issue is that I cant use (means I don’t want to use) openrowset....

Thanks Adiga and Alex for your response, Adiga that script is good but not solving my purpose 🙁 .

Alex there must be some way to get a value from sp_help_job...

But i have seen some sites showing its possible:

WHERE type IN ('P', 'V', 'FN', 'TR', 'IF', 'TF', 'U')

/*

Included Object Types are:

P - Stored Procedure ...

Yes, this can also be a good approach. But in any case users will be kicked off for a while.

But in this case the downtime would be minimum

thanks,

DG