it's a scripting option:

if you go to tools options in SSMS, one of the selections available is "Include collation"

change it, you might have to reirun in a new window, and...

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt

if the database you are executing the query from is not compatibility 9 or above, i think that will fail.

ugh, i hate it when people start adding permissions to public.

this script will generate the REVOKE commands for any permissions granted to PUBLIC to specific objects ;

from there you can...

ok i see that; case sensitive collations, and accent insensitive colaltions will see Ä as matching both 'a' and 'A' for example.

i fiddled with it a little, not much...

clearly you've modified what i posted in order to get the results you are showing. show us the code YOU created.

we can find the issues there.

the CREATE LOGIN process already does that.

for example if you try this command:

CREATE LOGIN [fakedomain\fakeuser] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

you get this error:

Msg 15401, Level 16, State 1, Line 1

Windows NT...

did you try my exmaple? it worked perfectly for me:

/*

DescriptionFoundChar

Nº20º

*/

WITH TBProduct (Description)

AS

(

SELECT 'Nº20' UNION ALL

SELECT 'No Special Characters'

)

SELECT Description,

...

Anders Pedersen (3/28/2012)

---

Performance however becomes, uhm, bad,...

not sure what you mean...do you want to test if mydomain\sureshrajan has a login or has access to a...

here's one way to do it;

the typical chars you are looking for are highascii between 160 and 255;

here i'm just using a row_number() function generate a table of numbers so...

i believe an "autologin" is nothing more than a shortcut that is passing the required parameters.

so if you want it to auto login, you add the parameters, and if you...

also, a view can use or call a function, so if the proc can be converted to a function, that is another option.

you cannot manipulate any column that is ntext,text or image from the INSERTED or DELETED...

depending on what the procedure was doing, you might be able duplicate the logic from the proc in a view by using a CTE or two, but again it really...

Bob Cullen-434885 (3/28/2012)

---

Thanks, Lowell. That sort of makes sense, but why, then, does not the SELECT ... FOR XML do that escaping in the first place? If that isn't guaranteed...