How do you backup a database that resides on MSDE and the
restore it on SQL Server 2000 and the remove the original
DBOwner and create a new one?

I'm changing an application which is connecting to SQL Server through SQL
Authentication so that the application can connect to SQL Server through SQL
Authentication or Windows Authentication.  It seems that I just need to
provide a UI for the application administrator to enter ...

It seems not sufficient to be a member of group dbo to make dbo the default owner
of newly created objects.
Being member of 'System Administrators' accomplishes this.
But is there a moderate possibility to make this default behavior work?

I just can't seem to get this working right.  I want to make it just a
regular domain user in a W2k domain on a 2003 server running sql 2000 sp3.
Everything is in place from what I see. It actually works too...until you
reboot.  I don't konw what is wrong.  Perhaps someone knows ...

I work for a training center and we have the following scenario:
SQL Server 2000 SP3A is installed on 10 computers in our classroom, under
Windows 2000 SP4 Professional.
The students log on with their own user name.

We have a SQL database server that has multiple databases running under a
single instance. Each database has a dedicated group of users and admins.
Each database has a dedicated set of maintenance jobs (created by a
maintenance plan) and custom jobs created to perform time ...

I have an ASP.NET web application that uses a SQL Server 2000 database.  I am
forced to use Impersonation/Delegation with Windows accounts so that we can
audit activity at the database level.  However, everyone in the organization
also has MS Access on their desktop.  How can I ...

We have a "hot" disaster recovery site.  The logins from outr production have
already been created on the disaster recovery site.  however, I need a way to
be able to update the passwords on the disaster recovery server should a
recovery be necessay.  sp_addlogin and other tools ...

We recently installed SQL Server 2000 and have upsized our Access back end
database to SQL Server.  I have added all of our users to SQL Servers logins
and assigned them to the proper roles.  We are still using that same Access
2000 front end.  My problem is that anyone who tries ...

We recently brought up SQL Server and migrated our Access 2000 back end DB to
it.  The SQL Server security seemed pretty straight forward to me...I set up
the users and the roles and assigned the roles rights to my tables.  The
problem is that my users get a Permission Denied ...

To meet audit requirements, I have to maintain an audit log of when a
particular sp was execute and by whom.  I am not willing to use the c2
option for just one stored procedure.  There are 2 users who can run
the stored procedure from enterprise manager or query analyser (others

Besides BUILTIN\Administrators and sa, are there any logins which will be
created by default in SQL Server 2000?  It seems that a Windows User (the
user who installs the SQL Server) will be also created automatically.  
Does using Windows Authentication or mixed mode affect which ...

I would like to know which ports need to be open to enable SQL server 2000
connectivity by default.
Thanks

Running profiler to catch anything on the server that has
a duration of greater than 30,000 miliseconds(30 sec),
and realisticly we shouldn't have much logged, but in 3
hours we have over 23,000 rows logged and most of the

Is it possible to match SQL DB roles with Active Directory/NT groups?
i.e. A user could be in 2 AD/NT groups (e.g. gAdmin and gUser).  I then
want this user to be member of rAdmin and rUser in my database.
I am trying to allow the administration of users in AD/NT, rather than