Believe this is how Navicat works if the table already exists. I have version 10 and can only set the identity column and other optional values if the table is new and has not been saved yet.
Alternately, I would suggest writing SQL to do the task. Also you could download SQL Server Express as it comes with SQL Management Studio, which is much better at managing SQL Server installations and databases. Bonus it's free. https://www.microsoft.com/betaexperience/pd/SQLEXP/enus/ Of course this is all Windows reliant. Byron Mann Lead Engineer & Architect HostMySite.com On Tue, Apr 1, 2014 at 7:04 AM, Kevin Parker <tras...@internode.on.net>wrote: > > At the risk of sounding a little daft or maybe missing something that is > plainly obvious if anyone uses Navicat to design MS SQL tables I'd be > grateful for a little help please. I am trying to set an Identity column > but > all the identity attributes (identity, seeding, incrementing etc.) are > greyed out for the column of choice, in fact all columns of any type - have > set the column as an int - Navicat help is extremely basic and unhelpful > and > Googling it wasn't much better. > > > > I'm using Navicat Premium v 11 > > > > Thank you!! > > > > > > ++++++++++ > > Kevin Parker > > > > ++++++++++ > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm