Search results for query: *

ahhh, but it also works the other way. you can go: select * from table where '1234' in(field1, field2, field3) It will show you any row where it finds '1234' in one of those 3 fields. I just want to make it fuzzier by also using like.

Hi all, Here's what I need to do... I need to find things like '%%12345%%' IN(field1, field2, field3) Is there a way to do this? This is a simple example. I need to look for a substring that may occur in up to 20 fields. If it's there I want to return the row. Thanks for any input, jim

Hi all, I write programs for use in our company. Not a real high security risk. What I'm running into is every year when the temp ClickOnce certificate expires, I have to go into all my different programs and issue a new certificate. I'm sure this is the wrong way to do this, but I don't know...

Hi all, I've noticed in the past few days that my microsoft products like, I.E., sql manager, excel, etc. are acting very slow. This occurs when I.E. is first opened. Instead of popping up to the cached home page, it sits there and chews for 30 to 45 seconds, and then opens the page. In sql...

Hi all, Came in this morning and my company database is in recovery! The transaction log grew to 87gig over the weekend. I can't do anything with the database, not even detach it. How can I kill the transaction log, and get this database back online? thanks for any and all suggestions.

Hi all, Here's my situation. Sorry if this has been discussed, but I couldn't find it. Anyway... Our company has a "canned" website that is using asp.net 1.1. We don't have source code for it or anything helpful. We would like to add an asp.net page that we can call from the canned...

Hi all, One of our servers has a sata raid 5 on an adaptec raid controller. Within a year or so I will need to make the hard drive space bigger. I'd like to think that it is as simple as replacing a hard drive with a bigger drive one at a time, let the raid rebuild, then replace another drive...

Hi all, One of our servers has a sata raid 5 on an adaptec raid controller. Within a year or so I will need to make the hard drive space bigger. I'd like to think that it is as simple as replacing a hard drive with a bigger drive one at a time, let the raid rebuild, then replace another drive...

Hello all, I know this isn't really the place for this, but hopefully someone will know the answer. I've inherited a business website from before the days of CSS. There are hundreds of pages, and each page has the business address and phone numbers on it. It's my job to change all of them to...

Hello, I am trying to create a field that will change between "yes" and "No" based on the following: Another field in the same row will have a number in it. Yet another field on the same row will have a dollar amount. i.e. "yes/no" field, 44567, $500.00 On a separate spreadsheet I will have a...

Hello, My database stores quantity prices breaks for an item in rows, ie. index item qty price 1 1 5 10.50 2 1 10 8.75 3 2 7 12.00 4 2 12 11.30 5 3 6 5.00 up to 4 price breaks per items. I need it to look like this: item qty1 price1...

Hello, We use 2003's fax server in our office. I would like to set up an address book that everyone can access for fax numbers. Problem is, I don't know where to start. Any guidance would be greatly appreciated. Thanks, Jim

Hi all, I recently installed a exchange 2003 server in our office. It came with SBS2003, and I wanted to centrally locate the email, contacts, etc. We are using outlook 2003 with it. Our email is hosted on our ISP. We never deliberately use the internal email feature of exchange. The...

Hi all, Our company is upgrading to new business software based on sql server 2000. The owner wants to be able to send mass faxes, or emails to our customers. When I asked the software people about this, they said their software doesn't support that, but it could be done with a trigger. So...

Yeah, that's what I was doing. I finally got it working. For some reason when the program loads, half way through loading info from the registry, it jumps to saving info to the registry. I moved the parameters I was working with to above that jump point in the code, and all works fine. Still...

OK, I know this might be simple, but I can't figure it out. I need to store a double like 1.03 in the registry. It will populate a textbox on startup, and will save to the registry on exit. I've tried writing it as a string which works, but when I try to read it back in, I get a blank string...

We are getting ready buy business software that doesn't come with UPS worldship integration. So, I've been tasked with making it happen. The software is based on sql server 2000. Does anyone know where I can find information on how to get worldship to talk to the database?

Thanks for the info. That fixed the problem. Another question. Do I use the pop3 connector to download the mail from the server, or does smtp do that as well?

Hi all, I've got a new exchange 2003 server, and I am trying to use it to server internal mail, but also allow clients to forward email through it to the internet mail server. (our email is hosted by our isp) I have set up the virtual smtp server and it will forward the mail. The problem is...

Hi, Our network has an sbs2000 domain controller. We just bought an sbs2003 server to coexist with the other one. I want to move our fax server to the sbs2003 server so that I can send faxes progammatically. When I set the sbs2003 server up on the network, I just added it to the network. I...