You can use
backup log [database name] with truncate_only
but if you don't want to use the log for any reason (i.e. point in time backups) then I suggest you change the database so that it doesn't keep a record of the transactions at all. Go to Properties of the database and under the option...
You need to left outer join the table that can contains no rows sometimes and then use COALESCE or ISNULL to make the value zero if it's null.
Something like:
SELECT ...., Orig_balance - Sum(ISNULL(AP_transaction_T.Entry_amount,0)) as REMAINING
FROM (Vendor_T
INNER JOIN...
Hi,
I was just wondering if you found a solution to this problem yet? I am experiencing the same thing where everything will be working fine and all of a sudden, users can't login and our same line of code is failing (Set objCrypt = server.createobject("AspCrypt.crypt")). We recently moved...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.