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!
-
Syslogs
In SQL Enterprise Manager, Edit the database, click on options and ensure the "Truncate Log on Checkpoint" is checked.- bigbak
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Do you use it?
It's taken me a while to reply, but. We've had good experience with it. Seem to be a bit in limbo if a row is locked on the client, then released and then fire the update business object. Not the quickest thing in the world, but if the package is left running when idle, object creation is...- bigbak
- Post #3
- Forum: Microsoft: Microsoft Transaction Server (MTS)
-
Do you use it?
Does anybody here use Transaction Server, or am I the only sucker.- bigbak
- Thread
- Replies: 15
- Forum: Microsoft: Microsoft Transaction Server (MTS)
-
Cascading Updates
You'll have to write a trigger.- bigbak
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Performing backups of SQL Databases?
Go to Server, Scheduled tasks from the menu in Enterprise Manager. Your best bet is to use the Database Maintenance Wizard, this will allow you to set up scheduled tasks for all maintenance topics. -
Apps. as a process-only
Go to ActiveX.Com and download an OCX that will do all the work for you.- bigbak
- Post #2
- Forum: Visual Basic (Classic)
