Yes,It is correct,

but before using IDENT_CURRENT,I have exclusively lock the table,So if there is already an exclusive lock on that table,the second process will wait,until the exclusive lock has been...

Sorry I forgot to say that @NumberOfIDsInBlock is input parameter, and I had considered 10 in my example(I forgot to use 10 instead of @NumberOfIDsInBlock in my sample).My main...

Guys,

Thanks a lot for your replys.I have done the same thing ,but this does not work.

Here is senario,in my "operation section" I am giving block of ID's to different Objects.Yesterday...

Thanks.for your reply,but my question is:Is this a kind of bug for SQL SERVER 2008,Because as I said the same transaction did not fail in SQL SERVER 2005?

Here is sample data that I have in log file:

03/04/2009 08:01:15:215 Create Session: 011.202.111.123, 502184, ed5cb1c53cdd6fa2c19a2e84c493te0c3e09d731603/04/2009 08:01:15:324 New page access: 011.202.111.123, 0,...

Thanks alot for your reply,Even when I added Flat file connection instead of Flat File Data source,still I have the same issue.Instead of recognizeing all columns(6 columns) .I have only...

Here is the result of DBCC ShowConfig,By considering Scan Density,Logical Fragmentation,Page Density, Should I do DBCC IndexDefrag or DBCC ReIndex?Cause Of the size of Database(which is pretty big) ,should I...

I have done DBCC ShowConfig on that table and Scan Density it about 77% and I do not have any maintenance plan for rebuilding the index on this table.Should I...

Thanks for your response,

but unfortunately it didn't work.

yes it has IIS,.NET FrmaeWork 2.0 and SQL SERVER 2005 Developer Edition on windows 20000