Odd EM Behaviour creating PK - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Odd EM Behaviour creating PK

Author

Topic

mr_mist
Grunnio

1870 Posts

Posted - 2004-08-24 : 06:17:33

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

3564 Posts

Posted - 2004-08-24 : 09:57:59

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/

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-24 : 21:23:13

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources