Yep, took a copy, did the one way upgrade and worked on that 😉 after what you said, I wanted to see what happened using a SSDT project and keeping everything...

Thanks for the reply Thom.

In what way(s) is it incompatible? I took a copy of one of my current 2008 BIDS projects, migrated it to SSDT and all...

I love this idea. I can immediately see a potential use for this that warrants some further research. I work in the legal sector and can see that this might be...

Thanks Eirikur

I had tried using SQLCHAR 0... instead of SQLNCHAR 2...  previously, I didn't get errors but did get 0 rows. ...Thinking back I might have been using a...

Anyone else unable to access this article? Tried from two locations:

ERR_TOO_MANY_REDIRECTS

Looks like you're using optional parameters, have you tried using OPTION(RECOMPILE)?

have been caught out with that before:

http://www.sommarskog.se/dyn-search-2008.html#static

I have used the method here, with a bit of modification to achieve what I think you are trying to do:

https://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/[/url]

Edit: sorry re-read your post and probably not entirely suitable!

It's definitely given me food for thought.

Not that I can change it in this case, but I am doing some reading on the arguments over lookup tables.

Thank you Ken. Spot on.

I used

INNER JOIN Folders AS f

ON dcl.cdType = f.cdCode

AND f.CodeType = 'Folder'

rather than a LIKE though.

I had got so close to that...

Celko: thanks for your reply. I think I probably didn't explain things as well as I could have.

First, this has not been developed in house, it is part of an...

Duran: Have you managed to get any further?

It looks like you read the same article as me before coming here. Typical Microsoft response "It's broken, we're not going to...

What a complete idiot I am.

I previewed this 4 times checking code and spelling etc. When reading it through one final time after posting I found the reason, a silly...