Search results for query: *

How do I find out if my ISP allows for SSI? I use godaddy.

I am trying to figure out how to get my header and left side of my pages in one file, and then include that file on multiple different pages. The problem is some of the links have been changing on me, and having to change a couple hundred pages everytime that happens is getting annoying. My...

gmmastros, Sorry for the delay. I got way-layed with some other things. I put it in today, and after going over the code with a fine toothed comb, and a few small modifications - I ran it. The improvement went from 4:50-4:55 (four minutes and 50 seconds to four minutes and 55 seconds range)...

Thank you so much. I am learning a lot about this. :)

gmmastros, I am not familiar with the terminology. What do you mean by set? All the other stored procs also use a cursor, and do not use all the fields.

The follow code is running across 1300+ records in a table, and may have 10-20 records in it. But it is taking 4 and a half minutes. Other stored procedures take like 10 seconds and have way more records (like 200K), and use the same structure. CREATE PROC dbo.kv_updt_RECIP_AUTH_ONWAY2IBM AS...

Thank you both. :)

Hi, I am pretty new to HTML. I have a small website I run on my off time, and I also maintain one at work. There really is not much difficult for me to do at either. I want to set up a form that will allow users to type into a text box some text, and then to click on the submit button and to...

SQLBill, We are all good now. Thanks for your assistance.

Thank you sir. Our network guys have a program they bought that does the back ups, and is supposed to do the truncation, however it is not truncating properly.

We had a salesman set up our SQL server a few years ago. He set up our production databases to unrestricted growth at 10% increase each time. The drive is almost full, and we have one DB that is 3 gig, and another that is 6 gig (on a 12 gig drive). There are a few other smaller DB's as well...

mwolf00, Thanks a lot. Worked great :)

Hi, I have had some users enter social security numbers of 10 numbers instead of 9. I have since added an edit to the entry screen. However I want to find all these records so they can be corrected. I know there is data on the file of 10 numbers instead of 9. I tried this query, and got no...

mrdenny, Not a problem :) I talked to my manager after downloading the trial version. He choked at the price of a license. So I thought about it some more, and realized that the SQL Table is being updated from the Kovis software. That table does not have a field for userID, and update date...

BTW it is Lumigent.

mrdenny, Gotcha thanks. Well I had one manager step forward and admit to making the change. Kinda funny how they remembered after I explained IT had to buy another product, and I needed to spend time working on it.

mrdenny, Thanks. I will see if I can get managament to swing for buying that. What if I wanted to view the log files manually?

We are running a Kovis system with our SQL Server. Kovis has its own DB with tables. Only select users(managers) can change certain data. One of our tables has the lookup data. One of those types got changed, and none of the managers remembers changing it. I need to track who did it, and...

Ian, Have you tested any other jobs to see if they are the same way? The large import of data, how many tables did it affect? It may only be the queries related to that. Sure anytime :)

Ian, Is there a way to "re alter" all queries in one go, so that I can do a "fix all" if I think there is a similar problem in the future? I personally do not know of a way, but I am pretty new to SQL Server(just a year). I am guess ingyou have a lot of queries and do not want to parse them...