You're trying to grant a user permissions when you do not have permission do do so. The db_executor role I gave you gives the user permission to EXECUTE, which was...

Do you need it as a Datetime? If you don't need/aren't storing the time, then use the datatype DATE.

Does it therefore manage to store any rows? As I said before,...

Can you supply some sample data and DDL (see the link in my signature). Without knowing what your data, especially the date field, looks like, this is going to be...

This technically works, but like i said, how do you know what user needs what user ID? What is your ordering? i have no idea what your DDL looks like....

So where is the data held? If you have a...

I agree with Phil that seeing this error...

When you say you want to replace their name with a user, do you therefore have a username specific users should therefore be assigned? If not, how do you determine...

Ok, yes, this is a different question, what I've answered is how to give the Reporting Services Serive account execute privilegdes.

The db_securityadmin will allow a user to GRANT, DENY and...

CHAR and NCHAR will always use the full amount of characters. if tehre aren't enough, then Whitespace will be added.

For example, on a CHAR(10):

'Home' would become: 'Home ...

Did you add the user to the role? The message is giving you that error for a reason, that account can't execute that sp.

This, for example, works:

USE DevTestDB;

GO

CREATE USER [TestUser]...

Firstly, let's fix your code up a bit. Try to ensure you use IFCode brackets around your SQL. it makes it a lot easier to read for others:

INSERT INTO Metrics(Application,

...

SSRS won't see <span id="END_PAGE"></span> as a page break no.

How is your HTML being returned to you? Can you have it so that each row is one html page?

For example...

Personally I have a db_executor role on our databases (I've added it to our model, so it's on all of our new ones too), and I have added our SSRS...

etl2016 (12/12/2016)

I am seeing that special character on my SSMS query, where as the actual data does not contain that character.

Basically, data type is varchar for both source and destination...

What exactly is your question here? Are you saying that the character, ü, is not the character it should be? What character should it be?