How can I change identity property in SQL Server 2008? -

-

I have a table with no identity columns. Server 2008 is not allowed. So, how can I change the identity properties in SQL Server 2008?

Under Tools -> Options -> Designer -> Table and Database Designer

Need to rebuild the table to prevent unchecked change


Comments

Post a Comment

Popular posts from this blog

SQL/PHP: Table design question -

-
I have two tables, called a "cart" and what I call "items" That the cart be able to store a "item" and a list of quantities. That's why I have created another table "cart_items" which contains the ID of the template, the ID of the item and the quantity. Is this a good design, or should I add another area for the ID of "cart_itim"? Or is there a better way to do it all together? When I try to update my car, I am just running in trouble, my cart items do not update properly, what am I going to do all "cart_times" by car Is connected and then to re-add each "cart_item" and I can not help but it seems that there should be a better way This is a very good design. In the words ER (unit relationship) there are many relationships between objects and cart, through this I mean that an item can appear in many different trains and many different in a cart - Different items may be included In this context ...
Read more

c# - PInvoke of NetUserAdd returns 24 -

-
I am calling NetUserAdd and it is returning 24 for each call. Does anyone know 24 stands for? When I do not know what the error is, it is very difficult to debug it. I'm calling it a Windows XP machine running as a local administrator. I am also a local administrator on the target computer. I tried to do it with USER_INFO_1 and it worked fine. I need a level of control given by USER_INFO_2. This shows the return value for this call. They are further defined by numeric values. Unfortunately none of these values ​​= 24 I know this is a very specific question. I think I'm hoping to find a PInvoke / NetAddUser expert who can help me out there Here in case my code matters. [StructLayout (LayoutKind., Choracet = charset.unycode)] Public structure USER_INFO_2 {name of the public string; Public string password; Public int password_age; Public entities Private; Public string home_dir; Public string comment; Public integer flags; Public string script_path; Public int auth_...
Read more

NHibernate Passing Session to the Repository -

-
How do I go about passing a session for a repository class? We say that I have two projects 1) TestSite 2) Business Objects The Republican Business Objects Project is included in the project. The NHibernate session has been opened in the test site project. Now, I want to use the same session because the test site initiates the transaction on that session. Currently, I am using the following: var repository = New Customer Resor (_session); Of course, it looks ugly! I'm thinking in some way that a dependency injection frame can be tilted and I can be provided without entering the repository with the ejection object. In our WCF service, we actually use a unitofwork that wraps an operation and stores ISSN for that operation. . The repositories know how they are receiving a hint from the current unit of work under which they are running In case of testing we have a base test class, Those who are included in any test class, who touch the test database, we then control t...
Read more