I lost no user accounts.

I would leave at least 64 MB so the OS has some play should an issue arise as you don't choke it to death. If ample memory then better to...

Major thing to keep in mind is that the files will be changed to the SQL 2000 format and you cannot go back to 7 except from a backup restore....

You cannot restore part of a backup. However, you can create a new database to retore to (using the WITH MOVE option in RESTORE LOG process) and move the missing...

Two other ways I have done in the past.

1) Right click a DTS package and do schedule, then the job it creates get the details of the step and put...

Yes, another problem is SP with any type of dynamic SQL will not have the dependencies available. However, I do see to recall someone here wrote a script to parse...

Sorry, but I don't believe you can since the backups are file iamge backups and not direct to tape backups. You have to restore the file to a drive then...

I also agree, the area I work for had increased to 6 mintues which ultimately caused more issues. The problem with increasing the timeout is people are impatient, for example...

The big problem that I see with most of these is the way MS does their patching sometimes. First MS has three types of general patches, single patches (mostly vuneralbilities...

Wirth what Steve stated just to add a bit. Close the table, right click on the table in EM and do copy. Then post the table DDL into QA, rename...

Might also try installing the last MDAC again. If all else fails I did read a thread on another site where the statement was made that they copied all files...

I will depend I think on the version you have. I have not played with it. However, take a look here, it might be useful.

http://www.infoadvisors.com/articles/ERwin40/ERwin40FirstStepsWebPublishing_II.htm

Not directly, there is an XP that can read the application log but you still have to parse the data yourself (doesn't work the same in 2K and I haven't...

SQLDMO is a set of client library (com objects) that can be obtained from the SQL client install (I believe they are redistributable). SQLDMO does offer a great solution.

Now...

Best way is to add a decimal position to either the 20 or the 3 then cast into it's final format. Like this

CAST(20.0/3 as decimal(10,2))

The problem you are running into...