Home Forums SQL Server 2008 T-SQL (SS2K8) how to change new schema name from existing schema - Table RE: how to change new schema name from existing schema - Table

  • that error says the table already exists in the hwdata schema.

    do a quick

    select * from hwdata.DesktopSoft_Master

    select * from dbo.DesktopSoft_Master

    decide which one to keep (say dbo was the "good one"

    then drop table hwdata.DesktopSoft_Master

    and try to transfer again.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!