G² (2/6/2009)

---

SQL won't sort it that way by default because '{{{' comes before 'www' alphabetically. You could sort by ASCII code like you suggest, although I can't guarantee that...

Thanks Greg, but I need that "curly brackets" to be the last in the resultset, so what character should I use instead of "{"?

It's a compatability level, there you go.

Thanks a lot!

Thanks Michell,

I understand that, the question is rather why it was working for years (and still is for all other databases), but suddenly does not with this particular one.

Again, to...

Rebooting Server did the trick

Thanks!

Same problem here, but after executing exec master.dbo.sp_helpfile I see no double backslashes and CREATE DATABASE still does it with \\ in front of db name

Any advise? Thanks!

P.S. Oh yeah, and...