Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trouble with full text search and @@identity

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-18 : 23:13:44
kinni writes "HI!! I was trying to insert data into a table which has full text search enabled. I need the value of the Identity field cause I'm doing multiple inserts and it is the forign key in the other tables. When I do this in the Query Analyzer it returns the Identity field but when I try to access it using ADO recordset it returns a null value. I have used @@Identity in other tables which are not full text search enabled and it worked fine. What am I doing wrong? Help!!"
   

- Advertisement -