January 5, 2010 at 8:34 am
Greetings all,
I clearly recall Enterprise Manager locking tables when building views. Does management Studio also have this problem?
January 5, 2010 at 9:03 am
Are you asking about a schema lock or a data lock?
If you use the GUI query designer, it probably does issue a schema lock while you're building the query. Haven't tried it, since I type my queries instead of using the GUI.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 5, 2010 at 9:33 am
Data lock. EM use to lock the table resulting in calls from disgruntled users. I agree its preferrably to actually type your queries but occasionally I want to drag and drop for ad hoc query creation.
January 5, 2010 at 9:50 am
I just popped open the view designer, dragged a table into it, and then ran a separate query on a separate connection (different SPID), and it wasn't blocked. Not a conclusive test, since it was all done on my local computer from the same session of SSMS, but seems like it should be a valid proof that it doesn't do what you're worried about.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 5, 2010 at 11:18 am
On further investigation I came across this link which recommends some changes to SSMS settings to avoid what they call "unintentional issues in production environments".
http://sqlserverpedia.com/wiki/SQL_Server_Troubleshooting_Tips_and_Tricks
See Query Execution Settings section
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply