Recent content by OV

If anyone who is interested, I went to the metadata DB and ran the following query: select OBJECT_NAME,ABBREVIATION from DSSMDOBJINFO A inner join DSSMDUSRACCT B on A.OBJECT_ID=B.OBJECT_ID where OBJECT_TYPE =34 and SUBTYPE=8704

Chael I don't see a command for that in command manger. Everything in command managerrequires to specify a user. OV

Does anyone know how to generate a list of the users in the system, with their names and logins. Thanks OV

I have several date fields in my tables that do not have a value. For example a shipment date does not have a value until something is shipped. Date fields are defines as integers in the fact tables. However, allowing them to be null, causes problems with aggregate tables (These date fields...

Never mind. I did it, using a relationship filter. OV

I have the following problem. For every job in the database we can have one or more salesperson. Example: Job Salesperson Sales 1 1 $100 1 2 $150 1 3 $120 2 1 $300 Total sales of salesperson 1 in this case would be $100+$300=$400...

I guess, I should ask another question here: Besides the error log file within the DTS package, is there another way to log the errors? That may give me a little more information that I can use.

dyarwood, It seems that while the database is getting bigger, the problem happens more frequently. However, the problem ocurrs at different steps, some of which are not transfering any data. OV

Rasanders, thanks for the sugestion. However, after looking at the logs, it appears that backups were done way before DTS package started to execute. OV

Hi Everybody, I am having problems with a DTS package that runs nightly. It is always the same error but it happens at different steps of the process and at different times. It happens on average of once or twice a week. The rest of the time it runs fine. Some of the steps where it has failed...

Hi Everybody, I am having problems with a DTS package that runs nightly. It is always the same error but it happens at different steps of the process and at different times. It happens on average of once or twice a week. The rest of the time it runs fine. Some of the steps where it has failed...

Yes, It will allow you to hardcode SQL.

thanks asudevil. It appears that changing the session timeout fixed the problem.

Hi, One of the users is having trouble exporting to PDF. Some of the reports will export fine but some others will not. The user does not get an error; nothing comes up when he clicks on the "Export to PDF" button. My initial thought was to check the limit on the number of cells allowed to be...

Does anyone know how to create a report in Enterprise Manager that gives all the reports not used in a time period? thanks, OV