I have an odd situation.  Here are the details:
- I have three databases (A, B, C).
- I have a user that has EXECUTE and SELECT permissions on each
database.

First let me say that I my computer is in a domain.  The DC + my computer
both have strong password policy in effect and an account lockout threashold.
I have SQL 2005 express installed (mixed mode).  I've created a new user and
pointed it to a test DB I have.  Gave the user ...

I've just looked over
http://www.windowsecurity.com/articles/Secure-Installation-Microsoft-SQL-Server-
2000.html
which seems to be a pretty good document.  The problem is it references SP3.
Should I follow this guide, and then install SP4?

hello eveybody,
I have an Sql server 2000 installed with several databases.
this instance is configured with both sql server identification and
Windows ID

Hi ,
I need to replace the existing database with the new database but keep all
users.
How can I transfer the users to the new database ?

I need to configure appox 50+ servers for monitoring in Enterprise Admin for
group of AD users. I created AD group and added users in group. But when I
try to register server it gives error as "Login Failed". As per my knowledge
we need to assign the AD group to login to SQL ...

I'm not using SSL.  I'm wondering if when using a SQL Server account, when I
send my login credentials to SQL Server, is the password in transit encrypted
automatically?  
I understand that using trusted connections is the best way, but not all of

Hi, I'm in the process of migrating / decommissioning a series of SQL
servers.
Is there / are there any tools to sniff out any existing eroneous SQL
databases which people may have created by themselves?

I'm trying to finalize my service account standards for SQL Server 2000 and
2005.   Here is what I have.  Does anyone have comments on these standards:
Standards for setting up SQL Server service accounts:
·        Set up a different domain account for each service if network

We have two sql servers using Windows authentication. One is sql 2000 the
other sql 2005. When logged in as "sa", I can link these servers and run a
SELECT distributed query without any problem.
But when one of our developers runs the same query (he is "dbo" of each

On one of our SQL Server 2000 machines, I've created a SQL server account
using an Active X directory account.  I did this by adding a new login,
navigating to the Active X account.  I've granted the account the same
permissions as a local SQL server account that I've been using ...

Once "dbo" user on a particular db has been associated with a specific login
( "Login1") , how to re-associate it with its default login ( "sa" ) ?
My ultimate goal is to add user "User1" to this db and associate it with
login "Login1" . but to do that apparently I need to ...

When I delete the BUILTIN\Administrators login and then re-add it. I get the
message from Enterprise Manager. "It has been detected that this login has
permissions in specific database(s) - the login will have access to these
databases now. "

I run an SQL server to support a college DB class. I just upgraded my box
from 2000 to 2005.  that said... while testing a student log-on  I get an
error trying to create a DB even though the account has the DBcreator role
checked.

I have a new user that will eventually be another admin on our SQL Server 200
installation.  I want to give him permission to stop and Restart Scheduled
jobs, yet not have permission to insert/update or delete in specific
databases until he gets more experience.  The only ...