Make IT Complete

Technical Ramblings From an IT Professional

Entries for the ‘Microsoft Technologies’ Category

Loss of SBS Licenses

I found that the SBS2003 licenses are kept in the licstr.cpa file in the WINDOWS\system32 folder. Thankfully, Microsoft actually keep an automatic backup of this in autolicstr.cpa. The simple process was to stop the License Logging Service, rename licstr.cpa to licstr.cpa.old, then copy autolicstr.cpa to licstr.cpa. After this I started License Logging Service and used [...]

More on moving SharePoint Databases

Check the instructions in the lower section of the page:
 
http://blogs.technet.com/corybu/archive/2007/06/01/detaching-databases-in-moss-2007-environments.aspx
 
Basically:
 
First we need to find out which databases are currently not in sync, this can be done from a simple stsadm command on your SSP web front end.
 
stsadm -o sync -listolddatabases 5
 
This command will list all databases that have not synced up correctly with the SSP [...]

Moving SharePoint Content Databases

- External SQL Server Database Move

 Log Shipping Method(low impact)

To migrate your content database from 1 SQL Server to another there are a few choices, your choice will depend on how much downtime you are willing to take.  First option being you can setup SQL Log shipping, Once your 2 databases are in sync you would [...]

Enabling Drop Down Menu for Multi Level Nav

This link has some good info about the problem I am having.
http://vivekthangaswamy.blogspot.com/2007/12/enabling-drop-down-menu-for-multi-level.html

Reconnect SQL User Logins

I find this useful when restoring a SQL database and then needing to reconnect the database use to the login account.
This used to be a pain to fix, but currently (SQL Server 2000, SP3) there is a stored procedure that does the heavy lifting.
All of these instructions should be done as a database admin, with [...]

SPDisposeCheck

SPDisposeCheck is a tool to help SharePoint Developers follow memory management best practices when using the SharePoint API with IDisposable objects including SPSite and SPWeb. This tool is not supported by Microsoft and is recommended to be used on Developer workstations and not on production SharePoint Server installations.
It was released yesterday at http://code.msdn.microsoft.com/SPDisposeCheck
The tool reviews [...]

SharePoint Designer is unable to open site or page.

Article ID: KB101848
When attempting to open a WSS/MOSS site, or web page in Microsoft Office Sharepoint Designer do you receive the following error:
“The server could not complete your request. Contact your internet service provider or Web server administrator to make sure that the server has the Frontpage Server Extensions or SharePoint Services installed.”

Getting the URL from a Hyperlink Cell in Excel

If you’ve used Copy and Paste from a web page into Excel, you may end up with links in your Excel sheet. You can also add a URL to a cell.
So how do you access the URL itself? What if you want to modify the URL?

Moving a MS-SQL Database

The following example moves a database that is named mydb. This database contains one data file, Mydb.mdf, and one log file, Mydblog.ldf. If the database that you are moving has more data files or log files, specify the files in a comma-delimited list in the sp_attach_db stored procedure. The sp_detach_db procedure does not change regardless [...]

Redirect default.apsx to another page

On our site we wanted to have all of our pages under version control including the root default.aspx page so that required us to do a redirect from from the root to the /pages/default.aspx.
There are a few ways to do this.

The easiest is to add a content web part and add a

<script> location.href = ‘/pages/default.aspx’; [...]