> NOT using a stored proc and the @@Identity method, so what about using > CF in line queries.
If you're using SQL Server 2000, you should use the SCOPE_IDENTITY() function because it can't be affected by triggers. However, if you don't want to used stored procedures or the SCOPE_IDENTITY() function, then you could probably do a transaction with a table level lock. and pull the Max(identityColName). Now, whether or not that's the _best_ way... Ben Johnson ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists