can you give table srtucts?

always have a seperate os partition, for data recovery's sake.

Even on my desktop I keep data and apps on a seperate partition in case my os goes toasty.

Raid...

sp_helptext <procname>

Steve Jones had an article about selective auditing a few days ago. Check it out,

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart4selectiveauditing.asp

Another option may be to go DOD and turn on C2 auditing,  

http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx

Or use...

If you are only working with the last day or week worth of data you could setup a trigger that copies some of the rows being inserted into the statistics...

Are you using VM's? You may be able to configure memory management through the host's parasite(virtual machine) manager.

You should put performance counters on the server and see if its really memory...

Check this page out, it directly addresses what you are looking to do. http://www.sommarskog.se/dyn-search.html

This will even allow you the option of passing in say, parameters 1 and 3 or only...

Run a profiler for 30 minutes or so and see if you can step through events and find out what app is calling the sp. (log to a table -...

Its a simplified and obfuscated example. dont get l33t on me.

5 casts added to that method resulted in no more syntax error and a second working method. Thanks Jeff!

My god the timeout on the message board is annoying. You cant even go back to recover what you have typed.

The folder items column list should be (folderid, nodeid,...

If you know of a way to eliminate the need for a cursor in this situation, that would be AWSOME. I havent figured out any way to get around it...

It still doesnt like it. Can you try adding the @conditions into your test and see if yuo get the same result. It may be something I am stupidly typing....

exec doesnt understand the table variable and wants me to declare it. Its assuming its a local.

Exec robs me of the ability to share variables between the sp and the EXEC.

Am I missing something?