• thanks for your reply...

    what would happen if i delete the user without changing the Owner of the objects ....

    As DB adminstrator, can i execute,open , edit, save as the stored procedures,DTS packages,views even after droping the user without changing the owner....

    Thanks ....

    Pratap