Search results for query: *

I have a table of work to do. Rows are inserted by several different processes (web forms submitted). Once an hour a DTS package reads the table, exports to a text file, then TRUNCATEs the table. The package does not take much time to run but inevitably there will be an attempt to add a row to...

How to specify a parameter for an Execute Process Task that takes its value from a global variable? I wish to run a batch command with a filename as an argument. The filename is generated by a date query in a global variable. The global variable is used for the data source. After the file...

How to update the Status column when a radio button is checked? The Status column may have values 0,3,5, or 8. The initial display of rows in the gridview shows the appropriate radio button checked if the value is 3,5, or 8 and none are checked if the Status value is 0. I want to update the...

This is a question about the physical file which stores the database, the .mdf file in particular. I notice that the dates Modified and Accessed shown by Windows Explorer file Properties do not match the activity in my databases. Databases which are continuously used and in which data is...

I have a table which is a list of work to do, and multiple processes looking at the table to get the next task. It takes a relatively long time to finish the task, and after it is finished the process marks the task as completed. Only one process should find and handle a task. While a task is...

Is there a way to do this when the page is in a tab instead of a new window? window.opener.location = "main.asp"; I have a main page which lists work to do. The agent clicks a link on one of the items. This opens a new window, a form related to the item. Upon submitting the form, I wish to...

Is there a way to detect the security level set in the browser? I would like to check whether IE Privacy is set to Accepts All Cookies, Low, Medium, etc.

In a diagram for a package I created and saved using the Export Wizard there are two pairs of connections. The export involved four tables, exporting from SQL Server to Access. Connection 1 and 3 represent SQL Server and Connections 2 and 4 represent the same Access database. The diagram uses...

I used sp_MS_marksystemobject on my stored procedure in master. Now I cannot edit it, nor delete it, nor rename it. I am using Enterprise Manager (SQL Server 2000) and accessing the stored procedure for editing by clicking on Properties. The owner is dbo, which is not me. How do I revise my...

After upgrading to SQL Server 2000, Enterprise Manager now needs about 10 minutes to display the list of 70 databases. My Client Network Utility has TCP/IP enabled. Any suggestions?

What to check in server or browser setups to account for intermittent loss of session variables? This usually occurs just after a session is started and the page autorefreshes, but also occurs after longer periods of activity. Windows 2000 server, IIS 5, XP and Win2000 clients, IE6 browsers...

With SQL Server 2000, web application has 10 users, inserting a row into the table about once a minute, table has 200,000 rows. I need to add a column with a default value. Will this cause cries of anguish or will it go unnoticed by my users?

Is there a way to write a SELECT ... ORDER BY query so that the sort order is controlled by a variable? The solution I have is to use IF and run one query if the sort should be ascending and run the other query if it should be descending. This is in a stored procedure. Here is what I am...

So I am thinking about adding a column to an existing database which is part of a proprietary application we are licensed to use. Using Enterprise Manager to do this I get a dialog box with a warning, The following tables will be saved to your database! Do you want to continue? It lists a...

What is the a problem with this query? SELECT HOUR(AcctStartTime), COUNT(*) FROM radacct WHERE AcctStartTime BETWEEN '2003-11-03 00:00:00' AND '2003-11-03 23:59:59' GROUP BY HOUR(AcctStartTime) Executing this in an ASP script using ADODB with an unknown version of MySQL. Other queries...

I would like to use functions like gethostbyaddr() and inet_aton() in ASP. These functions are availble in the Socket module in Perl. I need to write an ASP version of a Perl script which uses these functions. How can I get the results these Perl functions provide?

Is there an ANSI standard that the UPDATE statement operates on one table. And if so, why this limitation?

See faq333-618

I have several databases, all with the same structure and all on the same SQL Server. And I have a stored procedure that can be used with any one of the databases. The database to be used is specified in a web page. The stored procedure creates a temporary table, builds the temporary table in...

I am using dynamic images in a navigation frame and sometimes the browser is reporting the error document.images['navX'] is null or has no properties. This seems to be a timing problem, as it can be forced by mousing over the navigation links as the page is loading. Whenever it happens the...