Yes! That's what I wasn't seeing. I couldn't find an LPAD() function in T-SQL so I did this:

DECLARE @TOPPART VARCHAR(32)

DECLARE @COMPANY VARCHAR(8)

DECLARE @PADDING INT

DECLARE @INDENTCHAR CHAR(1)

SET @TOPPART =...

The problem is that I can't see how any direct sort of my CTE data is going to produce the results I want, which is a fully-expanded indented tree in...

Thanks Jack. I'm getting this error with your query:

Msg 240, Level 16, State 1, Line 5

Types don't match between the anchor and the recursive part in column "sortkeynum1" of...

Thanks for the response. I'm still looking for some specific guidance on the userid/password question -- otherwise I only have part of the solution.

Looks like this might be the...

If I detach, change the server collation or just reinstall, and then reattach, do the user DBs retain their original collation settings (and can I reattach them)? I'm assuming...