It depends, the service control is obviously unable to complete the server start most likely getting stuck looking for a missing component. Can you post the contents of your cnfvg.err...

But you may have troubles unless this index is unique being able to get the previous and next without using a cursor.

"Don't roll your eyes at me. I will tape...

If you will be doing this often then setup a Linked Server (many threads on that here but I can help if no one does by Monday, sorry not at...

My belief on RAID 10 (0+1) is high write databases should be placed on those (they are costly yes, but they will give you the best uptime with performance). Read...

First cursors are important but yes should be avoided with extreme prejudice. But, you may still run into issues which cannot be done in other ways.

Next while loops are usefull...

Just tables and queries (views in SQL).

Also if you are going to keep usin Access as the front end you will have a lot of server overhead appear and it...

What version of Oracle? And what are you trying to do, usually you use a link server if this needs to be live pulls, or better use DTS to import...

If you are just trying to free the space without shrinking the log then try

BACKUP LOG [dbname]

WITH TRUNCATE_ONLY

"Don't roll your eyes at me. I will tape them in place." (Teacher...

I do have one working method that requires a field with unique data. I suggest add an Identity field and make the column a clustered indexed if you can then...

Performance gains on regular SQL selects in that SQL will store execution plan so that SP can access and know (hopefully) quickest path to finding data without needing to check...

Execute the SP with Execution Plan output to see if it does anything odd.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I don't know of a way to do this in 6.5, 7 was the first version to allow you to shrink files back down. If you are moving to 2000...

This should do the trick.

Just replace numberstartat with the number to start at.

However I would look at possibly doing a client side cursor to retireve the data as well.

SELECT TOP...

AWAITING COMMAND means they are connected, and you should only drop those connections you are sure of look at login name and application in most cases will help.

"Don't roll your...

Do you have any kind of primary key on the table or unique column with index?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...