...and if you're asking how to "renumber" the identity column so there are no gaps, I'd say you're wasting your time. The values in identity columns shouldn't be perceived...

You can't rename an instance. You can install a new named instance then detach the user databases and attach them to the named instance. You'll have to move...

Backup the user databases. Save DTS packages to files. Script logins, jobs, linked servers. Uninstall Enterprise. Install Standard. Run scripts to create logins, jobs, linked servers....

Did you add the user's domain login to SQL Server? Builtin\Administrators is added by default during SQL Server installation. You'll have to add any other individuals or groups...

Doh! My mistake. I should have told you to look at sysdtspackages rather than sysdtspackagelog. Notice that a new row is written every time a new package...

Are you running the query in the msdb database of the SQL 2000 instance?

Two options that I've used. The first is from the script section here at ssc: http://www.sqlservercentral.com/scripts/Miscellaneous/31613/. The second is a free tool from SQLDTS.com: http://www.sqldts.com/242.aspx.

Yes. You would delete rows from msdb.dbo.sysdtspackagelog, either for a specific package or by age. I run this to delete logs that are older than 180 days:

DELETE

FROM sysdtspackagelog...

Yes. SQL Server Management Studio is a client component. It should be installed on the student workstations. You've probably found that Enterprise Manager won't work with SQL...

I've used a modified version of this script http://www.sqlservercentral.com/scripts/Miscellaneous/31158/ to generate scripts for users. There might be a better one for you in the scripts section of this site,...

I only have experience with Lumigent Log Explorer, but I think all the tools work the same way. They generate reversing DML statements from the "before" and "after" data...

Assuming you have a full backup from the previous night and log backups to the point-in-time when the deletes occurred, restore the backups to a new database and use T-SQL...

It is a general message. I get it every time I run Upgrade Advisor and I've never stored packages in Meta Data Services. As you noted, it also...

I have a couple more ideas. Changing the recovery model should be logged in the Windows Server Application log. Look in Event Viewer to see if there's a...

I wasn't sure, from reading your original post, if you wanted to script the creation of the roles themselves. Your subsequent posts make it clear that you want to...