With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.
2017-11-13 (first published: 2017-10-27)
540 reads
Almost definetly a permissions problemI suspect you are logged in with full rights, but these are not available to your account that runs SQL Agent as Andrew saysRight click on SQL agent to get properties and examine the credentials from there.Ross
2005-02-28
Hello,When I run DBCC SQLPERF(LOGSPACE) i get an overview of space used by the transactionlog. I got an output of 9% space used for a sms database. After I shrunk the transactionlog, the physical log does not getting smaller
2005-02-28
11 reads
hi ross,I don't have execute rights on xp_cmdshell. is there any other way to execute DTs thro ASP.?
2005-02-25
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers