I don't have any servers, including development, using per user licensing.  I thought you could make a one-time change from "per user" to "per processor" though.  It will NOT let...

Not sure you really need a cursor for this.  There's probably a lot more to it. 

--SELECT F1,F2,F7,F8,F12 FROM JAN

--FETCH NEXT FROM GETDATA...

We setup a trace file using profiler, then scheduled the trace to run on startup.  We capture the information to a table, so we have a record of every time...

Will this work?

http://www.sqlteam.com/item.asp?ItemID=5908

  You might also want to check out http://www.asp.net and see if there is anything on there you can use.

I 100% agree with David on this.  IF you are going to continue using SQLMail though, you need to read the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

http://support.microsoft.com/kb/315886/EN-US/

Those will solve 99% of any issues...

That's kind of a kewl error.    I don't think I've actually seen it either.  What version of MDAC are you on?  You...

You don't have that stored procedure being called for every single detail line do you?  That would definitely cause issues.

Log PI is another tool.  I believe they also provide a free evaluation.  We ended up buying Lumigent Log Explorer where I work.  It's a nice tool.

Microsoft did a really solid job with the SQL Server 7.0 to 2000 upgrade.  Read the upgrade notes here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_upgrade_5jw3.asp

Pay special attention to the "Upgrading Databases from SQL Server 7.0"...

You might also want to look at Tara Duggans' backup scripts.  You can just paste them into a job and run them.

http://weblogs.sqlteam.com/tarad

You also might want to check out Virtual Daemon Manager.  It's kind of kewl.

http://weblogs.sqlteam.com/derrickl/archive/2005/05/08/4916.aspx

Instead of starting this discussion over, you should search http://www.google.com for "surrogate key" and have a lively argument with yourselves. 

Are you using a different file for each day?

Does the account the maintenance plan is running under have Delete permissions on the folder you are storing the backups in?

You want to archive the SQL Server log files for a database, or the error and sql agent logs?  The log files aren't "archivable" per se, but you can perform...

Couple questions after reading all these: 

1.  What set options are you using?

2.  Do you have the same data in both copies?

3.  Have...