anybody from MS ... i am waiting for your reply.....

Yes Definitely. it is of nvarchar() and is there in 2nd resultset too.

Thanks for the help.

I am explaining my prob:

create eproc test_2ndrec

as

begin

select name from test_N1 where id = 2 -- returns single row single column

...

Hi Chris,

Thanks for your reply.

but the problem is types and number of columns are not common in both recordset.

Thanks

Manoj

Thanks again Lynn.

But it should come with intellisense right? i mean it is one of the feature of 2008 right?

but it is also not there in the installed version....something is...

so in all we can say it is impossible to recover lost password?

Thanks for reply lynn.

We had installed SQL Server 2008 Client only and it is displaying 2010 only in Help -> About menu but not in SELECT @@version.

My Question here is does this code works in SQl Server 2000, i guess it wont work in SQL Server 2000 also, becuase you are mapping to reference of object...

Hi VS,

Based on error mentioned by you:

"the Smaple errors were like this:

Server: Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 206623779. The text, ntext, or image node...

You can get consistency error mostly for

the values might be entered into the database that are not valid or out-of-range based on the data type of the column. In SQL...

You can get consistency error mostly for

the values might be entered into the database that are not valid or out-of-range based on the data type of the column. In SQL...

You can get consistency error mostly for

the values might be entered into the database that are not valid or out-of-range based on the data type of the column. In SQL...

Actually, i have found solution for this problem.

it was permission related issue, after changing dbase owner it is working.

Manoj

Thanks for your reply lynn.

But i have change compatibility level from 100 to 90 then took a backup of 2008 database.

logically this should work, if i am not wrong.

please any...

But if i am not wrong we could add instances in SQL Server 2000, by right clicking

enterprise manager and create and register new instance by giving name of the instance.

i...