Yes, I was looking at the Task Manager Performance tab's "Page File Usage History" graph. When I restart SQL Server, it drops back down to normal levels (about 3-4GB)....

Alright, thanks for looking at my code. I'll try letting the tempDb grow for a few days and see if it 'levels-out' at a new, larger size.

The other problem...

Is it possible that the tempDb will now just need to 'hover' at a larger size, and there is nothing really 'wrong' with the sproc?

Yes, I've been restarting SQL just since this has started happening - obviously, not an ideal work-around right now. I originally noticed there was a problem (somewhere) when other...

Jason, thanks and sorry, I posted the wrong sproc! I've edited to the correct one now.

Well, I wanted to try it, so here it is.

/*2011-05-19 Line breaks added by junk.jjk*/

PRINT 'Active Directory Query Script'

PRINT ''

PRINT '... Creating link conenction to Active Directory'

GO

IF EXISTS (SELECT srv.name...

ditto. Please post in multiple lines.

First, thank you for looking - and all help offered is gratefully received and appreciated.

I have a similar problem through SSMS. For an unknown reason, my linked server to...

First, thank you for looking - and all help offered is gratefully received and appreciated.

I have a similar problem through SSMS. For an unknown reason, my linked server to...

I am curious how you view the flip-side of that. Should "dev's" be similarly knowledgeable about dba work it truely be considered "dev's"?

Thanks for the agreement. Yeah, I tried that route, just to see what it comes up with, but the original is so convoluted I just have to manually trudge...

I've decided to begin normalization in the current Access database, then migrate to SQL. 🙂