Hi Folks, I did a few searches of the help with no luck.
I'd like to occasionally script out some of our DB objects during business hours when DB is in use. I am concerned however about the level of locking involved while the tool is generating DB scripts.
Can you advise? I assume schema locks are one type of lock happening during script generation?
The design of the scripting process assumes is that no one is changing the objects or data while DBG is scripting. DBG therefore uses minimum or no locking when scripting. Scripting assumes the operator has started the scripting process at a sensible point in time.
To script the database objects DBG queries the schema information which this should not have much impact on users who are querying the business data or running stored procedures etc.
Sql Server lock levels when scripting DB?
Posted - 06/02/2015 : 17:59:43
