Unanswered: Read only access to all databases on a Server
How can I provide a user read only access to all the databases on the server. I have 15 databases on the server. I know I can give db_datareader access in each database individually but that is time consuming and I have 10 servers for this to be done.
denotes that the subsequent string is in Unicode (the N actually stands for National language character set). Which means that you are passing an NCHAR, NVARCHAR or NTEXT value, as opposed to CHAR, VARCHAR or TEXT. Unicode is typically used in database applications which are designed to facilitate code pages which extend beyond the English and Western Europe code pages, for example Chinese. Unicode is designed so that extended character sets can still "fit" into database columns.