Thanks Koen and Sqlnavie,

CTE way is simple. thanks for updating

Hi Koen,

Your CTE query gives incorrect result for 1001 value.

Hi SQLNavie,

I achived the solution using Cursor query. Please find below query

Declare @tempTable as table(id int, value Int)

Declare @value as int

DECLARE @CUR AS CURSOR

SET @CUR = CURSOR...

Supurb Article, I was looking for such article.

Do you have SQL Server 2000 scripts for the same

Regards

Shashi Kant Chauhan

Thanks Bill,

For sharing such a good Upgrade plan Specially the Excel sheet you have uploaded.

How i do this ?.. Can you give me an example or some step by step sort of thing....

Thanks Mate,

This is really a good suggestion to use the EXEC option for dbcc commands

I used this command in this manner

SELECT 'shashi', a.* FROM OPENROWSET('SQLOLEDB',

'DRIVER={SQL Server};SERVER=.;Trusted_Connection=yes;',

'SET NOCOUNT ON;SET FMTONLY OFF;...

Thanks Mate,

This query solves my problem.....

Regards

Shashi kant Chauhan:)

Thanks Patrick Schneider

Nice solution for this problem and your Provide solution

ALTER INDEX index_name ON table_name SET (ALLOW_PAGE_LOCKS = ON)

is working fine in my case.

Thanks & Regards

Shashi Kant chauhan

HI,

There is other alternative available for this header option

You can get this option by selecting these options

Query -> Query Options ->Results -> and then select the option of Include column...

Hi, So far i have not recived any expert suggestion of my problem.

what should i do when my computed column have some relation with other tables column

Regards

shashi kant chauhan

Try....

Sp_helpdb

and

sp_msforeachdb 'sp_helpdb [?]'

Regards

shashi kant chauhan 🙂

Hi to all,

I got the solution of this problem in my case.

As mentioned above in this post First i check the Trigger on my table

using sp_helptrigger 'table_name'

and found there...

Hi chirag,

I am using a single server which have the access to all 500 servers.

If you have any script for doing this either by vb script code or some batch...

I agree with Matt Whitfield

while loop concept is more eassy then using cursor

and this method is good in conceptually but not feasible practically when you are dealing with...