What's that (LISP)??

This is most appropriate here, especially if you don't wanna stop using them :

A quote from rudy komacsar

time for:

exec sp_update_resume

possibly time for:

exec sp_distribute_resume

Check the documentation of that product. It will most likely be listed in the string functions section... Look for anything like substring or the likes.

Takes an agent to get the new messages... Then you have to create some sort of faq db that can figure out what is being asked and reply accordingly... ...

3) Is there no way you can get the users to change ONLY THROUGH THE UI ?!?! I seriously think I would quit my job if I had to deal...

What statement are you using? What error are you getting?

Is this for the final application or for query optimization??

SET STATISTICS TIME ON

Select * from dbo.SysObjects

SET STATISTICS TIME OFF

check the message window.

Have you tried printing the dyn. query and executing it in QA instead? Maybe that'll pop up something.

You might also want to investigate where the bottleneck is. Is it the network? Is it because Access copies the whole db to the client requesing data (as I've...

No need to do that if he's using a command object and the command type adCmdStoredProc.

Yup... but we don't even know if it's possible. We haven't heard from him since he posted the question.

Nice link BTW, feels like home

It's not a religion, it's a fact and we're religious about it . Anyways cursor should be banned (almost) from the sql...

OO is good for programming. What managers have to understand is that a db is not a programming tool, it's a data storage tool. They are not meant...

"or Remi's automated agents will get to it"

Now here's an idea . Would be a nice project to build...

Sounds like a better idea .