BeeeeeeeeeeeeBoooooooooooShshshshshshhhhhhhhhh....

😀

anbillava (12/29/2008)

---

if i use SET IDENTITY_INSERT TableDelPrim ON and column list then i need to make

it for whole application. It takes lot of my time.

Is there any other work...

I think that it is not a statement terminator because it does not meet the definition of a...

Christian Buettner (12/29/2008)

---

RBarryYoung (12/28/2008)

---

Christian Buettner (12/28/2008)

---

I might be nitpicking here again, but the semicolon is required after the preceding statement, not before the WITH statement.

Of course the end result is...

I think that you could merge the CLR & .NET forums. The responders tend to be the same and most of the OP's are not really clear on the...

You need SQL Server to create a SQL Server Database.

If you have SQL Server installed, up and running, then in order to create a database, you connect to it and...

borismoyse (12/29/2008)

---

Using RAID1 has no performance increase over using a single disk so essentially the only way of gaining any performance is to allow SQL to do the stripping which...

The reason that I think that my exercise (above) may prove enlightening to us is that I suspect that different groups of people get something very different form the Forums...

For what it's worth, I think that one exercise that we should all try is to seriously consider what good the forum Taxonomy/Structure truly does for each of us individually.

I...

Nope. That is NOT how it works. As I explained earlier, DELETE will NOT reset the Identity counter.

Here is a test script that I just wrote:Set NoCount ON

CREATE...

Cool.

Identity values should not "reset" unless you TRUNCATE the table. So, just make sure that you use DELETE instead of TRUNCATE.

Yep,...

The most important thing about "Separation By Versions" is so that the responders know what versions they should craft an answer for. And as we all know, even having...

Yes, good point, Gail. I should have picked up on that from Grant... 🙂