Search results for query: *

domburns62, Thank you for the geat idea. The problem is resolved now. It turns out the storedge device has some shredded paper inside. I have to re-assemble the whole unit. Also found the bad hard drives are also causing the bus reset. After replacing that, I can access all the drives now...

I just got a new sun SCSI cable. However, still no luck. What I observed is when the os console show SCSI bus reset, the lights of the device went off along with hard drive shut down sound. Then hear hard drive reboot sound. Does this mean the device is bad?

Appreciate your fast response, djr111! The part # of the terminator I used is 150-2267. It's a SUN brand "27 line forced perfect terminator". According to sunsolve, that's the correct part number. I'm getting another sun SCSI cable now. Hope it resolves it. Thanks all for your time.

Terminator is installed and led is green. When my ultra60 starts, it take forever to initiate all 6 drives in the multipack. Every one of the target (total 12) failed with "SCSI bus reset" message. Do not believe all 6 HD are bad. When I pull out the SCSI cable, system start normal immediately...

I just got a sun storedge multipack (6 hd) and is trying to configure it on my ultra60. It connects to scsi port directly through the back of ultra60. all the led is up on the front panel of the multipack. When it boots with "boot -r", console keep showing following message. warning: invalid...

The best way to find out how big the job market for someone holding a certificate without directly related experience is search jobs in monster.com, dice.com, or local job website.... The chance for junior level DBA is very small. Even the junior level position need previous job experence...

Swi, Based on what I heard in your previous post, I would stay in the current job if I were you. You have your good reason to move on to another job close to home. But, be careful, do not let your sense of urgency passed on to the recruiter or potential employeer like this one. There is a...

Did anyone use following software for SCSA? http://www.selftestsoftware.com/ How do you like it? Does it worth the money to get one?

Is there any way to use INSERT INTO <table name> while overriding MSSQL default action - logging changes first in the transaction log file before committing changes. I'm trying to speed the ETL process. Any hint will be helpful. Thank you!

According to Oracle web site, it will make the announcement at least 6 month ahead of time when it actually retire 8i. So far, I did not see the news yet. Based on the history, the news to retire OCP 7 was published 9 months ahead of time. Personally, I will take 8i soon also for the same...

Thanks for your time, Jay! Frank

When DDL statement is executed, will SQL Server record them in the log? Then, the next question will be how to poke into the log file. Thanks, Frank

Does SQL 2000 save the DDL changes history in somewhere? Actually the last modifed date will help also. Thanks in advance. Frank

&quot;Select *&quot; is a bad practice. There is no question about it. I'm fighting for it with programmers all the time. Thanks for the detail explanation about it, Rob! I never thought of my almost yes or no type of question will turn up the heat like this. Rob, Thanks for your advices any...

Thanks Plantj! Being DBA for years, I found the interests of programmer and DBA are not always in the same direction. Plantj, you are the few exceptions. Due to the constant change of table structure, the ordinal of field has to be changed frequently in my shop. EM is not that convenient any...

Is there any way to change the ordinal for existing column using TSQL instead of Enterprise Manager? Is it possible to use one of the system stored procedures to get it done? Thanks in advance, Frank

Thanks Terry for explanation! Appreciate it.

Thanks SQLSister for your reponse!

Thanks Terry! The interesting things is when I tried to run the same scripts in Query Analyzer. The table was updated successfully. No warning and error message. Frank

I tried to create a job containing only one step. In the first time, the T-SQL script is like this: select count(1) from transaction The job was manually triggered and scheduled to run. It run successfully. In the second time, the script to run is like following: use int go update transaction...