Images don't get displayed in the forums. You'll have to post the text version of the error.

??? where does varchar(50) come into it? I don't recall seeing where the poster mentioned anything about field definitions. Are you working on some other problem?

And this fixes the data truncation how ??

Ok, as the query is referencing syspermissions using an INNER JOIN, if you haven't granted any permissions to objects then they're not listed. If you change the joins to outer...

From your response I gather your not familiar with how SQL Server utilises memory. What you have described doesn't sound like a problem to me. It sounds like normal operation....

Well you do know that SQL Server does a lot of data caching

10GB into 2Gb will probably...

Also, be wary of any implicit conversion that may be going on as part of your calculation. It's always best to explicitly cast static data used in calculations.

From memory, I think there was a script in the script library that does that.

http://www.sqlservercentral.com/search/turbo.asp

Ok, I'll skip past all the obvious arguments against using dynamic SQL

If you use the date format 'dd mmm yyyy' you should...

You can use a Dynamic Properties task to assign Global Variables to the appropriate properties in the Send Mail task.

You would need to put an ActiveXScript task on the "On failure" workflow that sets the Execution status of the truncate table step to Waiting.

There is an article on

"no parameters but far too long to post"

Nothing is too long to post

"Presumably, the query processor can't identify any statistics to work...

This is more to do with Windows Security than SQL Security. You should try logging in as an Admin and setting the Local Computer Policy. Don't know exactly which rights...

I use http://www.discountasp.net and find they're pretty reliable.

Have had a website there for over a year with nothing but scheduled outages. They have web-based admin for SQL Server,...

What size databases do you have on the server?

Do you have SQL Server set to dynamically manage it's memory?

What else is running on the server that needs the memory?