Newsgator Go 2.2.7 download

August 30, 2009

Newsgator Go Install directly to your BB

Other download and install options


Managing MSDE 2000 or SQL Server 2005 Express Edition using osql utility

August 24, 2009

Specify a Single Transact-SQL Statement

To run a Transact-SQL statement against the local default instance of MSDE 2000, type a command similar to this one

osql -E -q "Transact-SQL statement"

where

  • E uses Microsoft Windows NT authentication.
  • q runs the Transact-SQL statement but does not exit osql when the query completes.

To run the Transact-SQL statement and exit osql, use the Q argument instead of -q.

To run a Transact-SQL statement against a non local default instance of MSDE 2000, type a command similar to this one

osql -Usa -PmyPassword -S .\MyMSDEInstance -q "Transact-SQL statement"

where

  • U uses SQL authentication.
  • P password for SQL account.
  • S non default instance.

Attach and detach MSDE databases

August 24, 2009

To detach a database directly from the command prompt:

osql -U sa -P MyPassword -S MSDEInstance -Q "sp_detach_db 'databasename'"

To detach a database from within MSDE:

osql -U sa -P MyPassword -S MSDEInstance
1> exec sp_detach_db 'databasename'
2> go

To attach a database directly from the command prompt:

osql -U sa -P MyPassword -S MSDEInstance -Q "sp_attach_db 'dbname', '$DBPATH\dbname.mdf', '$LOGPATH\dbname_log.LDF'"

To attach a database from within MSDE:

osql -U sa -P MyPassword -S MSDEInstance
1> exec sp_attach_db 'dbname', '$DBPATH\dbname.mdf', '$LOGPATH\dbanme_log.LDF'
2> go


Running SQL scripts in MSDE

August 24, 2009

OSQL -Usa -PmyPasword -S .\MSDEInstance -i myScript.sql

How to back up a Microsoft Data Engine database by using Transact-SQL…

 


Websense services start and stop sequence

August 20, 2009

Occasionally you may need to stop/start/restart the Websense components. E.g. if you edit any Websense *.ini files, you must stop and then restart services to implement any changes or backup Websense configuration files.

If you are stopping or starting multiple services, stop Policy Server last, and start it first.

For example:

Stop services in the following order:

  • Other Websense Services (DC Agent, Explorer Report Scheduler, Log Server, Real-Time Analyzer, Reporter Scheduler, Usage Monitor)
  • Network Agent (this service may be on a separate machine)
  • Filtering Service
  • User Service
  • Policy Server

Start services in the following order:

  • Policy Server
  • User Service
  • Filtering Service
  • Network Agent
  • Other Websense Services (DC Agent, Explorer Report Scheduler, Log Server, Real-Time Analyzer, Reporter Scheduler, Usage Monitor)

Websense KB: 2893


How to bypass “runonce” web page to save Internet Explorer 7 settings

August 15, 2009

After installing Internet Explorer 7 all users are supposed to save their settings, the IE automatically redirects the page to “http://go.microsoft.com/fwlink/?LinkId=74005” which redirects to “http://runonce.msn.com/runonce3.aspx” till the user saves the settings to set their preferences such as the default search engine, whether turn on automatic Phishing Filter, language settings and so on.

Follow steps below to disable auto-direct to this web page. Two values should be added/modified in the registry, so that IE 7 will go to the home page instead of the external link above:

  1. 1. Open the regedit.exe applet.
  2. Go to registry key: HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
  3. Right-click this key and select New -> DWORD Value.
  4. On the right pane, create the new value to RunOnceComplete.
  5. Right-click RunOnceComplete and click “Modify” and set the value data to 1.
  6. Repeat Step 3 to Step 5 to create/modify the value name RunOnceHasShown and set the value data to 1.
  7. Restart the IE 7 to see if it still visits the Save settings web site.

To make changs via .REG file, create and use the one below:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
"RunOnceComplete"=dword:00000001
"RunOnceHasShown"=dword:00000001

Note: IE7 will query the two values RunOnceComplete and RunOnceHasShown every time it starts. If these values have been set as depicted above, IE will visit the home page set in the IE control panel.

For terminal server, you can set a log-on script, so that these two values will be added and set automatically when users connect to the server.

Source…


Skype v4.1 application causes slow performance in Internet Explorer 8

August 15, 2009

If you are seeing slow performance within Internet Explorer 8 (opening new tabs, for example), after just recently installing the latest version of the Skype application (v4.1), the issue could be caused by the IE add-on that gets installed by the latest revision of the Skype software.

To resolve this issue quickly, please open Managed Add-Ons and disable the installed Skype IE add-on.

Instructions…