Hi,

Following links are having SQL FAQ...

http://www.SearchSQLServer.com

http://www.mssqlcity.com

http://www.sqlauthority.com

http://sqlteam

http://www.databasejournal.com/

.....

I would search GOOGLE for more on this...

I also have some old stuff... if you are interested pl. let me know.

HTH.

Thanx.

Vinay

When we study on the question and give answer and found that the answer is wrong we feel bad... so if we answer correct we should get the responce otherwise...

Yes, I tried on Microsoft SQL Server 2000 - 8.00.2039 (Standard Edition) this option is disable on Master database, could be Enterprice edition might be having... question should...

I gone thourgh it and it says.

Stuck I/O is defined as an I/O request that does not complete...

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

....

Thanx.

Vinay

Hey... I was aware that Truncte will reset the identity, I thought there could be an undocumented stuff on 2008( i have not installed) which resets the identity with delete...

I think i could not get the question correct, as BCP we can append data into table. but it overrites flat file.:):)

IS Remote introduce in 2008