SQL Server Management Studio Express and Locks
-
I am not sure, but I am trying to work this out but if I do a CREATE SCRIPT SELECT on a TABLE and execute it using SQL Server Management Studio Express, will it lock access to it for transactional or for update purposes? Like a read commted? or am I going off track here as I am not completely sure about SQL stuff.... :confused:
-
I am not sure, but I am trying to work this out but if I do a CREATE SCRIPT SELECT on a TABLE and execute it using SQL Server Management Studio Express, will it lock access to it for transactional or for update purposes? Like a read commted? or am I going off track here as I am not completely sure about SQL stuff.... :confused:
Have you installed service pack 1 for SQL Server 2005. This seems to make the front end stable.
Look where you want to go not where you don't want to crash. Bikers Bible