According to BOL, you cannot use the Copy Wizard to copy user databases from 7.0 to 2000 if:

1)  You are using identical database names on the source and target servers or...

Thanks again and sorry for the delay in responding.  The analyst that I'm working with on this is out of town for a few days and I'd left this alone...

David,

Are your unattended installs logging an error file that you can review?  I'm asking because it doesn't sound like the SP is actually being applied.  Another (maybe stupid) question, but...

Thanks gentlemen for your reply.  Antares, will your method still return results if the @start_date = @end_date (in other words return the results for one day only)?  Thanks again. 

Erik,

If you're not using a domain, then the remote server will need the fully qualified local Windows name.  Assuming that the remote server has an Admin user named user1 then you'd...

Erik,

Are you using the same account to run the job from the Agent as you are from the Query Analyzer?  To check, Open EM, check the Job Properties and make...

Keith,

According to BOL from the 'Using Date and Time Functions' section:

'There are no separate time and date data types for storing only times or only dates. If only a time...

Jon,

We had a case where we needed to install SQL 7.0 on and bought licenses for SQL 2000 which is (according to our reseller) perfectly legal.  This is of course...

You can script them all out from Enterprise Manager and create one large script which will drop and recreate your stored procedures.  If the table name changes are constant you...

Jonathan makes a great point.  We always rename the plans with what they do and what database(s) are being maintained.  I don't really understand why MS chose to default to...

I don't know that it's possible to preserve the passwords when migrating from Sybase.  We just moved a Sybase 12.0 db to a new SQL server with assistance from the...

Check the FAQ's on this site or the Microsoft article here:  http://support.microsoft.com/default.aspx?scid=kb;en-us;256650.  I've used the procedure that creates dummy transactions explained there and it works quite well.  Hope this...

But wouldn't a brush scratch the surface of the tables leaving them dull and dingy?  I would think that using a soft cloth and Endust or Pledge would do the...

  Woops,

Just put my glasses back on and saw that. 

According to BOL from the 'BACKUP' topic:

"NO_LOG | TRUNCATE_ONLY

Removes the inactive part of the log without making a backup copy of it and truncates the log. This option frees...