Hi

In another blog post by Gail Shaw (a Trio Of Table Variable[/url]) I read that table variables are actually created in tempDB. You mention that SQL is less likely to do so. Are there then circumstances where SQL would/not create it in tempDB?

Thanks