I have an application I am supporting that requires them to have Admin access
on the SQL 2k5 db for that id to reset users passwords. I was hoping to
create a group in the application and set that group up with their defined
roles to have our help desk reset users passwords as ...

I've recently had a request to create a user with "Create/Alter/Drop tables"
access to a database.  This will be a service account used from a web server.
"Grant Create Table to <user>" was straight forward.
And while I can find a way to grant alter permissions (which looks like it ...

All on SQL 2005 :
I mapped a SQL login (test) on SQL Server (SQL1) to a remote windows
domain user (mydomain\me) on a linked server (SQL2). Here's the SQL
for reference:

In my company, we are using SQL Server 2005 and should move soon some
of our applications to SQL Server 2008.
In production environment, there is some extremely sensitive data that
only authorized people should be able to access. How can we easily

First of all I have no idea about SQL, however, I have one customer which is
using SQL 2005 for an ERP application.  I have setup a user for this SQL
server by manual from the company who implemented the ERP software.  The user
could logon no problem but all of sudden he cannot ...

Hi all,
Is there is any way I can capture the SQL tried to execute by failed logins?
We have some unusual failed logins and hard to findout which part of the
application is failing. If I can capture the SQL behind it.. ITS EASY!!

We were running services under a  single service account such as
prod\svc_sqlagent.
We recently started having multiple instances per host and decided to have a
service account per instance, as in prod\svc_sql_inst01, prod\svc_sql_inst02

Is is possible to set security on MS SQL, so that the database will only
accept requests from known IP address or hostnames such as a Web Server ?
I have set up Kerebros authentication via SPNs, so domain users accessing a
Web Application can use trusted connections to access the ...

I am concered that connections from an application that include usernames
and passwords in their connection strings, could be compromised by analysing
the connection traffic, and have the password revealed.
However I came across this statement here

I need to stop users from doing backup log commands to truncate the logs when
they fill up.  I was testing and wrote this script:
revoke backup log from BillyTest
Where BillyTest is my user.  BillyTest has DBO rights to the database in

I have an application that should run for all users, I am connecting to SQL
Server 2008 Express throught this application. Some thing uncommon with this
application is that user create databases as he need because of the Sql
server expresses limitation with the memory. Say user ...

Transfering logins from SQL 2000 box to a new SQL Server 2008 box.
I followed the instructions here
http://support.microsoft.com/kb/246133
The windows accounts work fine and the script works like a champ.

I'm creating a login and user, and I want to be able to grant read-only
(e.g. SELECT) access to the dbo schema objects only. I think I can do this
from the Securables window and selecting each one in turn, but I really hope
there is a way of doing it on the schema itself, so that ...

Environments: Win XP Pro SP2 – Dell Dimension 4700, Pentium 4, CPU 2.80GHZ,
512 MB RAM, Hard Drive Free space: 45GB
After completely uninstalling ALL instances of SQL server 2005 and rebooting
the system, I tried to install SQL Server 2008 Express. The installation

We are in a discussion to understand the difference between the NT
AUTHORITY\System vs NT AUTHORITY\NetworkService accounts.
What is the purpose of both these accounts?
From Florin's blog