http://www.devx.com/tips/Tip/17668

I found some different ratings to this articles.

It will be better to get a feed back rather than just a rating.

Is there any way that I can see who rated...

Jim Underwood ,

I also found it unreadble. I think this formatting is introduced when publishing the artcle.

Thankx Frank,

I wonder y they have not doucmented.

I fonund folowing code from the internet

DECLARE @version    VARCHAR(100)

EXECUTE master.dbo.xp_regread 'HKEY_LOCAL_MACHINE',

  'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion',

  'CurrentVersion',

  @version OUTPUT,

  'no_output'

I agree with u Frank Kalis

Even you can get more points by posting same twice.

Even for the replices like 'Thankx' you will...

if exists (select * from tempdb..sysobjects where id = object_id('tempdb..#t_sp_who_output'))

   drop table #t_sp_who_output

go

CREATE TABLE #t_sp_who_output (

 [spid] [smallint] ,

 [ecid] [smallint] ,

 [status] [nchar] (30)  ,

 [loginame] [nvarchar]...

From BOL. I think u will get ur answer from this

Authentication Modes

Microsoft® SQL Server™ can operate in one of two security (authentication) modes:

• Windows Authentication Mode (Windows Authentication)

better if u can put the name of the poster in the emial body as well

agree with INFO01

1st answer is the most correct answer.

therefore 4th is incorrect!

This is BOL says

Explanation

This error occurs when the nonclustered index indicated by the index ID is in error. The corruption is detected when a process tries to delete a nonexistent...

I got your point now

Thankx

I thought u were saying some error in my method.

Use OPENXML

DECLARE @idoc int

DECLARE @doc varchar(1000)

SET @doc ='

<ROOT>

<Customer CustomerID="VINET" ContactName="Paul Henriot">

   <Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">

      <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>

      <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>

   </Order>

</Customer>

<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">

   <Order CustomerID="LILAS" EmployeeID="3"...

NO SIR,

If I didn't update just after reading there is chance of getting same number for both records.

To avoid that I am updating the Next number Just after reading.

My argument is if both users are using same type. they will get same number there can be duplicate number unless u update it just after reading.

OK Frank Kalis 

Say I have 1000 records

And i have open ado which has page size  = 100

there fore there are 10 page

If...