My personal opinion, it that the 2008 tools are vastly superior, and I have encountered no insurmountable difficulties myself.

As a trivial example: once you have been able to run the...

ncodner (3/19/2010)

---

@WayneS - you're saying if I do the deletion in a loop there will be no locks on the table? Is this better than specifying 'no lock' in the...

Let him read the other thread, and the article referenced there. No doubt that...

Yes, in an active thread in this same topic! 😉

http://www.sqlservercentral.com/Forums/Topic882092-391-1.aspx

This topic has just been discussed in detail in another thread:

http://www.sqlservercentral.com/Forums/Topic885718-360-1.aspx

It is pretty comprehensive.

Lighten up, dude! :laugh:

Me too, but it's not terribly important. There could have been another option..."it depends".

For the record, I ticked Steve, the question writer,...

Dark, lots of stars, 15°C - about 52°F I think.

Ah. :blush:

An...

Yes it mentions that in the second...

No, no, no! Please read my prior post on why not to use SET ROWCOUNT for this!

The command is SET ROWCOUNT...

Good idea, Peter. Sorry if I stepped on your toes there - it just seemed like the thread has wandered away from the point you made earlier.

Martin Stephenson (3/19/2010)

---

Not a great example but the data set is a bit limited.

If I wanted to find 'B & S' there would be no results returned because the full...

AndrewSQLDBA (3/19/2010)

---

When using the Database Diagram app within SSMS, you can easily change a column's property to an Identity column. Select the column in the table that you would like...