What are the steps I need to take to get a stored procedure to run on a timed interval, for example every 15 minutes?
I need this to log out inactive users, on an ASP application.
Also to do some other tasks, such as regulair updates of tables.
Regards.
Brian
I have a really strange problem,
I have created some ASP pages that all use a common code for executing Stored Procedures on an SQL server.
However, for most of the pages it works, but for one it does not, And I simply can not understand the Error Message, and where it comes from:
I have...
I want to be able to store and retrieve Images from an SQL database.
I searched the forums, but has so far not got a clear answer, I could have missed something, but then again, I will try and ask here.
I have heard pro's and con's against storing them in the database, but one issue I have...
Hi there.
I have a little problem, that I think can easily be solved by making a small application.
I need to manually sort and move a whole bunch of files, with very much random names (2CFDgfjdwFDf43Fs.txt), in some directories.
The directories contains thousands of files each, so it is a...
I have a folder on a Sun Unix machine, that I want to copy to a Linux machine over an SSH tunnel.
It is the only way I can get out through the firewall.
Also I need to tunnel through a tunnel, since I need to stepstone out.
I have already created the stepstone tunnel by using the command:
ssh...
I'm working on making a program that is going to show wind direction.
I have made a circle and a line that goes from the middle and to the edge of the circle.
I was never any good in math class when it came to cricles, so how do I calculate the rotation of the line? the middle is fixed, but I...
Is there any way to resize images on the fly?
What I mean is that instead of Resizing all my Holiday pictures in 4 different sizes, and having each picture 4 times. I would like to only have the largest one, and then depending on what size it should show on the client, it will resize the...
Hi guys,
How can i make a link, so that when the user click on it, it will open a new window, but the new window should have a fixed sixe, and no toolbars, addressbar, etc...
I want to use it on a site where a user can click on an item to get more information, and this should then open ain a...
Is it possible to use command line arguments for an application that I design?
The reason for this is that I want to make a program that I can start with command line switches.
So for example:
Myapp.exe Would start the application in hidden mode.
Myapp.exe /c Would start the app in Config...
Is there any way in SQL server to run a piece of VB code on timed intervals?
The reason for this is that I want to make a Procedure that imports some logfiles every xx amount of minutes.
Regards.
Brian.
Eldaria
www.eldaria.net
That was my 25cent** of opinion.
** Inclusive Intrest, tax on...
I love this Forum...
So here is another question. :-)
I'm having a trouble with only users who are Domain Admins or higer are able to log in to OWA, and to use the POP3 login.
I have already tried to alow the user to "log on localy" in the Policies. This was suggested from some other...
Is there any way to use an external SMTP server with Exchange 2K?
I'm having some trouble with my ISP's DNS servers, and therefor my Mail server can not find any domains outside of my ISP's network.
Now this causes trouble for the users of my network, so that when they send an E-mail it just...
Hi all.
For the first time I realized my server was an open Relay even though I thought I had locked it down.
My problem is this.
I had dissabled Relaying for everyone except if they authenticate.
In this way I thought that it would not be possible to Relay unless you authenticated with the...
I have a slight problem.
I have 5 PC's in a Home Network, 4 of them running Windows 2000 Pro, and the last one running Windows XP Home.
I want from one of the Windows 2000 Machines be able to remotly monitor all of the PC's Ram, CPU, etc...
I can from all of the PC's monitor all the Windows...
When executing following SQL:
Delete FROM tbl_Genre
WHERE (tbl_genre.GenID = 9)
I get this?
Server: Msg 207, Level 16, State 3, Procedure T_tbl_Genre_DTrig, Line 4
Invalid column name 'GenID'.
but a slight modification of the SQL:
Select * FROM tbl_Genre
WHERE (tbl_genre.GenID = 9)...
Hi Everyone,
I have a question, I have a small network with one 1024/256 ADSL connection.
Currently there are 4 computers + Server connected.
For this I used the Windows 2000 Server, with Routing and Remote Access and NAT.
Now I have this problem that some of the Users are using all the...
I was wondering, Is there any way of accessing the Windows NT/2K/XP performace log in Visual Basic?
I have found the "Performance Logs and Alerts 1.0 Type Library" in References.
But I don't know how to use it, there are no help files.
I found an Visual Stuido Solution File, at the...
I have a problem with ADO.
I have made a function that searches in a database for some specific keywords.
The problem I have is that wen i copy the SQL query to the database that the ASP page opens, it works fine, it shows the results, but when the ASP page sends the Query string to the...
Hi everyone...
I would like to log network traffic(Bytes Transfered) in an SQL server database using the Windows 2000 Server Performance log.
On my Laptop I have Windows XP Home and I can select the log file type to be SQL server, but in Windows 2000 I don't have that option, only the common...
HI all, I have a real strange problem, I have created an ASP page to show an index over movies that I have, but It makes my server go berserk, a process called DLLHOST starts using 95-100% CPU and eats huge amount of memory as soon as I try to open the page.
The page is timing out after a while...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.