Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Fail to get query plan

Author  Topic  nr SQLTeam MVY 12543 Posts Posted - 2001-07-30 : 14:53:15 I have a table with 5 fields, 1155 rows. fields numeric 11,0 numeric 11,0 varchar(20) null varchar(30) null varchar(80) null select 1 from tbl works ok select 1 from tbl group by any of the numeric fields works ok select 1 from tbl group by any of the varchar fields **** fails to generate query plan (hangs) update statistics - no effect dbcc checkdb - no errors select * into nr from tbl where 1 = 0 hangs (but will generate estimated query plan) create table hangs create procedure is ok No open transactions nothing in error log Obviously something wrong with database but I would like to find out what tonight. I will recreate the database before tonights production run so doesn't affect that. The database tables and SPs are transferred every night via sql dmo. ========================================== Cursors are useful if you don't know sql. Edited by - nr on 07/30/2001 15:17:59