Search results for query: *

My smtp server has stopped moving undeliverable mail from the Drop to the Badmail folders. This is a problem because we have an applet that forwards messages to an administrator based on the content of messages in the badmail folder. This issue seemed to start at about the same time that we...

After moving a web server to a new hosting provider CDONTS messages that we are attempting to send using IIS 5.0 are "hanging" in the queue folder. If I configure SMTP to use my DNS server as a Smart Host I get an error that the remote server did not respond to a connection attempt...

We have a identical copies of a MS SQL Server 2K database on our development and production servers. The timestamps (and content)of our ASP pages are the same on both servers. We recently had to change the datatype on a number of fields in the database from varchar to ntext (I know...I know...)...

Has anyone experienced a problem where the virtual directories created by Exchange 2000, the "M" drives, fail to initialize? In my case it is because the System Attendant fails to start, which results in the MTA Stacks and Information Store services also failing. The latter services...

Is it possible to have Data Transformation Service activate an ASP? The database server doesn't have a mail client, but does have IIS and SMTP running, so we built an ASP page that will send an e-mail, containing an Excel spreadsheet attachment. We'd like to send the page automatically as part...

When I attempt to create a copy of an existing database on the same server I encounter a problem. I create the new database with no user objects, then use DTS to copy the user defined database objects (but not copy any data) from an existing database to the new one. The process seems to work...

How does one call a stored procedure to insert a value into the data being imported by a DTS package? The DTS package imports user information from an Excel spreadsheet. The spreadsheet contains a column, but no values, for the password. I have a SP to create random passwords and would like to...

I'm trying to write a stored procedure that will select records from one table and then update another based on the selection. The SP contains a parameter that consists of a long list of part numbers that will be used in an "IN" portion of a "WHERE" clause. The only way I can...

I have to let users update a database over the web. As part of the "select list" they will need to enter comma delimited record numbers using a text area. They will be permitted to "hand jam" the data or they can copy and paste comma delimited files from a spreadsheet or text...

I have a form that contains, among other things, 15 text boxes; the boxes are named NSN1 through NSN15 and are already checked to ensure that only numeric data is entered. I need to write a script to check that no value is duplicated in any of the 15 text boxes. Thanks for any suggestions.

I need to combine the data from two joined tables in a view. Some of the columns have the same name and I would like to merge the data from those two columns into one column in the view keeping that name. Following is some paraphrasing of the page from BOL that contains the syntax for creating...

I'm creating a form to insert record(s) to a SQL database via a stored procedure and plan to allow the users to insert between 1 and 15 records in one submission. This creates a SQL problem for me. I intend to write 15 seperate execute stored preocedure commands eg "exec SP_myprocedure1...

I'm creating a form to insert record(s) to a SQL database via a stored procedure and plan to allow the users to insert between 1 and 15 records in one submission. This raises three issues for me. First, each record must contain a specific field, let's call it a part number, so I need to build a...

I would like to adapt the following function, which I am already using, to also ensure the length of the field as 13 characters. The function currently checks that a field contains only numeric data and is called by onblur event handlers in the individual input fields. <SCRIPT...

I need to build a process for inserting multiple rows into a SQL 7 table over the web. Probably 15 +/- rows per page and 10 fields per row. My initial thought was to use a bulk insert statement within a stored procedure. Does anyone have any experience with this? Thanks.

I need to use SQL 7's web publishing capability to create &quot;static&quot; web pages that are refreshed nightly. I'd prefer to use a custom template to display the data as opposed to having SQL create a page for me. My question is, how does one format an HTML table to accept the recordset...

Would anyone care to give me their opinion on the best way to write a select statement that encompasses the following: Our database tracks part numbers, purchase contracts and RFQs (Request for Quote). We buy some parts from multiple vendors to ensure supply, these parts carry the same number...

I have an array of three radio buttons that are selected based on whether all, some, or none of an array of checkboxes on the same page are checked. I adapted that page from one named &quot;Checkmate&quot; sent me by a friend named David Elderbrock. Checkmate uses an onclick event handler to...

Will someone please send me a basic Case syntax for a DTS ActiveX package? I'm using VB Script and I'm looking for something as simple as &quot;Case If DTSSource(&quot;source&quot;) = 1 then &quot;Yes&quot; If DTSSource(&quot;source&quot;) = 0 then &quot;No&quot; Else &quot;Green&quot...

In a nutshell, can I reconfigure ODBC somehow to prevent receiving the error: &quot;Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired&quot; ? I'm executing a stored procedure Select statement with 6 unions that include mathmatical...