Remove DISTINCTROW for it is not valid in SQL Server.

Use the Group By on columns in which you are not performing an aggregate.

Unfortunately I can't address your issue for the following query.

SELECT DISTINCTROW qry_Reports.Func_Name AS Function, qry_Reports.MgrName AS Manager, qry_Reports.Assoc_Name AS Associate, Sum(qry_Reports.Total_Proc) AS Processed, Sum(qry_Reports.Prod_Hrs) AS [Productive Hrs], Sum(qry_Reports.Paid_Hrs) AS [Paid...

Agreed, you should use sp_send_dbmail:

http://msdn.microsoft.com/en-us/library/ms190307.aspx%5B\url]

You will need to configure a mail profile before you can use it:

http://msdn.microsoft.com/en-us/library/ms189879.aspx%5B\url]

You could also check out http://www.sqlshare.com/

Have you tried anything that was suggested?

It has been a week already since you opened your post. I hope that you do not have any time constraints.

I would suggest that...

Can we see your code as well?

sqlquest2575 (7/1/2011)

---

Hello Friends

I am migrating MS access Db to SQL 2008 and I am using SSMA to accomplish this task. But I’ve couple of questions.

1. When I run ssma...

Bad! :w00t:

That is good to know. Sounds like someone or something is changing the permissions.

Is the machine that you are loosing the mappings on a Dev & QA Box?

Please answer!

Someone or something removed the permission to the database for these Logins.

It did not happen by itself.

Auditing?

When you say that an Account lost it's mapping to the Database could you be more specific?

Specifically what happens and when does it happen?

Do you have orphan users?

Go for it...

Start by creating an SSIS Package using the example that...

You are joking right? 🙂