cdun,

What is it that the sp is supposed to do? If you are using it to return a flag stating whether or not a record is approved can...

If your nightly process corerctly loads your DEV environment there should be no issue loading the others.

Instead of dropping your FKs why don't you load your DEV and then load...

It might be that the proc when it runs is ignoring the NULL values and is returning all of the NON-NULL data.

Are you sure you want your application to fail...

Dek,

Ray is correct. As far as I know the sp's are cumulative. You only need to install sp3a

AJ Ahrens

webmaster@kritter.net

Carol,

Please find a modified version of the TRIGGER. I had tested it with different tables and apologize for the problem.

The issue is (I think) that you need to...

Carol,

I think that the below might work for you:

Create Trigger neworder1 ON statorder AFTER UPDATE AS

EXEC master..xp_startmail

EXEC xp_sendmail

@recipients = 'carol.feuerriegel@mcmahonclarke.com',

@query = 'SELECT * FROM statorder where CONVERT(VARCHAR,...

EM defaults to Table1 due to legacy naming conventions from prior MS products. IE Access. When you create a 1st instance it is object1 then 2 (after...

I am definitely NOT an expert with Oracle or have used it very much however,

Do you have the data-type conversions (if needed) set properly for the fact tables?

What does...

BrokenRulz,

The compatibility level of 80 = SQL 2K. To check this look at the properties of any/all of your databases on the Options tab.

AJ Ahrens

SQL DBA

Revenue Assurance Management...

We also get this message from EM. However, in our case I think it is easily explained:

we are still in a token-ring environment and use TCP/IP as the...

Unfortunately, this is started automatically. I have found KB 328885 and some others. I have patched the server with a fix for the above KB (received from MS...

Carl,

to turn logging on: Open DTS package, click on the package menu option then the logging tab.

Should be good to go from there

AJ Ahrens

SQL DBA

Revenue Assurance Management -...

Carl,

Are you executing the DTS as the same user that is used to automate the schedule?? If not the issue may be permissions.

Good Luck,

AJ Ahrens

SQL DBA

Revenue Assurance...

Fryere,

There is an issue with Access and update/delete/insert statements wih tables that don't have primary keys.

Remember that once you have added the keys/index(es) that you have to re-run the...

Sounds to me like you are using it correctly. You may want to look at the queries that are using indexes that you think are not correct and review...