I am having a technical problem.  I wrote a C# Command line program Visual
Studio 2005 that will read Active Directory information and will write the
results to a SQL Server 2005 database.  The program runs fine when I run it
from the Command Prompt but if I run this program from ...

Is it possible to duplicate or copy a user? Example, I want to add another
user to the database and I want them to have the same rights as a user
already in the database without having to manually re-assign all the rights?
Thanks

We are using SQL Express and I have a problem with dbo.
On my machine if I logon to SQL Express using windows authentication
and create a new database I automatically have db_owner role membership
on the new database.

I am planning to migrate the WSUS database from a Windows Internal
Database instance to a SQL Server 2005 instance on a remote server.
http://technet2.microsoft.com/windowsserver/en/library/b4852133-5ed3-48d7-8a95-e
7866e638c181033.mspx?mfr=true
The FE machine account should be ...

Hi Group,
As part of best practices we would like to change the default port number
that SQL Server 2000 listens on.
Once this has been done, can the application client dynamically determine

I want to prevent windows users from accessing my database on SQL server
express 2005
I don't want users to be able to login with SSME on Windows authentication,
only by SQl Server Authentication and only on the sa and another specific

I've been bashing my head against this one all day:
We have a MS T-SQL 2005 database with ~12 tables and ~45 stored
procedures (all created and owned by myself under a dbo account).
The access front end calls these stored procedures and everything

Hello All, we are looking at the security options that we have available to
us and we are trying to generate some different ideas on how people are
handling this.  We want to know how people are designating security based on
different types of scenario's... We have one that needs ...

I'm getting the following error when I try to access any of the objects in
my SQL Server database:
Error 229:  SELECT permission denied on object 'sysfiles', database
'Seviper', owner 'dbo'.

I need to configure my firewall to allow remote scripting on my SQL 2000 DB.  
Which udp and tcp ports do I need to open?

Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?

We are having to implement restrictive security permissions on SQL, some of
which requires that we audit and log any access of any kind for specific
tables and columns. What would be the best way to do this? We can use
triggers to log any changes to specific tables and columns, ...

How could I query a SQL Server 2005 dataserver instance  through my
Java Program if it is running in SSL mode or not  ?
I am using a third party JDBC driver to esatblish SSL connection with
a MS SQL SERVER 2K5 dataserver but my connection

Can someone please help me with creating a user just to execute store
procedure and nothing else.
What explicit permission I need to give. I am trying to deny all permission
and then just grant Execute (I also tried to grant connect and select) and

IF I check both CHECK_POLICY and CHECK_EXPIRATION on in sql2005. It will
enable sql logins to use WINdows2003 AD password policy?
If AD configured case sensitive. Sql logins will be case sensitive as well
even sql2002 sort order is 52.