SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Odd EM Behaviour creating PK		  Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

mr_mist
Grunnio

United Kingdom
1870 Posts
Posted - 08/24/2004 :  06:17:33  Show Profile  Visit mr_mist's Homepage
Okay, if I create this table

create table tab1 (servername sysname)

Then go to enterprise manager and try to change "servername" so it's the primary key I get a box saying "property cannot be modified".

But I can do

alter table tab1 add constraint pk_tab1 PRIMARY KEY CLUSTERED (servername)

'Tis odd.

-------
Moo. :)

jhermiz
Flowing Fount of Yak Knowledge

USA
3564 Posts
Posted - 08/24/2004 :  09:57:59  Show Profile  Visit jhermiz's Homepage
Bug in EM, I've ran into the same thing several times :(

Jon
www.web-impulse.com

Can you dig it: http://www.thecenturoncompany.com/jhermiz/blog/
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts
Posted - 08/24/2004 :  21:23:13  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message
Bug in EM?? NO, tell me it ain't so.

EM Sucks!

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000