However having said that and having to come to know this system which I work on quite a bit there are "SELECT INTO" strewn all over in SP's which would mean there is an additional reason which I believe is probably the combination of 3rd table sitting on the foreign server. Net SqlClient Data Provider) using SQL Server Management Studio. My hypothesis is that the SELECT INTO locks the system table which stores the new entry for the destination table and the EM can not access this table to build/refresh the list in its menu's thus causing the lock error. What I did however do was change the code (not mine by the way) to drop the table then recreate it and then do INSERT INTO, SELECT FROM instead of the SELECT INTO. SQL Server Error: 1222 Severity: 16 Event Logged or not: No Description: Lock request time out period exceeded. SET LOCKTIMEOUT 10000 inside the SP and with con.createStatement ().execute ('SET LOCKTIMEOUT 10000 ') before calling the SP. Sometimes, during this publishing process we got an error: 'Lock request time out period exceeded'. I've managed to trace it back to a "SELECT INTO" statement in an SP which runs for about 26 minutes in a job where one of the 3 tables in the select sits on another server but I'm not sure if this has anything to do with it. WorkQ WASys00000006151B244E Msg 50000, Level 16, State 1, Server BIDSSql, Procedure CommandExecute, Line 1, Lock request time out period exceeded. To resolve this behavior, use one of the following methods: Click to clear the Override connection string time-out value for table designer updates check box for the table designer and for the database designer in SQL Server Management Studio. That latest link does not work or there is a temporary problem with the site. Msg 1222, Lock request time out period exceeded Command: UPDATE STATISTICS BIDS. 122329 for the first time i experience the following message when trying to expand the tree (ie Stored Procs etc) in Management Studio.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |