Thanks Alamir for reply,

Actually we have more then 1800 SPs in MS web environment. Earlier we were using ODBC connection to connecting to sql server database till then it was fine. Now we...

Thanks Julian, Yes  i am searchig for the same. I will get back to u. If i find any problem in using it.

Thanks again,

Cheers,

Sheilesh

Hi,

Thanks, I can not drop and re-create as dependent FK are there. The conventional way is drop all the FK's for the PK then drop PK and re-create it as clustered.

It...

Jeff,

Simply Great !!! It will help me a lot.

Thanks again,

Sheilesh

Hi Jeff,

You are really great!!!, Really Cunning. I am teting it , but i am pretty sure it will work. BTW what is your approch for Identity insert issue ?

Thanks,

Sheilesh

Hi John / mike,

Thanks for the beautiful solution. I have already tried the similar kind like data reader, data writer, create sp at database property level,and execute sp by using a generic...

Mike Vessey,

That can be done but that will be very difficult to manage, any other option pl. in same database itself.

Thanks,

Sheilesh

Mike Vessey,

That can be done but that will be very difficult to manage, any other option pl. in same database itself.

Thanks,

Sheilesh

Hi santhose,

Can a role can be created for the following requirement , if yes How ?  

Users are under NT group named AppDev I have to grant create/alter/execute procedure/functions and revoke  create /alter  table/constraints/indexes.

Thanks,

Sheilesh

Oh, robbac, currently we have given db_owner to user group and from the database permissions revoked all "create table" and other rights except "crete procedure" and "create function". db_owner is...

HI robbac,

yes, Users are under NT group.AppDev How use ddl_admin to create/alter/execute  procedure/functions and not to create /alter  table/constraints/indexes.

Thanks,

Sheilesh