We define authentication mode at Server Level. Client utility just passes the credentials.

Troubleshooting: Login Failed for User 'x'

http://msdn.microsoft.com/en-us/library/ms366351.aspx

FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error:...

I shared following with you yesterday. Didn't it help?

http://support.microsoft.com/kb/305333

I didn't get you... 🙁

Backup includes SQL Server Backup as well as OS backups. Please check with your IT team if they have any OS backups of...

Execute following query & verify whether your SP exists in your database. If yes, which schema?

USE <database_name>;

GO

SELECT name AS procedure_name

,SCHEMA_NAME(schema_id) AS schema_name

,type_desc

,create_date

...

It's a serious issue. It's time to Call CSS.

BUT Read...

Wouldn't you like to know the reason of failure of your code? 😛

Did you check Error Log & Event Log?

Sean Lange (11/30/2011)

---

Dev (11/30/2011)

---

Lowell (11/30/2011)

---

with Org(Business_Line)

AS

( SELECT 'Blue' UNION ALL SELECT 'Orange' UNION ALL SELECT 'Others' UNION ALL

SELECT NULL UNION ALL SELECT 'Yellow' UNION ALL SELECT 'Green' UNION...

Why did you disable the trigger? Altering it with matching ANSI_NULLS setting should be fine.

Will you not loose trigger functionality, if you disable it?

Lowell (11/30/2011)

---

with Org(Business_Line)

AS

( SELECT 'Blue' UNION ALL SELECT 'Orange' UNION ALL SELECT 'Others' UNION ALL

SELECT NULL UNION ALL SELECT 'Yellow' UNION ALL SELECT 'Green' UNION ALL

SELECT 'Red' UNION ALL SELECT...

Database Mirroring Administration How-to Topics (Database Engine)

http://msdn.microsoft.com/en-us/library/ms175059(v=SQL.90).aspx

Sean Lange (11/30/2011)

---

Jeff Moden (11/30/2011)

---

Actually, there's a great way to track it without a trigger if you can add a column as Kingston suggested. The difference is that you...

Is there any Indexed View defined on the table? Following issue is related to 'ARITHABORT' setting. It might be applicable to 'ANSI_NULLS' as well.

PRB: Error "INSERT Failed" When You Update...