Hi. We are creating a new app in wich we need to know if the user is member
of at least one of as list of AD groups. The user network login name is
provided to one stored procedure then it needs to query the AD to verify if
the string containing the user name is member of a list ...

Hi NG,
How can I display with a T-SQL Statement, which permissions are granted /
assigned to a sql server user in sql server 2005?
Thx

SQL 2K5 SP1
Would this be the appropriate way to move maintenance plans from one server
to another?  I have a tool that will sync the data in the tables between
servers for me, would this be sufficient?  Are there any pitfalls between

Hi;
We have a program (ASP.NET) that requires a database as it's back end. We
are trying to create an install that requires as little expertise as
possible. In other words, no DBA required.

I have spent the best part of 4 days trying to connect to SQL 2005
express from an winforms app! Yes , I have checked surface config and
TCP/IP blah blah ...
I have trawled the net and spent countless hours on MSDN and many have

a user wishes me to create a new SQL database for him, on a SQL2K server.
He is the only person who will use this database, and requires admin rights
to it from his desktop.
What is the best way of securing the SQL box so he cannot screw up other

I have a database that I have created. Currently, I am the only user of
this database. I connect as 'sa'.
Now, I need to move it to a new Company Server.
The logic in the Stored Procedures in my proprietary and I don't want

This is a really weird one, I'll try and explain as best I can!
Scenario(names are not the real ones BTW) -
RES - resource domain
AD - active directory

Hi I am trying to create a text file from sql server this wil be the basis
for a service I have written that monitors for the change/creation of a text
file.
I have set the proxy account in SQL server agent.  I have realised that

XP Home, limited user account. Newbie to this group - I know next to
nothing about ports but am an experienced computer user otherwise.
Can anyone interpret this for me - just started to get these recently -
this is only the second one. Got it while using a user account in my XP

we have a Server
- with w2k3 and
- SQL 2000
- as a member of a Domain

I was able to register our new SQL server (S1) using 'sa'. But when I linked
it to another server (S2), I cannot see any tables in that server. I got
Error 17: SQL server does not exist or access denied. I deleted the default
Remote server and now when I tried to create a new one ...

I am new to this newsgroup so please forgive me if I am in the wrong
palce.
The subject line describes my problem in a nutshell.
I am getting and event id 17055 from one instance of our SQL Server

I need some help with a logic for a important document I need to create. Its
regarding my Backup procedures that require me to test my database backups
every 3 months. The problem occurs that I do not have another server to test
out the database. So my solution was the following:

I'm trying to restore a database that existed in SQL Server 2000 to SQL
Server 2005 Express edition and I keep getting the following error:
System.Data.SqlClient.SqlError: Directory lookup for the file (name of the
file) failed with the operating system error 5(Access is denied.). ...