If i have 10 other SQL servers making the same call how can it be an Oracle issue? Possible the Oracle client on that Sql Server. and making explicit columns...

was a fix ever found? I am having the same problem with SQL 2008r2

Thanks for your reply.. We don't use FK... 🙁

Are there other indexes on the table? (besides the PK and CI) - Yes

How is the data inserted (in CI...

Thanks, i ask because this connection is defined within the package, and when it is selected as part of running the package via a sql agent job(so it is selected...

Thank you kindly...down to 14 seconds....

i will be looping through 20 times based on locations in a table.

TY....

Hi,

I am now experiencing an issue where 'SQL' users are not allowed to insert into the DDLEVENTS table?

Does granting 'public' only work with windows AD users and group?

The server principal...

Giving the Service account 'domain admin' privileges for a brief time allowed the SPN error to correct itself or register properly.

Thank you

I have tried all these fixes an none worked....any other suggestions?

changed service account

drop server name/re-added.

Any other suggestions. In our environment this happened out of the blue....a user called and...

Thank you for your assistance! much appreciated!

CREATE TRIGGER DDLTrigger_OBJECT

--ALTER TRIGGER DDLTrigger_OBJECT

ON DATABASE

WITH ENCRYPTION

FOR CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE, CREATE_TABLE, ALTER_TABLE, DROP_TABLE

AS

BEGIN

SET NOCOUNT ON;

...

</p>

did it!!!

Thank you Soooo much...

Yes i run the Proc and use dbmail(not select or print)

EXEC msdb.dbo.sp_send_dbmail

@profile_name='tets_profile',

@recipients=@Recipient_Email, ...

Hi,

I am running into this same problem, i changed the job step to point at :

C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe

have the job running as Operating system(CmdExec)

"C:\Program Files (x86)\Microsoft SQL...

Stepping through this is see that it is evaluating each IF statement during each iteration...not what i wanted..