Joined: 09 Mar 2007 Posts: 243 Country: United States
SQL Assistant Hang - Reproducible
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: 4605
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
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