If there is any query can get if the SA password is empty or not ?

If I follow the below steps:
1. Right-click on the master database.
2. Select Properties from the popup menu.
3. Select the Permissions tab.

I appreciate if you provide me with a query that verifies that SA account
has no blank password.

Is there a way to Disable SQL server Authentication option in Studio and
force users to Windows Authentication only? Maybe a reg setting? I cannot
change the SQL Server configuration on this due to our application uses SQL
auth.

Where is flag that will control the enabled Ad Hoc remote queries, if its
enabled or disabled ?

Hi NG
I have a sinbgle named instance of SQL 2005 - SP2 (x64) running on a Windows
Server 2003 box.  Lately, my event log is getting clogged up with the
following error (at least every 60 seconds).

I am trying to simply make a group in AD, ie. MyDatabaseUsers and then
give that group access to the databases they need on the SQL-server
- and I can't get it to work!
Steps taken:

Where the SQL 2005 store the master database permission in registry or file
?and where is it ?

I need a query that verifies if Ad Hoc remote queries are enabled or disabled.

   I am trying to use cross-DB ownership chaining to restrict access to
certain rows of data.  The clients want to use Crystal to do ad-hoc
reporting and so I have created views (owned by DBO) in new reporting
DB's that access the base table (owned by DBO in prod DB) WHERE

In the past, I've granted access to database users via the
db_datareader fixed role (using SQL2005 here).  Now I have a few
tables which I only want admins to be able to access.  My hope was to
be able to run something like "deny select on object::dbo.tablename to

Please Where SQLAgentuserRole members stored on the SQL 2005 , and who I can
get them , not through Management studio , if you have a query or some thing
else ?

where the SQL 2005 store the permission assigned to the data base example
create table , create view ,….?

Which access rights are required for one user to be able to get results from
the following:
exec msdb..sp_help_job @job_name = 'TEST',@job_aspect = N'job';
the same user can get the list of jobs from:

Hi friends,
I don't know how to Choose between "Use the built-in system account" and
"use a domain user accout" when I installing SQL server 2005 under conpamy's
network.