Thursday 25 June 2009

Windows : Remote desktop - terminal server has exceeded the maximum ...

Getting a RC console session
  • Console option for mstsc is removed from Pre vista sp1, xp sp3, server 2008
  • For connecting from older machines to older machines - mstsc -v:servername /f -console
  • For connecting from new machines to older machines there is a different switch - mstsc -v:servername /f /admin
  • For connecting from to new machines this way - cannot be done
From the command line
  • If you can get an admin connection - net use /user:[username] \\servername\share
  • Then can query/kill sessions remote (below)
Killing other non-console sessions
  • From the command line - query session /server:servername
  • Then reset session [ID] /server:servername



Tuesday 23 June 2009

Windows : RunDll links

Sharepoint - Map subsite to a drive

Mapping the sharepoint wiki as a mapped drive

  • From explorer (NOT internet explorer) choose Tools->Map Network Drive
  • Select a free Drive: letter (e.g. Z:)
  • In the Folder: field type the url http://sharepoint/Wiki
  • Check reconnect at login as required
  • Press
  • Nb. Only sharepoint subsites can be mapped this way

Adding sharepoint as a Network Place

  • Run the add network place wizard - rundll32 netplwiz.dll,AddNetPlaceRunDll
  • Click Next and Select “Choose another network location” click “Next”.
  • Type the address of SharePoint site/sub site. (e.g. http://p2-Testsite/Testsubsite/)
  • Type in the username and password.
  • Navigate to the Document library/list and create a Shortcut.


<b><b>
</b></b>
http://www.phase2.com/blog/?p=96


Sharepoint : Embed excel in the wiki

To add an excel spreadsheet for viewing in sharepoint

  • Save spreadsheet to Sharepoint by selection sharepoint3/wiki/Wiki Pages/Oracle-docs/<spreadheet_name>.xlsx
  • Choose "Site Actions" (blue lozenge top right hand side) and Edit Page
  • Select Yellow "Add a Web Part" bar
  • Tick All Web Parts->Business Data->Excel Web Access
  • Select edit->Modify Shared Web Part
  • Select Workbook field using <...> button (/wiki/Wiki Pages/Oracle-docs/<spreadheet_name>.xlsx)
  • Amend display properties as required
  • Nb. Autogenerate Title will override entered title
  • Press <OK>
  • Press Exit Edit Mode
To update an excel spreadsheet stored/ussed in sharepoint
  • Navigate to required spreadsheet in sharepoint and select Open->In Excel
  • Select Open->In Excel
  • Edit spreadsheet as required
  • Overwrite using "Save As" to the original sharepoint location in (e.g. sharepoint3/wiki/Wiki Pages/Oracle-docs/<spreadheet_name>.xlsx)
  • On the wiki page choose Update->Reload Workbook to check changes


Thursday 18 June 2009

SourceSafe : Get a release based on a label

To check out the labelled release from VSS using the GUI
  • Open VSS repository \\lonnasc0601\Database VSS
  • In the tree navigate and select the node $/schema/ODL_DBSERVICES
  • Right click and select Working Folder - select a local foler to check out to and press
  • Back on the selected tree node right click again and select Show History
  • In the Project History Options dialog click 'Include Labels' and press
  • In the history table select the line where the Action is Labeled 'ZPFL_20090618_ORACLE-172' and press
  • In the Get Dialog click 'Recursive' and then 'Build Tree' and press
  • If prompted to create a folder press
To check out the labelled release from VSS using the command line
  • Setup env
set PATH=%PATH%;C:\Program Files\Microsoft Visual SourceSafe
set SSDIR=\\lonnasc0601\Database VSS
mkdir "C:\VSS\Database VSS7"
  • Run get command for a label
REM ss.exe get -V
To label projects (directories) in GUI
  • Select required project, right click and select Label
  • Enter  required label (eg. ZPFL_20090618_ORACLE-132)
  • Label will be applied to project and recursively to all sub-projects and file
To label a file in GUI
  • Select required file, select label icon on toolbar (=clock and postit note)
  • Enter label text (eg. ZPFL_20090618_ORACLE-132)
  • NOTE that a new file version if created for each label entered on a distinct file

To view labels in GUI
  • Select project or file, right click and choose SHow History
  • Check the 'Include Lables' check box
  • Labels are included in the Action column