SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in SQL Assistant Hang - Reproducible      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic SQL Assistant Hang - Reproducible Author Message judahr Joined: 09 Mar 2007 Posts: 319 Country: United States SQL Assistant Hang - Reproducible SSMS 10.0.5500.0 6.0.86 PRO Code: SELECT 'EXEC sp_rename ''' + c.TABLE_SCHEMA + '.' + c.TABLE_NAME    + '.' + c.COLUMN_NAME FROM INFORMATION_SCHEMA.[COLUMNS] c WHERE c.DATA_TYPE = 'timestamp' Start with the above. Add a + at the end of the select. Process hangs for a long time with one core pegged. Have about 20 tables in the database and only a few have a timestamp column. No other addins installed. Pasted this code in 3 times and hung each time. Fri Jan 20, 2012 10:09 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7849 I tried that and I can reproduce it as a long freeze. On my system it takes almost a minute for the cursor to start blinking again and nearly 100% of CPU I will submit this issue to development for further analysis Sun Jan 22, 2012 11:21 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.