mar1jxm (9/20/2013)
I have seen these type of cases when a Query Designer contains a SELECT INTO statement on a big table or it has several general T-SQL statements (IF, DROP , Cursor... etc). Make sure your Graphical Query Designer is not used for these types of things.
Jacob,
Thanks for the comment, but those sorts of queries are exactly what I'm troubleshooting. And I'm not using the Graphical Designer at all. This is straight T-SQL within the regular query window.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.