There's a good example of a maintenance plan created without the wizard posted in this thread: http://www.sqlservercentral.com/Forums/Topic488787-8-1.aspx. If it looks complicated, it's because it is.

I believe you...

You can't create a SQL 2000 maintenance plan in SSMS. You're stuck with using the maintnenance plan stored procedures in msdb of the SQL 2000 instance to create the...

This will get you started, but I recommend reading about backups and maintenance plans in BooksOnLine.

Create a backup device in SQL Server Management Studio by right-clicking Server Objects in Object...

One way is to use SELECT INTO to create the new table from the results of joining the four tables. BOL has an example of this at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/cc9bdf10-edfc-41a5-adf1-aa9715ed8d71.htm. The...

That's one way to do it. You could also backup the SQL 2000 databases and restore in SQL 2005 or upgrade in place. I recommend referencing "Upgrading to...

I work for a government agency that deals with taxpayer data and we're required to sign a confidentiality statement. We also take manditory security awareness training every year and...

It also wouldn't hurt to read about security in BOL. You'll find help on things like adding a user to a database role and use of SQL Server Agent...

It sounds like Transactional Replication would be appropriate for your scenario with the remote locations as publishers and the central office as subscriber. Check "Selecting the Appropriate Type of...

Actually, if you repeatedly execute sp_cycle_errorlog as Andrew suggests, you wouldn't have to delete the file at all. It would automatically drop off when you went past the configured...

Members of SQLAgentUserRole and SQLAgentReaderRole can execute jobs they own. Members of SQLAgentOperatorRole can execute any job in the instance.

One of the SQL Server Agent roles might be what you need. Check out BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm

You could try querying the default trace, if it was running (it's enabled by default, but can be disabled). Here's a query that will find actions that will show...

Since you're the DBA, are you a member of the sysadmin server role? If so, you'll be able to do anything in any database without explicitly creating a user...

Here's a script that will list databases and database roles for a particular user (replace YOURUSERHERE with the user you're searching for):

set nocount on

declare @name sysname,

@sql nvarchar(600)

if exists (select...

I've never tried this because I'd think it involves updating a system table, which I generally avoid. You could try following the steps described in "How to: Reconcile a...