Search results for query: *

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

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

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

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

This may not be the correct forum for this question, but I am starting here and will move on if necessary. I need to import data from ten Access2000 databases on three different servers into consolidated tables in a SQL 2000 database located on a fourth server. I created one package that...

I have a form that asks for several pieces of information, date being one. How do I make the date repeat in all records that are added while the form is open? The current date will almost never be used, so I can't just do a = date() function. Thanks, Gladys Gladys Clemmer...

I have a form with a couple combo boxes and have set my properties to "Limit to List". I would like to use the "Not InList Gladys Clemmer gladys.clemmer@goldkist.com

When I create a query in Access 97 and click on ShowTotals, every field gets the "GroupBy" keyword, but I only want to group on certain fields, not every one. Should I create a query in the SQL window instead or is it possible to do this in the query builder window? For instance, I...

When I registered my SQL server in EnterpriseManager, I used NT authentication. Then I created a database and I am the owner instead of sa. I tried to fix it using "Exec sp_changedbowner 'sa', but the error message said that sa is already a user of the database, and nothing changed...

Hi. I need to know where to start. I need to create a job using SQL Server 2000 that will import data from a text file and insert it into a pre-existing table. The table will get truncated before the import is done. A new file is created only when a batch cycle is run on the mainframe...

I backed up a SQL 2000 database that I need to restore as a copy on another SQL 2000 server. It is about 8GB in size. How long should it take? I've been watching it for over 5 minutes and there is nothing showing in the progress bar. Gladys Gladys Clemmer gladys.clemmer@fifsg.com

I am creating a pmt history report. I need to show the customer's new balance after each transaction. The beginning balance is easy - it is the amount borrowed. The hard part is recalculating the balance after each pmt is applied. All I really need to do is add the amount paid, which is a...

I have a report with an embedded form that asks the user for an account number. After they enter the number, they click on the Preview Button to see the report. If they enter an invalid number, they will get a message box telling them to re-enter the number. What I want is for the field to...

How can I improve this code by using variables for FirstSpace and NextSpace? It works as is - I just am trying to learn something. SELECT Space(13)+[CUS-LOAN] AS ACCOUNT, Right("0000000000" + cast([FIC-AMT-PAST-DUE]*100 as varchar),10) AS AMOUNT_DUE, [FIC-SOCSEC] AS SSN...

In Query Analyzer, I typed in the following: "Select space(13)+[cus-loan] as account from Minimaster" It returned a list of loan numbers all starting with 13 spaces. Next I typed in: "Select space(13)+[cus-loan] as account, [cus-name] from Minimaster" This time I got the...

In Query Analyzer, I typed in the following: "Select space(13)+[cus-loan] as account from Minimaster" It returned a list of loan numbers all starting with 13 spaces. Next I typed in: "Select space(13)+[cus-loan] as account, [cus-name] from Minimaster" This time I got the...

I need to split a name field into two fields (FirstName, LastName) in a query, but not change the underlying table. The original field contains many combinations of first, middle, and last such as: Mary Jane Doe John D. Doe Mary Jane Von Trapp John D. Doe Sr. John Doe I think you can see what...