Wednesday, March 21, 2012

Primary key in views.(SQL Server 2005)

Hello,

When I use MSSQL Server 2000, primary key in views(The primary key of base table) detected by sql server 2000.
But, new version (2005) do not this, that mean when I "Modify" a view in Enterprise Manager, there is not any Identity filed in list and I have some problem in my programming.
Please help me.Not sure I understand the request. What are you trying to modify. You can always use query editor to create/alter/modify a view's definition.

Can you elaborate more.

No comments:

Post a Comment