Francisco Tapia
fhtapia at gmail.com
Mon Oct 4 17:06:34 CDT 2010
Check out the profiler, expand the tree section under the events so that you can capture the SQL statements starting and completed.... This will show you what is processing, there are also rpc batches events that might be useful, I'm away from my pc at the moment so I can't double check. Check out on google SQL server profiler so you can trace the event. Sent from my mobile On Oct 4, 2010, at 1:20 PM, jwcolby <jwcolby at colbyconsulting.com> 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 >