Try adding the Stored Procedures RPC:Started and RPC:Completed events. This may show the parameter values.

Do you have Anti-virus installed on the SQL Server you are trying to send mail from? I know that McAfee blocks email from DBMail with it's Access Protection Anti-spam...

Lynn Pettis (3/2/2009)

I've been fighting that fight here. How about:

1) Off-site storage...

The expression I gave above is in T-SQL syntax which means I'd do it as part of my OLE DB source query, if your source is SQL Server. Another...

Is the issue with the display confusing users or with the value being passed by the parameters to the dataset query? I suppose it could be both, but could...

For readability I would probably put this in Custom Code. Something like this:

Function GetStartDate() as Date

' if the first of...

Here is a query that returns the events in the Errors and Warnings Category which I think will have what you are looking for.:

SELECT

TC.category_id,

...

If you right click on your connection and select properties you will see an Expressions property in the property list.

Click the ellipsis (...) on the right hand side...

Do you McAfee anti-virus installed on the server? It has a rule in it's Access Protection that will block email from being sent unless you put the sending email...

You would need to re-write your query to return a row for April. This may mean creating a Months table or CTE and joining to it. Something like:

Select

...

Can you post the code you are using?

How are you currently implementing Current Month?

What are your data structures?

You could also check out SQLDigger[/url]

SSRS 2000 is not compatible with VS2005 you need VS 2003. There used to be some 3rd party products that allowed you to develop SSRS 2000 reports and some...

Carriage Return is ASCII 13 so in your query you could do:

Replace(CHAR(13), ' ', [column with carriage return]

This will remove the carriage return.

You just need to be careful because sometimes...

Let me second ALZDBA's opinion. Any action that requires access to resources outside the database should not be in a trigger, but should use Service Broker or some other...