Do you already have a database called DP on the second server?  You get this error if there are currently connections accessing the database. 

Your error is "Use DP".  That creates...

Maybe SQL Server isn't runing yet.  Check the SQL Server Service Manager that can be found in the task pad.  Also, try registering with (local) instead of the computer name. ...

Log shipping maintains an identical read-only copy of the entire database, it's all or nothing. 

I think you would be better off with transactional replication of your selected tables. 

You could...

I found an article in BOL called "SQL Server 2000 and SQL Server version 7.0"

but also take a look at the things that were 6.5 features that are no longer...

You logic may not be correct.  For example if a sponsor has more than one address, this is not going to work because you can only store one addressID in...

Check out the database maintenance plan wizard that comes with Enterprise Manager.  It can easily do what you need.

I don't think there is a way to see them in Enterprise Manager.  The only way I have heard is with third party tools, like Lumigent Log Explorer.

Forgot to mention, this advice is for user databases, not system databases.

You can either do a full backup and then a restore using  "with move" specifying the new locations.

Or you can detach the database and move the files.  You might want to rename the...

The line that drops users is trying to drop users that do not exist in the database yet.  You are checking to see if they own any objects, but not if...

MSDE would work.  There is or at least used to be a personal edition.  It's mentioned in BOL, but I don't have the latest BOL.

I have done this type of application, but it has been several years ago. 

Link to SQL tables from Access.  Set up queries that import from the Access tables into...

The "Allow Zero Length" property is set by default to true on text fields.  I don't think it is a valid property of the date field type.  For dates, you need...

Just happened to see a better answer in another thread: System_User

If you are trying to determine within the web application and it is written in Active Server Pages, you can use the Request.ServerVariables("Auth_user") to get the user account.

In SQL, SUSER_SNAME...