Dbezze is fine for small amount of rows say 2000. It keeps write to the text box , becoming heavy after a lot of rows .

a5xo3z1 use a "status" field ( I add also a timestamp , and a user field ). But adding a column on a production table sometimes it's not possible, but...

I've read again all the posts and I think there's no way to wrap stored procedures so you can run a SP that you don't have permissions . If so,...

If your DB has a lot of transactions its probably your Transaction Log it's growing and growing. We used to have one DB that had 7GB total and 5GB Just...

Usually some dba don't want do give permissions for xp_cmdshell ( very powerful ). So if you want to manipulate files ( create, read ,etc ) try use sp_OA's and...

quote:

---

(...) log file to shrink ?

Why don't you try to run a schedule job with the 2 steps:

BACKUP LOG [<BD_name>] WITH TRUNCATE_ONLY

DBCC...