Download Oracle XE and Install.  Create a procedure out of your query. 

XE has tools to convert SQL Server DB's to Oracle DB's.  It won't do a Great job, but...

Sugesh, I don't thing you understood the question.  It is not his system, but his install media for SQL Server 7. 

I checked MSDN and you can download 6.5, but...

Can you elaborate on that option?  Or did you miss-read the post.  Even Oracle has issues between versions of .dmp files, and they created them. 

Using the imp/exp commands from...

I recently upgraded from XP MCE to Vista Ultimate.  I had to upgrade my bios, and set my disks to never turn off (even though they still do????)  to prevent...

I have seen this in situations where there are VERY few (< 100) rows in a table, and I also think it had to be a clustered index for that...

Pro Edition?  Sorry, never heard of it.  However I suspect you are trying to install the Enterprise edition which cannot be installed in XP Pro. 

Not a great tool, but one that at least give you a start.   Diagrams in Enterprise Manager work. 

Forgot what forum I was in.  If you are still using 2000. 

I would put the DBCC UPDATEUSAGE AFTER the Rebuild of INDEXES

From BOL - DBCC UPDATEUSAGE

Reports and corrects pages and row count inaccuracies in the catalog views. These inaccuracies may cause incorrect space usage reports returned by the sp_spaceused system stored...

Everyone here is describing how to copy an oracle INSTANCE.  Which would be similar to copying a SQL Server installation/INSTANCE.  An Oracle SCHEMA is much more like a SQL Server database. ...

I really have to agree with Jeff here.  You are compromising the database design for a numbering scheme?  I would say that is about the worst reason you could come...

Not sure about what your goal is, but if it is just to visualize the data better.  Try the new Performance Reports from MS.  http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

If you are blocking, you are causing someone else to wait.  The reasons for blocking and waiting were explained correctly by michaela. 

The factor that is usually the biggest limit for me is restore time.  If you lose a single file, what is the max time you want to spend to restore...

USE statements are not allowed in procedures.

IF @COUNTER =  0

BEGIN

    USE MSDB

EXEC SP_START_JOB @JOB_NAME = 'DM_CYCLE_CHECK_OK'

END

IF @COUNTER >  0

 BEGIN

 USE MSDB

EXEC SP_START_JOB @JOB_NAME = 'DM_CYCLE_CHECK_ERROR'

END

Change to:

IF @COUNTER =  0

BEGIN

  EXEC MSDB.dbo.SP_START_JOB...