I personally dont use this counter as a memory issue indicator.

For my prod environment I monitor and log the Buffer Cache (98-99%) and Page Life Expectancy (Ms recommends over 300,...

Have you set "min" or "max" memory settings?

What do your logs report?

Post all the errors.

Look at the thread below

http://www.sqlservercentral.com/Forums/Topic585961-360-1.aspx

What is the error that is returned?

If you try running one of the statements on its own does it work?

try..

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

I had a similar issue with a script that checks frag and rebuilds.

Depending on how the index was created, or if it is a on a computed column you may...

If you are trying to authenticate with user that was created on the original SQL server you may to the "fixup" the login on the new server.

See "sp_change_users_login" within BOL.

i.e....

Have you looked at the MS article?

http://support.microsoft.com/kb/306212

Try this tread

http://www.sqlservercentral.com/Forums/Topic568847-148-1.aspx

Its sounds like a windows timing issue.

If the server/pc (specifically the SQLAgent user) is out of sync this the domain controller it can causes authentication failure.

Try re-syncing the time with...

As with any Microsoft question "It depends".

(1) If you are just wanting to move the data out of the table then create archive table(s) to move the data in. Then...

Which version of SQL are you using?

In 2005 there are some standard reports via SSMS. Right Click DB | Reports | Standard Reports.

JL

Have you created the DSN on the server and/or the client running reporting services?

Try running the setup and not auto run.