Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: sharkette11
- Order by date
-
How to Reset Full Log File
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...- sharkette11
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Query Question
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...- sharkette11
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Trouble with ASPCrypt
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...- sharkette11
- Post #4
- Forum: Microsoft: ASP (Active Server Pages)
