Monthly Archives: August 2006

pdf toolkit

29-Aug-2006 Posted by Sonia Hamilton under
No Comments

pdf toolkit (debian package pdftk) can “join and split PDFs; pull single pages from a file; encrypt and decrypt PDF files; add, update, and export a PDF’s metadata; export bookmarks to a text file; add or remove attachments to a PDF; fix a damaged PDF; and fill out PDF forms”. See Manipulating PDFs with the PDF Toolkit.

See also a topic I wrote on the Unofficial Ubuntu 6.06 (Dapper Drake) Starter Guide, called How to pull apart and combine pdf files.

See also http://g-scripts.sourceforge.net for Nautilus Scripts.

todo: notes on NAUTILUS_SCRIPT_SELECTED_FILE_PATHS, Gconf-editor, gconf-tool

log shipping hints

25-Aug-2006 Posted by Sonia Hamilton under
No Comments

select * from msdb..log_shipping_databases
select * from msdb..log_shipping_plans
select * from msdb..log_shipping_primaries
select * from msdb..log_shipping_secondaries
sp_get_log_shipping_monitor_info

sp_delete_log_shipping_secondary
sp_delete_log_shipping_primary
sp_delete_log_shipping_database

exercise – move system databases

24-Aug-2006 Posted by Sonia Hamilton under , ,
No Comments

In this exerise, you are required to move two of the system databases (master and model) to c:data. Here are some web pages that may help:

Steps:

  1. move master
    • change the startup properties for the server, to point to a different location for master
    • stop the server using Administrative Tools, Services
    • manually move master’s database files using Windows Explorer to c:data
    • start the server using Administrative Tools, Services
    • in Enterprise Manager, check the properties of the master database, to ensure that master is running from the new location (more…)

howto get Flash sound working in Ubuntu Dapper

22-Aug-2006 Posted by Sonia Hamilton under , ,
No Comments

When I upgraded to Ubuntu Dapper, Flash sound stopped working in Firefox – oh no, no more YouTube!

An easy fix:

 sudo aptitude install alsa-oss
 sudo vi /etc/firefox/firefoxrc
 FIREFOX_DSP=u201daossu201d

Thanks to macewan.org

howto move sql server system databases

22-Aug-2006 Posted by Sonia Hamilton under
1 Comment

Here’s a couple of links on how to move the MS SQL Server system databases:

In a nutshell:

  • for master, change startup parameters in Server Properties, stop SQL Server, move files, start SQL Server
  • for other system databases, restart SQL Server using Trace Flag 3608 (-T3608 startup param), use sp_detach_db and sp_attach_db, restart without Trace Flag
  • if SQL Server won’t start because of an error in the startup settings, the settings can be edited here:
 HKLM/SOFTWARE/Microsoft/MSSQLServer/MSSQLServerParameters
Next Page »