I "kind of" tracked this issue down.  All versions of SQL Server 2000 call msdb's "sp_help_jobstep" to return the results for the popup screen (and for SQL-DMO).  When...

This appears to be a post-SP3 issue.  That is, what is your version of SQL Server?  I am going to guess that if you run SELECT @@VERSION you will get...

Do you experience any issues with SQL Agent jobs that have more than one job step?  I have posted a separate question regarding this...

Why are you suggesting this?  That is, are you thinking that it sometimes cannot allocate the memory because not all of the services are up and running (like SQL Agent)? ...

Are you referring to something like SQL Server's "Multi Server Administration" or something else?

I personally run the below script that I created... who knows, I may be way off on this, but I found that other queries I found on the internet would...

I don't care if the original database is kept running or not. Also, doing a backup and then a restore (no need to create the database first) is certainly...

Thanks for the reponse. The background beyond the "fixed server memory" decision is as follows:

- running Windows 2000 with 4 GB RAM

- running SQL Server 2000 Standard Edition which...

Thanks for the responses. I already know that you cannot / should not copy data files while they are in use (while SQL Server was running), this is why...

BTW, one of the many internet sites that keeps the version numbers up to date is http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

As you will see, there is no mention of a .766 and is why...

It is my understanding that nothing internally changed in SQL Server with SP3a. Instead, there were problems with MDAC 2.7 so Microsoft updated it and repackaged SP3 with the...