• Thanks Mike for the reply...but one strange thing here in my scenario i canot change the schema to dbo coz the same objects exists on dbo schema as well as testuser.

    So will it be better

    1) to drop the schema then drop the user

    2) create the schema again and assign it new user created.

    or is there any other best way to do with out droping the schema?

    Cheers!!