Search results for query: *

Thank you for all of the replies. I think there is a lot of useful info here that I can use in several situations I am dealing with. Gladys Gladys Clemmer

FVTrainer, Wow, lots of info!! I don't have access to the VB code for this particular application, so I think the stored procedure method will work for me. Thank you so much for your help. Gladys Gladys Clemmer

Thank you mjia. Will let you both know how it works out. Thanks, Gladys Gladys Clemmer

Thank you Zhavic. I will give it a try ASAP. Gladys Gladys Clemmer

FVTrainer, They are running it from within a VB app. I am using Avery Label 5161, so there are 20 labels per page. (2 x 10) I have a parameter field that allows them to specify one item that they need multiple labels for. They may need 1, or they may need 50. Thanks, Gladys Gladys Clemmer

Is there any stored procedure I can run that will show me all of the tables with 0 records in a database? Thanks, Gladys Gladys Clemmer

I have a report that allows the user to specify an item that they want to print a barcode label for. Now I need to add the capability for them to print multiple copies of the same label. I can set up a parameter field for them to choose the number of copies they want, but I don't know how to...

Are you sure they are in the page header and not the report header? Gladys Gladys Clemmer gladys.clemmer@goldkist.com

How do I suppress a pageheader for a Group Footer that I want to print as a separate page? If I use "Not OnLastRecord" in the conditional suppress box in the PageHeader section, I might not get any pageheaders at all because the last record may be on the first page. I need it to...

I left that company over a year ago, so don't have immediate access to the code any longer, but I believe that I did wind up using a running balance field on the report. However I am working on something similar to it today, so I will advise you if I find a better way to do it. Gladys Gladys...

Fantastic! Thank you so much Naith. Gladys Gladys Clemmer gladys.clemmer@goldkist.com

I have a report with a couple of group footers that contain running totals, and a report footer with a grand total. I have a page break after the second group footer, so everything is fine until the end of the report - the report footer prints on a page by itself. Is there any way to force it...

Thanks, I was afraid of that because it is on a very busy server, but at least I can just resort to that and stop wasting time looking for an alternative. Thanks, Gladys Gladys Clemmer gladys.clemmer@goldkist.com

Thanks, Terry. Turns out I cannot do anything anyway because of two active processes that are using the database. I can't kill them, I can't force them to process, I can't detach the database, can't shrink the log file size, etc. Do you have any ideas on how to get rid of them? One is in...

Thanks,Terry. I read some of the info on the links you provided and I think detach, attach will work for me. After I detach the database, I want to delete the log file, but since the the database name no longer appears in the database list, how do I delete the log file? Do I delete the physical...

I have 3 DTS packages that run each night to bring data (Access 97 databases) from 3 different servers into one MS SQL 2000 database. I had to cancel a package the other day, which put it in rollback status, and it never did finish. I finally had to end task, which left two processes in current...

Hi, Terry. No, we could not kill the process that was in rollback status. We finally just stopped and started SQL services to reset everything. This whole thing started because my DTS package was logging all transactions, which is unnecessary for this particular situation, and the log file...

Thanks, Carrr. Tried both of those, but the problem is there are a couple of processes running against the database that have put it in a "busy" state, so the normal procedures won't work right now. A manual backup of the database quit responding, so we cancelled it, and now we cannot...

Does anyone know how to "kill" a database? I read in BOL that the syntax is object.killdatabase(database name), but I am not sure what "object" refers to. I cannot stop/start SQL services because of some mission critical databases on the same server, so I am thinking of...

Is there a simple way to rename a DTS package? I have been opening the package in design view and doing a "save as", but I would like to rename the package instead of copying it. Also, if I choose "disconnected edit", do I need to reconnect the package when I am done? Thanks...