Brainlitter - Inside the mind of Sean Wallbridge

Ok, this was a timely lesson learned.   If you are getting the following error trying to search a Windows SharePoint Services 3.0 (WSS), you might be experiencing the same problem we did…   1: No results matching your search were found. Check your spelling. Are the words in your query spelled correctly? Try using …

This is an oldie but a goodie… I’ve reposted this as I noticed it wasn’t appearing in search, but on my old blog, it was helping a significant amount of people – so I wanted to give it a new push here, in case it helps others.   Ok, this one took a while to sort …

That title sure read lame (or geeky)… So, need to use PSConfig to attach to a different Configuration Database for SharePoint? Using WID (Windows Internet Database) and not full SQL? Don’t forget you need to specify the Instance with your configdb -connect -server setup – as in servernameMICROSOFT##SSEE That syntax needs to be correct, or …

Here’s a query for listing indexes… Needed this today… select ‘tablename’=objectname(i.id) ,i.indid ,’indexname’=i.name ,i.groupid ,’filegroup’=f.name ,’filename’=d.physicalname ,’dataspace’=s.name from sys.sysindexes i ,sys.filegroups f ,sys.databasefiles d ,sys.dataspaces s where objectproperty(i.id,’IsUserTable’) = 1 and f.dataspaceid = i.groupid and f.dataspaceid = d.dataspaceid and f.dataspaceid = s.dataspaceid order by f.name,objectname(i.id),groupid go