Recent content by SilentWings

Hi Cain We had the same problem but we solve it with the formula bellow. Note that "Duracao" (duration) is a measure that contains the number of seconds. I hope this hep you. Best regards FORMULA: cstr(cint([Measures].[Duracao] / 3600-0.5)) + ":" + format(cstr(cint(([Measures].[Duracao] -...

Hi ppl, I need a peace o VB code that gives me a result telling me that a pc with an ip is or not replying a ping. Thanks in advance

Hi ppl How can I in a vb script execute an application made by me. For example the application "c:\temp\myapp.exe" Note: It must be in a vbscript and not in a bat file Thanks in advance

Hi ppl I need to create a vbscript that copyes a backup database to other computer which have seven folders one for each day. How can I do a simple task like if today is Monday (day 1) copy the file to other computer (imagine server2) to a folder backup\monday. If today is saturday copy to...

Hi ppl, I have a transact sql that create a database. It works. Then I need to put the database on the server. I need a transact sql that restores a complete database that I have saved in a folder imagine 'c:\tem\mydb.bck' Can you give-me that TSQL? Note: The server where I am restoring the...

Hi ppl I have a modem installed in a Server that can't be restarted very often. The problem is that the "DTR" led is "ON" and when I try to access de modem I receive the message "Port already open". How can I release de com port without having to restart the server. Note: turning off and on the...

Hi ppl, I’m making a .BAT file that make a lot of operations and runs during the night. In the middle of that operations I need to do a disk defrag in Windows 2000 professional. How can I do that? - I don’t know how to start the disk defrag - How can I do that without having to click “Start”...

SilentWings (Programmer) Oct 25, 2004 Hello ppl, I have a vbscript (to run in Windows 2000 professional) that I got in windows.com but when I execute it, remains in the computer a window saying "It’s now safe to shutdown your computer" I need a script (or .bat file) that really turns the power...

I'm doing a .bat file in order to defrag the disk and the sql databases. This process will run at night. When finished I want the computer to shutdown (power off). Thnaks

Hello ppl, I have a vbscript (to run in Windows 2000 professional) that I got in windows.com but when I execute it, remains in the computer a window saying "It’s now safe to shutdown your computer" I need a script that really turns the power off. Can someone help me? Thanks in advance

Hi. ppl How can I reindex the system table indexes? Thanks

Hi ppl! Is there any way we can do an console aplication in VB6 /Win2000. I want to do an aplication but the data must be entered / displayed in a dos windows runing in Winn 2000. How can I do it? Thanks in advance

Hi ppl, I'am having troubles making a new push subscrition. The problem is the database is too large to be transfered by the network. I read some sql books and all of then tell to apply the snapshot manualy after sending the files in a CD. How can I do that? How can I prepare the database in...

Hi ppl, I have a VB program that executes stored procedures in SQLServer2000. I need to launch that execution and don't want to wait for the results of that Stored Procedure Call. How can I do that? Thanks in advance...

Hi ppl, I have an VB Application in which I want to lunch a window to do some work while the user continue working in other windows. How can I do that? Thanks...