I am auditing an application using SQL Server  as a back end. If I
replace  forward slash  "/"  in a textual field whose value is connected to a
query with a where clause. It displays all the records from the database. I
want to know if forward slash "/" can affect the ...

I migrated a SQL 2005 db from our development server to our QA server. I created a new ID for the application to use on the QA SQL server. The problem I'm facing is, I can't connect using the ID I created or even the ID that was already in the db on the test server. I did a ...

I have some users on a SQL 2005 box that connect via SQL Authentication with
password policy enforcement.  If their password expires, they can try to
connect via Management Studio, and they will be prompted to change their
password.

Can users trusted with data_reader and data_writer through a Windows Group to a database, in addition be granted execute priviledge on any stored procedures in that database, or can they only be granted through the stored procedures properties permissions?
thanks,

Hi all expert,
I have create a logins called dbadmin
in what way can i restrict the logins to be able to access to a certain
database, or even certain tables inside database?

in sql server is it possible to get the amount of memory used by a stored
procedure? e.g. memory usage statistics per stored procedure?

Using SQL2K SP4, I'm getting a weird error when I run a stored
procedure from a remote server:
exec remoteserver.database.dbo.proc
returns:

I need to find out which are the System generated list of accounts and what
all permissions are granted to these login in the PROD DB .
Also what roles are assigned to which accounts
Regards

When I attempt to select this audit class in profiler, it is not even
listed. When I try to create a trace programatically (i.e.
sp_trace_setevent, etc), for this event only (event id = 154 as per BOL), I
get the error "'Msg 19053, Level 16, State 1, Procedure sp_trace_setevent,

My sa password was changed by some one or something. I am aware that I
can audit logins and logouts, but is there a way to audit when a password is
changed?
I would love to know how the password was changed over the weekend,

We are running SQL Server 2005 enterprise with SP2.  Recently, after
assigning db_ddladmin permissions to someone, I ran across something that I'm
curious about.  It seems that as a db_ddladmin of a database in the dbo
schema, it's possible to create and drop objects, but not ...

I'm attempting to script DB Level security (roles and object level perms)  on
a Development DB so that I can re-apply it after I restore the DB from
another (Production) server.  I have done this many times on SQL2000, but
have not been able to find a way to accomplish it with ...

I'm not sure if this is the right ng for this question, but here goes...
I just installed a product that uses SQL Express.  When I run queries
against the installed instance I get different behavior depending on if the
query is run from Management Studio locally or from SSMS ...

I have developed a java based Web application that is using SQL Server 2005
as its back-end. Below is the sample case of using the system:
Many users access the site and the site gives them ability to register.
There are two types of users ,  admins and users. Both types can read ...

We're trying to lock down our environments (dev, qa, uat). One requirement
is that a group needs to not be an admin but still be able to execute any
job. I've looked and looked, but I haven't yet been able to find a good
resource for job execution permissions. I know that a job ...