January 9, 2013 at 11:28 pm
Hi All,
I have created a few tables with foreign keys and primary keys. Now i am supposed to change the column name of a table. But when i am doing in tfs it throws an error: i ried dropping the foreign key constraints and altering the column name still dint work. can anyone please help.
Thanks,
January 9, 2013 at 11:31 pm
Please provide ddl and the error message you are getting.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 9, 2013 at 11:40 pm
when i try the syntax exec sp_rename 'table.columnnameold', 'columnnamenew' it executes in ssms
but in tfs it throws an error: VwA has no reference object or have an ambigous reference
January 10, 2013 at 12:37 am
In TFS you shouldnt need to use the SP_rename you should just be able to alter the column name in the relevant underlying projects.
Are you using a DB project in VS or do you have SSMS hooked upto TFS?
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply