Hi Ashish,

How do i check whether the user having enough permission..

Regards

Balaji.G

How...

final option.(not to be made)

its asking remote username and password

i given the correct credentials details..

but its shows error

thanks

balaji.g

Hi Ashish,

I checked there.. but there is no sqlserver native client option..

Meanwhile

i tried to create from 2000 to 2008.. It shows the following error

like

[DBNETLIB][ConnectionOpen(Connect()).] Sql Server does not exist...

Hi,

could you pls shared me, where can i use this....

use 'sql server native client 10.0' as provider.

Regards

Balaji.G

Hi Karthick,

Thanks fo your instant reply ...

Can you tell me.. which is the best way to upgrade from sql 2000 ...

we ran the nested sp.. its getting error... its hard to find out.. so that only i 'll try to execute

a each sp's from nested sp..

thanks

balaji.g

Hi Jack,

In that nested stored procedure having sp1 calls sp2 and sp2 calls sp3 and so on..

i need to execute a single sp alone...

Thanks a lot Craig

By

Balaji.G

I want do for all objects.. I think its difficult..

Can you tell is there any alternate solution..

Thanks

Balaji.G

Hi,

I had restored a db name as rescon to sqlserver 2008.. actually it was sqlserver 2000 database..I tested one of the SP.. its getting error.. Invalid...

Hi,

select a.name as objectname,b.rows from

sysobjects a

inner join sysindexes b on a.id=b.id

where indid>2

this query returns objects names and rows only.. if you want to find out...

i don't want cursor..

how do i change this SP,with out affecting the business logic..

if any ideas.. suggest me..

its urgent

Thanks

Balaji.G

Hi,

create clustered index c_app_xyz on xyz(app) with fillfactor=80

in xyz table, app is int, and also identity...

Excellent Article Gail

Thanks a lot

Balaji.G