Search results for query: *

This is puzzling to me....we are on SQL 2000 SP 4, Windows server 2003. We have several DTS processes scheduled as jobs. When SQL Agent executes the job it reports as being "Successful". However, the file has not updated the data with the export as it should. The job is run using a domain...

We have a recurring issue with the tempdb growing rapidly in a short time. We have set up alerts in the system to forewarn us of such an event, and we've successful in restoring the size of the tempdb to a manageable level before the tempdb fills up completely. Attemping to figure out the...

All, OK got another form/subform question today. In a form/subform structure I have a combo box in the subform which loads relevant values for a particular selection. Example, I'm working on an inventory database. In the subform the user can select from available model numbers and auto-populate...

Hello all, I have a form / subform structure working well. The intent is to enter multiple inventory items for each location. Example, one person's cube may have a workstation, telephone, printer. The Main form identifies the cube's code, the subform is linked to the main form by this code and...

Everyone, I have a table with field ID as an identity, and another field Revision (both are PK, both integer). Many other fields follow. The idea is each ID can have multiple revisions. The problem is I don't want a user to have to enter data every time there is a new revision. I would like...

Everyone, I have not quite seen this in any posting.... Say I have a SQL table: Team League NY Yankees American KC Royals American LA Dodgers National Atlanta Braves National On an Access form, I have a combo box for the user to select the league, either American...

Hello all, I am working with an Access Project. I have an Access Form which is interacting with a SQL table. I want the user to select a value from a combo box, and then have the related data populate other fields on the form. This is frustrating because I got this to work in Access 97 using...

Hi everyone, we have SQL Server 2000 system and data files on one disk (disk A), and transaction logs and backups on another (disk B). We will soon need to replace disk B with a larger disk as it is becoming full. To transfer all logs to the new disk will require detaching the database, moving...

Hello all, this looks simple enough but we're having some difficulty in solving it: We have two tables with sample values as follows: Table1 Table2 A A B B C Y D Z We'd like to join these to create a result set that would show the...

Hello everyone, This seems straightforward enough but I'm having a difficult time getting this to work... We have SQL views and stored procedures which feed a MS-Access report. The report groups totals and gives the percentage of each item's total relative to the group total. Example: Total...

Hello everyone, we have been puzzled long enough, now we are submitting to this group to solicit ideas. We have an Oracle database with a couple of tables which we would like to export to SQL 2000. We set up a DTS, use ODBC to connect to Oracle, and ran the program. It worked. Great. Then, we...