Search results for query: *

Thanks for the tip, Paul, but there's nothing there that relates to my issue. Microsoft Support has suggested it may be a corrupt metabase caused by the metabase being scanned by Anti Virus software. They further suggest removing and reinstalling IIS and all of my web and mail sites. Oh joy! Roy

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...)...

How does one go about determining which records in a database are at or near the 8086 byte limit?

Thanks for everybody's help. Turns out it was a DNS configuration issue. Once I configured DNS correctly everything worked well. Roy

Questions,questions, questions... 1. How does one determine how long it takes DNS to login on reboot? 2. How does one set IIS to rely on NETLOGON? 3. forcesho, are you advocating two separate machines in your suggestion? If so, I'm out of luck as we are delivering a system to a client and it...

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...

Along this same line, I've just stood up an SMTP server that is designed to send CDONTS messages. My Client (customer, not computer) wants a mail drop for the e-mail address specified in the From field of the CDONTS mail messages. And the system admins don't want me using a bogus address because...

Thanks. It's true that it's difficult to try and move objects one by one, when almost every has a defined relationship to one of the other tables in the database. I wanted to have different logical filenames for the data and log files, but I may just blow it off and back up the first database...

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 can't answer for you whether it's "worth the trouble" but if you need source control that is tied in with Visual Interdev then it's probably your best bet. My first instinct for your situation is that you did not install the VSS Server components. I would check that first. I think...

It always looks so simple in the end!! Thanks, Rajeevnandanmishra. I had tried using a temporary table, but I used a "Select Into" statement that obviously didn't work. This helps me over a major obstacle and I do appreciate your, and Terry's, help.

Terry, Thanks for the help. Your suggestion worked, @NSN2 returned a recordset. But, what I really need to know is how to use the result set of @NSN2 later in the SP. When I try to add the statement: SELECT * FROM TBL_NSN_SOL WHERE nsn in (exec (@nsn2)) to my SP it fails with an incorrect...

Terry, Thanks for your prompt reply. Here's the SP that I am trying to execute. Please note that it is a snippet from a much larger SP that will be inserting as well as deleting records, hence the "Begin Transaction" and "End Transaction". In the interest of brevity and...

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...

Klae, Happy Monday to you. First, as always, thanks for your post. Second, a question about the name of the NSN fields within my form. The NSN input fileds are currently written as such: <td><Input type = text size = &quot;13&quot; id=NSN1 name=NSN1 maxlength=&quot;13&quot...