Thanks Paul, I will give that a go

Cheers Paul. I went for a table lock because the base reference which determines which sequence to use is dynamic, so there's no guarantee that a row for that sequence...

Is that more complicated than it needs to be for my scenario? I can guarantee that the transaction volume will never increase to the point performance will be...

Am I missing something here? I hadn't seen SELECT FIRST before so I tried it, but SQL 2008 won't recognise it. Can't find it in books online either.

Kev

kll (1/20/2010)

---

Good to see examples of the output clause.

The @@identity problem should be a no-problem, if people just remembered to use scope_identity() instead. It will return the correct identity value...

Paul Marriott-463518 (1/19/2010)

---

I can see how this will return the set of inserted values. However, I am not sure that I understand just how we can match this set...

I've taken a closer look - the library that is used for registry access opens all keys with full access. I've modified it to allow read only access. We'll get...

You know, I think you're on to...

Yes, we generally recommend windows security, and this is in fact the first client that...

.Net is on the cards, but the...

Oops, I've just been informed it's a VB6 app, not a .Net app!

> Another "we all hate cursors" article

Not necessarilly. I'm not disputing that cursors have their uses, and when you need one then you need one. However it's certainly worth...

Better still, rewrite usp_Process to optionally accept tabular data, either via a table variable or XML. Okay, not always possible, but when it is it will be far more efficient...

Am I missing something (like it wasn't meant to be perhaps), or has this not actually got anything to do with report server? I initially saw reporting services 2005 and...

> Never mind the features, why is SQL Management Studio so pathetically slow!

> Even if you put the -nosplash switch on the SQLWB.EXE it takes an age to...