box # 1 : SQL Server 2005 Developer Edition , mixed-mode , logged-in as
Windows log-in account ( BUILTIN\Administrators ) :
create a .bak file
box # 2 : SQL Server 2005 Express Edition , Windows authentication mode ,

I want to validate whether a user has been added to a particular database
role.  I cannot use the is_member function since it only works with the
current user.

Ok,
im sure this has been dealt with before but when i read other posts i
kinda get lost in the jargon. Ok the reason for my being here is that
i developed a website that recently got hit by a sql injection attack.

I am trying to connect from ServerA to ServerB using linked server.
Below is the setup script, but it's the basic linked server (RPC is
on, Data Access is on, use login's permissions).
Doing "test connection" works, and if I open catalogs I see all the

I am trying to get and understanding of the security with SQL and GP.  
Unfortunately, I know alot about GP but virtually nothing of SQL.  Our IT
person handles the SQL side.  The confusion I am running into with with some
of these new tools with GP10 there are rights you have to ...

We have an sql 2k5 box setup in windows authentication. Users are all
defined in pur global company domain.
Is it possbile to create a external webapp, with login and password inputs
and then use these inputs to login to the sql server database using the sql

I am working on a vb.net app that connects to a SQL Server 2005 database.  
The app uses "Trusted Connection" to connect to the db and no userid/password
is passed.  I am a member of a security group called "Developers".  Up until
last week, when I updated a row in a database ...

Hi All: I had a standalone 2003 server sp2 in a domain running IIS/SQL2005,
and I decided to promote it to a DC without doing too much research. After
promotion/reboot, SQL did not start and I saw pretty quickly that it had
been running under a local account that no longer ...

1. I have many windows users, for whom access has been given for individual
domain accounts (SQL2K5)
2. All of them are also a part of a windows group which has required access
3. I want to remove the individual domain logins (because a group is already

My scenario is:  I have a subscriber database that does not change often,
except for transactional replication.  I am presently tracking who, when and
what table is being changed from a trigger.  What I would also like to do is
track what exactly is being changed.  Now, I've thought ...

I have recently migrated from sql server 2000 to 2005.
One of my old jobs is currenty failing with
Msg 15157, Sev 11, State 1: Setuser failed because of one of the
following reasons: the database principal 'sa' does not exist, its

I have a problem with SQL Server 2005. The application (written in
VB.NET) connects to SQL Server 2005 using Windows Authentication. When
a user's domain account had been locked out, the user - after it has
been made active again - cannot connect to the DB (with a message

i am trying to find out using T-SQL if a domain user has sysdmin permssions.
i can use IS_SRVROLEMEMEBR, but if the user is not a login and directly
under the sysadmin role, this function will not help.
i need to know even if one of the domain or local groups the user is member

I don't know if this is the right newsgroup for this, but....
We need to secure records in a table based on Active Directory
permissions.  Can someone point me to a good resource (with examples)
of how to go about this?  Here is some pseudo-code of what I'd like to

I am searching for the best way to log all logins using sysadmin users. I
want to record the time, username, hostname and application-name. There are
to many users with sysadmin rights and I need some for info from the system
before changing that. I am running SQL 2005 SP2.