I have a question , what is the best practice to create a login to perform
backup and recovery, Can I just have DB role as DB_backupoperator or I have
to assign a sysadmin role to the user ( in SQL authentication/
windows).Coming up with a secure policy , so that when users go ...

I have what is hopefully a simple question.
I have a SQL 2000 Enterprise server with SP4. I want to be able to rename an
existing SQL account to something else.
I see that there is a sp_change_users_login stored procedure which initially

Hello, would anyone know if there's a way to lockout mainly a SQL (or
Windows) login for SQL Server 2000?  Was wondering if there was like a
stored procedure out there that could be added to the Master db running as a
system process that checks for like 3 failed login attempts or ...

I found below entries in Event Viewer's Application Log and System Log which
worries me as I know for sure that
there is no one login to SQL and use profiler on that time. There are only
two of us have the access to the SQL server and it is firewalled to only

Given two servers: DevServer and ProdServer
Each Server has an AppAdmin user.
AppAdmin is a member of dbcreator role on both servers.
So long as we are creating DBs from scratch, all is good.

How could I find  a list of who has write access within my SQL2K5.
Thanks

We have a hosted SQL server with various internal applications on it. It has
been decided by on high that the same server will also have a database from a
third party on the server. The third party have asked for full system admin
rights on the SQL server.

I have a user that is owner of a replicated database and
they need permissions for some of the master database
Stored Procedures.
Example: sp_MS_replication_installed

Hi,
I am observing a strange behaviour with SQL server.
When i fire a query on SQL 2005
SELECT TOP 5000 * FROM ::fn_trace_gettable

I'm at wits-end here and cannot figure out how in the world to show
the properties dialog window for the [sa] account (as well as one
other SQL account) in SQL Server 2005 Standard Edititon.  This isn't
happening to all SQL accounts nor is it happening to any Windows

I'm creating an admin tool for the app I'm working on and I want to be
able to grant the business admin user the ability to create logins,
and delete logins; >>but only allow them to delete the login if the
user only has permissions to the database for my app<<.

How do I display the default schema that is assigned to me (the user with
which I am connected to SQL Server 2005/2008)?
David Walker

Can we  do online database  migration from existing database server 2005 to
new  database server 2005, plz help me in this regard how to do it
Thanks,
Big

I read in a document from sql 2005  that database roles were going to be done
away with in future reelases of sql but sql 2008 still has database roles.
I like the idea of using a database role and assiging usrers to the role for
security setup.   But I do not want to do this if ...

Question 1:
What tcp port does SQL Server 2005 use when using SSL across the Internet?
I have configured a SQL Server 2005 server to Force Encryption, by
installing a certificate (self-signed) and checking the Force Encryption