Rename a primary key column



hi i am trying to rename a primary using sp_rename. but it keeps failing with
message that the column is involved in dependencies. but i have already
dropped all constraints on this table! any help please
.



Relevant Pages

  • Re: Rename a primary key column
    ... >hi i am trying to rename a primary using sp_rename. ... >message that the column is involved in dependencies. ... Are there any foreign key constraints on other table that reference the ...
    (microsoft.public.sqlserver.mseq)
  • Re: Dependencies in Enterprise Manager
    ... If you rename an executable (e.g. ... SQL Server database objects should be treated similarly to other ... > Dependencies' can give the wrong answers, but I don't remember them all. ... > All of this seems to be a HUGE hole in Enterprise Manager. ...
    (microsoft.public.sqlserver.programming)
  • Re: Demotion DC
    ... but the second DC is failing (Hard Disk problems) so I will need ... You cannot even EASILY rename ... contents of the failing drive to new disk. ... Accelerated MCSE ...
    (microsoft.public.win2000.active_directory)
  • Re: How do I get a list of filenames with spaces on bash?
    ... To ensure that in the event of a failure the original file is unaffected. ... in that case, mv doesn't affect the file not even its inode, it ... affects the current directory, it's just a rename. ... A failing cp may leave an ...
    (comp.unix.shell)
  • Re: Fastcode CharPosRev B&V 0.8.0
    ... I know but it does not make sense to rename a failing function and include ... Jeg beskyttes af den gratis SPAMfighter til privatbrugere. ...
    (borland.public.delphi.language.basm)