Monday, June 11, 2012

addcontentdb Could not find stored procedure 'dbo.proc_SetDatabaseInformation'

Issue: I was attaching a restored content database using STSADM -o addcontent to a SharePoint 2007 web using the command below when I got the following error: Could not find stored procedure 'dbo.proc_SetDatabaseInformation'

stsadm.exe -o addcontentdb -url http://intranet.mycompany.local -assignnewdatabaseid -databasename WSS_Content_MyDB -databaseserver MySQL.mycompany.local
Solution: I found that the error message relates to the configuration database and there are lots of articles talking about different version patching issues.  

However the real issue seems to be the -assignnewdatabaseid parameter.  It causes SharePoint to look for the procedure which it cant find if the versions are missmatched.  If you can get away with not adding the -assignnewdatabaseid parameter you should find it will run ok

Accessing Sharepoint data directly in the SQL database - not to be recommended but interesting...

http://e-junkie-chronicles.blogspot.co.uk/2011/10/closer-look-at-sharepoint-sql-query.html#!/2011/10/closer-look-at-sharepoint-sql-query.html

Thursday, June 07, 2012

Sky Go Error code t6030-c150​1


Ive been fighting with the above error for several days to try to get Sky Go working on a PC.
It transpires that there is an issue with newest version of Silverlight.
My answer was to remove Silverlight using the control pannel -> uninstall programs.  Reboot and then download and install silverlight version 5.0.61118 The best place I found to download the earlier version was at http://www.oldapps.com/silverlight.php
This seemed to have fixed the issue for me.