GilaMonster (6/2/2011)

---

talismc (6/2/2011)

---

GilaMonster (5/29/2011)

---

I appreciate what you're saying Gila Monster, but this isn't the problem that I am having. My code works well and is done accordingly to my clients...

rhlangley (5/31/2011)

---

Take the ID and @courseid values out of your insert statement. By having them there, you are attempting to give it specific values. Skip that value and...

Gaurang-Patel (5/30/2011)

---

talismc (5/29/2011)

---

Here, I wrote a statement to create a new table to see if it would work but...

GilaMonster (5/29/2011)

---

When you have an identity, it must not be specified as part of the insert statement, as SQL handles the value. Change your insert statement to

INSERT INTO Course (Name,...

Here, I wrote a statement to create a new table to see if it would work but I still...

Sorry lutz, you may need to dumb that down for me.

What's the OUTPUT clause?

When I executed DBCC CHECKIDENT <tablename> is just gives me the error Incorrect Syntax.

Thanks guys, this is helping me to understand sort of what's going on.

So I tried taking out the SET IDENTITY_INSERT ON and OFF from my sqlcommand statement in my vb.net...

Yes it is. 🙁 Otherwise the option to set the increment and seed are disabled.