Francisco Tapia
fhtapia at gmail.com
Mon Oct 4 17:14:02 CDT 2010
I know jc said monitor but it sounds like he wants to see each execution...activity monitor does show you what is running but more high-level as actual select statements or update statements are not completely visible. Sent from my mobile On Oct 4, 2010, at 2:32 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote: > In the Management Studio, > In 2005, it's under > Server - Management - Activity monitor. > > I don't have an instance of 2008 here but IIRC, it's in the same place. > > You can see details of all running processes > > -- > Stuart > > > On 4 Oct 2010 at 16:20, jwcolby wrote: > >> I have code which mistakenly allowed me to start a query multiple >> times. Since fixed. However that does raise the question... what >> happens inside sql server when this occurs. >> >> the code in question was updating a specific field to null when that >> field was equal to ' ' (space). >> IOW I am cycling through a bunch of fields where I have ' ' >> representing no value, to get a >> consistent null to represent no value. >> >> What happens inside SQL Server if I start this same query multiple >> times on the same field? I use a command object to start the query >> running. I assume that if I were to set that command object to null >> back in C#, SQL Server is running the query and continues merrily on >> its way? >> >> So if i do this three times it??? Runs that same query three times? >> Sequentially (end to end?). Consecutively (simultaneously)? >> >> Is there something in SQL Server I can go to see processes or threads >> that are running and see the sql statement that represents the >> process? To see what SQL Statements are currently executing? >> >> -- >> John W. Colby >> www.ColbyConsulting.com >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >