(Answered) Sql server 2012 for a database management

Management Studies

SQL Server 2012 for a database management class. Identity_insert isn't working. I can see it set properly in the config, but isn't resetting the generated value to 1, like I need it. Looked online and found a query, but obviously there are some problems with it. The database is HandsOnOne, the table is Address, and the column - which is also a primary key is AddressID. How do I get this to work?

SET IDENTITY_INSERT [HandsOnOne].[Address].[AddressID] ON

INSERT INTO [HandsOnOne].[Address].(AddressID)

SELECT (AddressID)

FROM [HandsOnOne].[Address].

SET IDENTITY_INSERT [HandsOnOne].[Address] OFF

View complete question

Business Management, Management Studies

Category:- Business Management
Reference No.:- M92093527
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Business Management

Explain the formation of friendship groups such as those

Explain the formation of friendship groups, such as those seen in dorms among first year college students, in terms of these principles: proximity, elaboration, similarity, complementarity, and reciprocity

Jo work as an admission coordinator for an assisted living

Jo work as an admission coordinator for an assisted living facility that just enacted its 5-year strategic plan. However, no one has communicated any of the components of the plan to any departments. Instead, management ...

1 what is the boolean expression for an and gate2 what is

1. What is the Boolean expression for an AND gate? 2. What is the Boolean expression for an OR gate? 3. What is the Boolean expression for a NOT gate?

When should you do a business plan when might it not be

When should you do a business plan? When might it not be necessary or even advisable to do plan? Describe the major sections to be included in the business plan.

Describe the differences between top-down and bottom-up

Describe the differences between top-down and bottom-up budgeting.

What would be ways to engage motivate and recognize reward

What would be ways to engage, motivate and recognize (reward) volunteers and staff in a nonprofit organization.

Imagine your workplace is experiencing low productivity and

Imagine your workplace is experiencing low productivity and staff are experiencing poor morale due to customer service difficulties. Access and read your organisational customer service policy. Based on this document, ev ...

Elasticity 4 please show your steps and calculation- use

Elasticity: 4% (Please show your steps and calculation- use Arc elasticity) In year one, Mike's income was $56,000 and went to the movies a total of 24 times. The next year, Mike's income increases to $68,000 and he saw ...

There are hundreds of sample business requirement templates

There are hundreds of sample business requirement templates and examples on-line. Search, pick two and discuss what you like, what you do not like, and how you would change them. Be sure to include links in your answers.

Suppose that the residents of bora bora play golf

Suppose that the residents of Bora Bora play golf incessantly. In fact, golf is the only things that they spend their money on. The consumer basket consists of 1000 golf balls, 100 clubs and 500 tees. In 2016, they spent ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Business Management Expert