123 reputation
4
bio website
location
age
visits member for 1 year, 9 months
seen Sep 19 at 17:15

Sep
19
awarded  Organizer
Sep
19
revised Find reason long running stored proc SQL Server
Added tag for correct version of SQL server
Sep
19
awarded  Editor
Sep
19
suggested suggested edit on Find reason long running stored proc SQL Server
Sep
19
comment Find reason long running stored proc SQL Server
What version of SQL server?
Sep
19
comment Find reason long running stored proc SQL Server
Can you post the stored procedure up? We may be able to find the cause there. Also, if it is being hit every 2-3 seconds, the likelyhood is probably a lock on a table
May
20
comment Display query which SSMS executes from Interface/WYSIWYG edits
There is also a button that looks like a script with a floppy disk. If you hover over it, it should read 'Generate change script'. The button is part of the table designer toolbar.
Feb
26
answered How to import table's data in MySql from Sql Server?
Feb
15
awarded  Teacher
Dec
17
awarded  Supporter
Dec
17
answered Automatic create SQL database and table relationship