I like ChrisM's approach but this may also help?

-- Get the distinct RBR \ XLOC values and OUTER to CRE values

-- Then do the same for RBR \ CRE

--...

Hi John

Thanks - was sceptical about this but just tried it and sure enough.

You learn something new every day I guess...

Rgds

The main question (I think) is unanswered:

If you have removed BUILTIN\Administrators and all other administrative access to the SQL instance, how can you log into the SQL instance with administrative...

Hi Steve

Thought provoking words from the editor as usual.

In the UK, many large organizations have adopted an outsourcing strategy. This can range from the simple release of the support...

Hi Jacob

Nice and well written. You can also pass the data via temporary tables i.e. create the temp table in the caller proc (or prior) and refer to it...