I've been scouring knowledgebase and the web for information or examples of
securely accessing SQL Server.  I'm wondering if there are any guidelines
with implementation examples for using SQL Server in a secure and well
performing fashion.  The context that I am approaching this ...

I am planning to setup servers on the DMZ (published by ISA 2004).
The problem is this:
If I setup SQL servers in a cluster in the DMZ, I see that Microsoft Cluster
Services setup would require a domain account. That said it seems I would

Is there a security setting that ables users to view jobs and their status,
history, etc. but unable to execute them?

If I decide to place a SQL db in the DMZ so that the SQL-db-DMZ can retrieve
info from the SQL-db-internal-SAN, what would be best way to sync such
database from SQL-db-internal-SAN to the SQL-db-DMZ ?
I mean in the past I used robocopy tools to help me keep folders in sync

When I try to use the ODBC canonical ENCRYPT function for SP_SETAPPROLE, I
get an ODBC error when certain otherwise good characters are used in the
password. What characters are and are not allowed for passwords for
application roles while using the ENCRYPT function?

I have a pc set up with a System DSN to access my Sql Server. It is set up to
use NT Authentication according to the Login Name.
I have discovered that the User has full permissions to Select, Insert,
Update and delete records in any table. In Enterprise Manager this User is

Hello everybody!!
Do you know how to find out  the last login time for all acccounts  ?
please, to instruct for me.
thank you very much. :lol:

Regarding the aforementioned question I don't know if launching one script
in VB
and retrieving all the names is compulsory.
Is there any way or method for obtain that info via job/sp?

We have many views that are in one database and the underlying tables are in
a different database.  We had all of our data on one server and this worked
fine.  We now moved our data to a new server with a fairly new installation
of SQL Server, and our users cannot access the ...

My company.com main website (Win2003 Server, IIS6.0) pulls data from a SQL
database. The SQL database is currently housed in myMainSQL server (which is
SAN connected in the internal network).
I am working on a project now to place all web servers behind a

Hello everybody!!
Do you know how to create trigger on view? please, to instruct for me
thank you very much. :lol

           Can any one tell me the way to get the list of members available
in a particular database role? I need to get the list of roles available in
the database and the list of users available under each role.
           Can any one give me T-Sql statements to meet my ...

Not sure if this is an ASP.NET or a SQL issue...
Environment:
Webserver on Server1
SqlServer on Server 2

I don't see why my user cannot see a view when she can see the tables that
underlie it and has also been granted select permission on the view.
exec sp_grantlogin [OURDOMAIN\user99]
exec sp_grantdbaccess [OURDOMAIN\user99], 'SARAH'

I have a bunch of SQL servers (2000, and 7) that I inherited when I took over
as the DBA in my organisation. Due to decisions outside my control there are
a number of users that have been granted Domain Admin rights which
automatically grants them sa privileges to the SQL Servers ...