How to handle Log full issue :-
1. select * from syslogshold
go
2. sp_who '100'
go
3. sp_showplan '100' , null,null,null
go
4. dbcc sqltext(100)
go
5.kill 100
6. re-run query in small batch to prevent log full issue.
1. select * from syslogshold
go
2. sp_who '100'
go
3. sp_showplan '100' , null,null,null
go
4. dbcc sqltext(100)
go
5.kill 100
6. re-run query in small batch to prevent log full issue.
