[GENERAL] Restoring db objects , help needed

hello, Is it possible to restore a DB Schema in a different schema but in the same Database? or restore the schema with a different name? or restore a set of objects into a different schema from where they were backed-up? thanks in advance Hugo ---(end of broadcast)-

[GENERAL] change user password

hi, is it possible to change the current user's password from a function/stored procedure , I mean, is there a system function/stored procedure to do it? like the dbo.sp_password found in adaptive server anywhere. thanks in advance Hugo ---(end of broadcast)-