Hi Clark,

In which are the situation I can use TRANSFER keyword.? any other purpose of this keyword?

If a developer on the system has permissions to create object and they get created under there user schema rather than dbo then the objects can be moved to the default schema.

My use case was to move specific objects out of dbo schema and into a new schema that I had created for my "billing" objects.

Please not this can break existing code and needs to go through validation before implementing in prod.

I am not sure if you read it or not, but I have a blog post on this right here: http://beyondrelational.com/modules/2/blogs/77/posts/11380/sql-server-t-sql-alter-schematransfer-option-change-the-schema-of-a-database-object-type-or-xml-sche.aspx

@Robert: The post covers one of the experiences I had personally a couple of years ago when I discovered the ALTER SCHEMA statement. Hope you find it useful.

Wow, thanks for this post. Thank you clark and Nakul