Add users to db_ddladmin, db_owner role in the user databases.  This will permit them to create objects owned by "dbo".

For the SQLAgent jobs, in the msdb database, add users to the...

Automate as much as possible:  Disk space, alerts, dumps, optimizations, dbcc's.  The maintenance plans are great (no need to roll your own), and the wizard will walk you through it.

Continuously...

Thank you.  Both of these are good suggestions.  I had wanted to avoid scripting the jobs because of embedded "go"'s in some of the transact-SQL command windows; these "go"'s cause...

Interpreting Sybase sysmon output is something of an art, and mileage will vary depending upon your installation.  Sybase teaches an advanced p&t class that spends time looking at sp_sysmon output.

This should get you...

You need to use ODBC drivers.  OLE DB will not work with sprocs.  At least, I haven't been able to get it to work.

Beware the "auto shrink" option may cause performance issues.  Best to create a job to dbcc shrinkfile with the recovery model in "simple" if tranlogs aren't required.

Good discussion of the...

Just wanted to update the thread ...

After fiddling around with this, and consulting a Sybase newsgroup, it turns out that there is a bug with the OLE DB drivers. ...

Yes, with the same error.

Woohoo!    That was it!  Thank you.

Thanks.  The articles are helpful.  None of the options are set, and the hardware is in good shape, so it must be the autogrow (autoshrink was set off long ago). ...

If the database is set for "full recovery", then you need to have a job to dump the transaction log periodically.  The autoshrink option only works if the database is...

How about -- do a self-join on the table, with count(*), GROUP BY and HAVING count(*) > 1.  This will give you the rows that are non-unique.

Delete those rows (WHERE...

Thank-you!!! That is exactly what I did -- with an additional first step:  Offline the SQL Server in the Cluster Server Administrator.  It really is a 10-minute job (plus restores, of course). ...

Yes, another instance with matching collation (server and database) is available so I can move existing applications.  However, the question remains "How to change Server collation for SQL2000".  If the...

Wow!  Thanks to everyone for posting responses.  These are great answers.