Hi,

Are you modifying the SP's via EM? If so drop and create the SP with QA it will work if you set the ANSI settings there.

If it aint broke don't...

Hi,

Can you describe the Oracle Table or send me the data types of the columns.

If it aint broke don't fix it!

Hey Jonathan - You beat me to it! - Anyway yours is better - less code!

If it aint broke don't fix it!

Try this

IF EXISTS (SELECT name FROM sysobjects

WHERE name = 'CREDIT_CHECK' AND type = 'TR')

DROP TRIGGER CREDIT_CHECK

GO

CREATE TRIGGER CREDIT_CHECK

ON Customers

FOR INSERT, UPDATE

AS

BEGIN...

Hi,

Have you had any luck yet? Sometimes changing the query to openquery helps.

If it aint broke don't fix it!

Hi

RTM = Shipping version of SQL Server with no service packs.

You should load Service pack 3a.

If it aint broke don't fix it!

Hi,

I have had this problem before and the solution was to create the procedure from QA not EM.

Do you have to create the proc from DTS? Could you not call...

Och! Aye!

I wish ur a verra mickel SQL gura!

If it aint broke don't fix it!

Hi,

My method of automating the moving of SQL 2K DTS packages might not be the best way but it works for me. I inherited servers where the developers used hundreds...

Hi,

I had this problem as well and the solution was simple. Set the ANSI settings and create the proc from Query Analyser not from EM.

If it aint broke don't fix...

Hi,

I dont' know is this is a good idea but what about creating a trigger on the sysdatabases table in the Master Database...

If it aint broke don't fix it!

and whatever you do make sure that you monitor over the month end. Sometimes a proc lays dormant until the new month.

If it aint broke don't fix it!

You are correct. I must have been smoking my socks....

If it aint broke don't fix it!

Here is my humble offering

The connection string must contain pooling = true and min connections and max connections

Does the connection string explicitly state these properties as pooling is set as...

Look up on BOL for

sp_resetstatus & DBCC DBRECOVER (database)

If it aint broke don't fix it!