By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

New trigger stops scope_identity / @@identity from working

P: 2
Hi everyone, I hope someone can help me out!

I have added a trigger that gets fired on INSERT and which itself inserts data into another table WITHOUT an identity

I used to get back the @@IDENTITY and I changed this to get back the SCOPE_IDENTITY so I was not affected by the trigger.

However, after adding the trigger I get this error regardless of whether I use @@IDENTITY or SCOPE_IDENTITY:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to bigint.

Could anyone shed any light on this please? I have had to delete the trigger for now to get it working again and all the articles I can find tell me that scope_identity should do the trick???

Many thanks in advance,

Jun 9 '06 #1
Share this Question
Share on Google+
1 Reply

P: 2
Fixed it - no need to reply!
Jun 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.