Search results for query: *

JayKusch, Thank you so much for your help. I will use the profiler to do it. Hope it works. I appreciate your help.

Hi, guys. We have a problem with a developer here, and I need find out the exact SQL he ran recently. I have no idea which sql he ran, it could be SELECT, DELETE, or UPDATE. The only info I have is his user name. I started to do my research last week, but no luck. I am not very familiar with SQL...

Mrdenny, Thank you very much for your help. Both of your methods make sense to me. I am trying your 2nd method now, the transfer is in progress and I believe it takes at least 6 hours. I will let you know tomorrow if it works.

HELP!!! We need transfer all 52 million records from table apple into banana, we have 36Gb free space available, and I have already put the database into simple recovery mode, but the transaction still ate up all free space and failed. I have been trying several days using either the Import...

daFranze, It's interesting: on hour system, the password for every account in /etc/passwd is '*'

KenCuningham, 'usermod -e' should work if the accounts were disabled with the same command. If they were disabled with 'passwd -l', it won't. Thank you very much.

I got it: you can user either 'passwd -l username' or 'usermod -e 6/14/06 username' to do it. But, now the question is: how do enable those accounts through command?

We need disable some user accounts. I know we can open SAM and deactivate user accounts, but there are hundreds of them and it takes too long. My boss said it can be done with 'usermod' and asked me to write a script to do it. However, I checked the man page of usermod and I don't think it can...

Catadmin, I did run the command 'restore database apple with recovery', and I got error 'The RESTORE statement could not access file ...APPLE_2006...tuf'. As far as I know, this command will try to apply the last log file first, then change the mode from readonly to read-write. But, I don't...

We have setup log shipping on our prod database APPLE. The destination database is configured to be in standby mode. The log shipping has been running well, and the destination database is always in ReadOnly mode. And today we have stopped log shipping. But by mistake, the source database was...

We have a Oracle9i database on HP server. I logged on as myself to our Win2k server, I created ODBC using "Oracle in OraHome92" driver. Then I clicked "test connection" button, typed in password, it works fine. But, my client logged on as himself to the Win2k server and can not test the ODBC I...

SQLBill, I resolved the problem. All I need do is adding user sys-cluster to local administrator group. I thought it is already a member of local admin, but actually it was not. After that, everything works fine. Thank you very much for your help.

SQLBILL, it's setup as SYSTEM DSN.

Our developers want me to create ODBC for Oracle on a SQL Server box because they got error "The Oracle(tm) Client and networking compenents were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3(or greater) client software installation. You...

LeighMoore, excellent explanation and clarification! I have saved your post and forwarded it to our client. Thank you very much.

JayKush, thank you very much for your advice. I will tell the clients to do that. It seems to be the only choice now.

I am sure it is in Simple Recover mode. And I don't think we need worry about virus. Actually, before the transaction started, the user had already warned us, because they are going to insert millions of records. About simple recovery mode, as far as I know, it will make the transaction log...

JayKusch, I have already put the database in Simple Recovery mode. But this does not work. It is still growing fast. By the way, with database in Simple mode and max transaction log file size set to 1G, our client tried again, still got the same error. We have been trying all day, this is...

Our Transaction log file is growing very fast (2G per 5minutes) and fill up the disk. I have already set the database to be in simple recovery mode. Also I have schedule a job to run 'backup log ... with truncate_only' and 'dbcc shrinffile (...)' every 5 minutes, but it does not work because the...

I just right clicked the database in Enterprise Manager -> All Tasks -> Take Offline I am trying this because I need to know how to do point-in-time recovery. I don't want to wait till the disaster really happened. The way I learned to do point-in-time recovery is: After the database is not...