I got the job of DBA handed to me since I talk DB2 on mainframes. Anyway we
have a SQL2K with maybe 12-14 users, using WinNT auth. to log on. We are
going to getting some data that only certain folks can see. We have 2
restricted tables in one of our databases right now and ...

Hi, im traying to connect to MSSQL 2005 server from Computer With Windows XP
Home with all patchs. Before I upgrade my sqlserver 7 to sql 2005 all works
fine.  I can connect to server shares without problems. Application uses OLE
DB provider.

We are creating a distributed app (VS 2005) which will ship with SQL server
express. The database will reside on the client environment and contain very
sensitive data. Is it possible to create an environment where this data will
not be available to anyone - except through the ...

I have secured our SQL 2000 server on a Windows 2003 server.
I deleted the builtin administrator as systemadminstrator.
Then changed to a new serviceaccount that is administrator on the machine.
It is a AD domain account.

Please help -- I created permissions for db users in SQL Enterprise
manager (and also tried using stored procedures in query anaylyzer).
However, the permissions do not work for other users using my access
project (.adp).

   I'm trying to execute a DTS package from a .NET service. The service is
running under a domain account that owns the job which it executes using
'sp_start_job'. The call to the sp succeeds however checking the Job history
gives: -

I am a newbie and i am trying to change authenication mode under enterprise
manager the sql server properties -> security tab to "SQl Server and Windows
NT" but as soon as i click on ok and close the properties it changes bak, to
Windows NT.

This is relating to SQL slammer question I posted.
We open 1 connection to SQL and we're
opening multiple recordsets, literally 1000s at a time. If you run it on the
server that is running SQL 2000 it's fine...but do this from a client PC then

When configuring ms sql to permit authentication from users over a
domain. Is it possible to poll from system tables like sysusers /
sysmembers / sysgroups / etc what active directory group's a specific
user is a member of once they are authenticated into a ms sql server?

I have a form with a subform on my Access Project and while test a Role I
found that unless I gave SELECT permission to the sysobject table a
particular subform would not display any data, actually it was a blank white
box where the subform should have been. The work around is to ...

I am reviewing SQL security on an existing server.  Can anyone think of a
reason why NT AUTHORITY\SYSTEM would be granted sysadmin permissions?
Thank you.

Server SQL 2000 SP4
In SQL manager the Kill Process option stay disable for the roles process
administrator ?
If we use command Kill in query Analyser no problem.

When creating a SQL Server2000 login (NT Authen) with read-only rights to
user tables in a user database, this very same login can:
1. Login into EM
2. Though cannot change any objects, but can

SQL 2000 SP4
In SQL manager the option Kill Process stay disable for roles process
administrator ?
If we use command Kill in query Analyser no problem.

Please help!
I've got a SQL Login (MyLogin) which allows a the user to ONLY access a
single database. The user is in the db_ddladmin, db_datareader, and
db_datawriter database roles to the single database which I'll call database