Viewing 2 posts - 1 through 2 (of 2 total)
I found this useful bit of code :
Run the following script changing the xxx for the database name, run against master.
SELECT 'dbcc dbreindex(''xxxxxxx.DBO.' +name+ ''')'
FROM sysobjects WHERE xtype='U'
This...
October 31, 2012 at 9:50 am
#1554680
Thanks for the reply guys,
GilaMonster - I think you gave me the perfect direction to investigate in, I can see all the information I need to identify the user/process...
April 2, 2012 at 6:14 am
#1467583