Mohit is correct, in Sql 2000 you can not restore individual tables but can restore to a new database and then copy over the individual table. There are third...

I am curious as to why you want to stop the scheduled backups.

If just a temporary stoppage, go to Enterprise Mananger - Management - Sql Server Agent - Jobs, find...

Did you create the DTS yourself or did someone do it for you? DTS is being replaced by SSIS in 2005. If you created it yourself, try re-creating...

Here it is. Like I said, it is based upon somebody else work that I got from SSC. I'm not sure if it would work properly if someone...

Another task you could add to your list is investigation of new technologies and upgrades. If you are not using RS or BIDS then this could be part of...

There are some 3rd party apps for documentation that I have considered checking out myself.

Red Gate's Sql Doc 2.0 ($295)

http://www.red-gate.com/products/SQL_Doc/index.htm

and SchemaToDoc ($125)

http://www.schematodoc.com

Both products allow you to download and try them...

There are three basic ways that I am aware of to migrate databases from 2000 to 2005:

1) Backup the 2000 database and restore it on the 2005

2) Detach the 2000...

I would personally create a user defined role that has the exact permissions you want and add the desired logins into that role. That way you can be more...

Whether you install ArcSDE on the Sql Server machine as a service and use an application server connection or use a direct connection from another machine with ArcGis installled, you...

ArcSDE is installed on the same server as the Sql Server. It sounds like you need some ArcSDE training. Check into the class "ArcSDE Administration for Sql Server"....

I also work for a county government where all the salaries are public. There are no negotiations for salary. There are pay grades and steps within the pay...

1. In the BOL section "Adding Rows Using Bulk Copy Operations" it states that "Use the BULK INSERT statement in Transact-SQL batches, stored procedures, and triggers to bulk copy data...

If all the tasks that need to be done can be set up in Stored Proceedures, I would look at granting a user permission to execute the SPs. That...

I echo the concern for your database design. Why can't they all be in one table with a field the stores the 1, 2, etc.

Or maybe the field that...

The long term solution is to use roles.

Instead of assigning permissions to individual users, create a role that has all of the permissions desired and assign the user to that...