Viewing 15 posts - 1,111 through 1,125 (of 1,186 total)
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...
October 5, 2003 at 1:09 pm
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...
October 5, 2003 at 1:07 pm
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...
October 5, 2003 at 1:02 pm
Dek,
Ray is correct. As far as I know the sp's are cumulative. You only need to install sp3a
AJ Ahrens
October 5, 2003 at 1:00 pm
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...
August 29, 2003 at 5:07 am
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,...
August 28, 2003 at 5:03 am
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...
August 24, 2003 at 8:16 pm
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...
August 24, 2003 at 8:12 pm
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...
August 14, 2003 at 3:55 am
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...
August 14, 2003 at 3:45 am
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...
June 19, 2003 at 9:13 am
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 -...
June 12, 2003 at 11:02 am
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...
June 11, 2003 at 2:08 pm
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...
June 11, 2003 at 2:06 pm
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...
June 5, 2003 at 11:03 am
Viewing 15 posts - 1,111 through 1,125 (of 1,186 total)