Hi All,
I would like to ask help regarding Sending of Keys to specific application which is not currently focus or which is minimized (not active).
Example: (But works only if the application is active)
Dim ReturnValue
ReturnValue = Shell("NOTEPAD. EXE", 1) ' Run Notepad
AppActivate ReturnValue ' Activate Notepad.
SendKeys "ABCDE"
...
khickyphutz
Last Activity: Jul 27 '07, 03:39 AM
Joined: Nov 28 '06
Location:
-
HELP: Sending keys to minimized application
-
Good day wayne,
after running the script you gave me, I tried to shrink the database this time and I can already set its minimum size from 64GB to 5GB now. after shrinking the transaction log, the size now of my transaction log is only 5GB.
Thank's a lot manÜ Thank you so much, It really helps.
Take care and God Bless.
MaDz -
I already have run the script and it compiled successfully but there was no change in the size of my transaction log.
the transaction log file size is still the same and it continues to grow every day.
any other alternative way to reduce its size?Ü
thank you and god blessLeave a comment:
-
This is what I have entered in SQL Analyzer:
truncate log AgriMrpPrd with truncate_only
Where AgriMrpPrd is the name of the database.
The error is:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'log'.Leave a comment:
-
Good day to all:
I am just a newbie in MSSQL Server (Currently using SQL Server 2000), I am facing the same problem right now with our production server since our database administrator has resigned. Now, I do not know what to do to reduce the size of the transaction log since it almost have taken all the space in the disk. This might cause our production server to crush and other databases will be affected.
I would...Leave a comment:
-
???
I already have copied the DATA and LOG file to my hardisk through Remote Desktop. Now, How will I be able to use the DATA and LOG? Assuming the database name is AgriMrpPrd and the Files are: AgriMrpPrd.mdf and AgriMrpPrd_Log. ldf.
Sowee to the nooby question...
Take care and God Bless...Leave a comment:
-
khickyphutz started a topic Truncating or shrinking a 65GB Log File with available 2.8GB harddisk spacein SQL ServerTruncating or shrinking a 65GB Log File with available 2.8GB harddisk space
Good day!
I would like to ask for a technical advice regarding transaction logs. Right now, our server only have 2.8GB due to the transaction log of our database which is 65GB now. Its database size is around 1.8GB. There is an approximate growth of 1GB+ per day in the transaction log.
I have tried backing up the transaction log with the option of remove inactive transaction logs but it wont work, as well as backing...
No activity results to display
Leave a comment: