SharePoint, MOSS? and all the other questions
There are 11 entries for the tag
Database
Here are few lessons learnt from playing with the BDC on a project 1. Even though the BDC can crawl associated entities in your database schema, the search results will not show related entity instances for the item you searched. 2. In case of mapping 'complex' db schemas specially ones that contain m:n relationships between entities, sometimes it might be advisable to show un-normalized relationships via stored procedures or views, but this approach provides the following roadblocks Un-normalized ......
I had this requirement recently where I restored a database, and wanted to grant a particular user execute rights to all the stored procs in that db. Not wanting to go through the tedious manual operation of granting permissions to each and stored proc out there, I found this tip in the newsgroups. Kudos to Rick Sawtell for this clever SP /* Procedure to Grant EXECUTE permissions on all * user defined stored procedures in the database * to the user defined role db_ProcExecuter */ CREATE PROC [dbo].[usp_UpdateProcPermis... ......
I was trying to setup WSS v3 on a VPC today. The setup went fine, but then the configuration (I mean SharePoint Products and Technologies Configuration) failed about 4 times at the “Registering SharePoint Servces” i.e. 5/10 stage before it finally continued. I really dont get it. The exception in the log says this 05/27/2006 17:16:52 10 ERR Exception: Microsoft.SharePoint.SPExce... ---> System.Data.SqlClient.SqlEx... Cannot open database "WSS_Search_HEX" requested by the login. ......
Tim points out a utility for SharePoint from WinApp Echo. I faintly remember that someone mentioned that this was demoed at TechEd in the MS Partner section (I could be mistaken). I would agree with Tim that some of the features provided by the tool might be accomplished by directly manipulating the SharePoint Database (which is unsupported). But at the end of the day if you are managing a large Portal Setup what the product offers is ‘must-have’ features (i.e. in contrast to ‘would ......
Bryant has a good post on a SharePoint database hack related to installing WebParts. Even though you may never have to use this, its always handy knowing it can be done.
Recently a colleague of mine was faced with the problem of moving content from one WSS Site to another, with almost all the lists you can save the content in a template and recreate the list, but that is not possible with the Issues List. For some reason beyond my comprehension the Issues List does not let you save the content to a template. Here is a small tip on this, but I do not recommend it. The SharePoint ‘_Site’ database contains a table called UserData that stores the contents of all lists. ......
Actually I am complaining about very simple bit of code. It is so simple that even I could write it (or copy and paste it) a million times. All I want to do is to set a user’s Credentials into the Single SignOn database from a WebPart, but the frigging thing keeps failing. string[] rgSetCredentialData = new string[2]; rgSetCredentialData[0] = "2ser"; rgSetCredentialData[1] = "rb26dett"; Credentials.SetCredentials( 1, "TestSSOAPP", rgSetCredentialData); The error returned is SSO_E_CANARY_VALIDATION_FAI... ......
Recently I noticed a neat fact about the Search Results WebPart; that is how it responded to a failure with the index database, and I think this is pretty cool - "Hats off to Microsoft, for thinking about this" Consider a situation when the SPS is unable to connect to its Search Indexes, like for instance due to a database corruption, or the configuration database account being invalid, then as a result of this severed connection the search shouldn’t work (obviously), or perhaps give horrendous error ......
First to fend off any SPS discriminations I might be accused of- Mike I am writing this with my knowledge of SPS, do not know if it applies to WSS, since I do not have a WSS Configuration to try it out on separately. Secondly fiddling with SPS database is not recommend, do it at your own risk K OK, I had this scenario recently (actually about 2 weeks back). An intern colleague of mine had to do a bulk upload of a bunch of documents to a SharePoint team site, which is not very unusual if you are trying ......
"During a news conference at the FOSE 2004 show in Washington, McNealy said it is unlikely Sun will open-source Java. According to a report by Government Computer News, McNealy spoke of IBM's invitation to Sun to join Big Blue in developing an open-source implementation of the Java platform. " This is the bit I Like "According to the report, McNealy said: "Go open-source with DB2, and then you can tell me what to do with my assets," referring to IBM's popular database system." Full article is here ......
I came across this link a couple of days back, and I was playing with this feature in Frontpage today.Its pretty cool that you can pull your data from a datasource whether it be a database, xml file, webservice etc.., and generate a view like this above image is from MSDN articleonly with a few clicks. I am sure this one feature that any Portal designer will really love, coz I know a couple of dudes within the company I work for who eventually end up coding the UI front end, and database connection ......