SHAREPOINTSearch.com

Body: I routinely use SQL Server Management Studio to write SQL queries, ogle details of the database schema, etc. Last week, I needed to change the permissions on a SQL login, and I got the following message: That confused me, as I was logging in to Read More......( read more )

There comes a time when SharePoint databases will have to be moved to another database server. The problem is that it is not that easy to just move the databases to a new database server and have everything work. In SharePoint 2003, it was realatively simple to move all the databases, but in 2007 there...

The Microsoft Learning Gateway (MLG) consists of many products from Microsoft from Windows Operating Systems to the Office System. SharePoint is a product that is required to make up the MLG but other products that can be added, these are not necessary to make up your MLG. What does Microsoft say on...

If you receive HRESULT: 0x80040E14 when trying to add an item like announcements/webpart/saving documents before running going through the Microsoft steps you have need to check the following Your SQL server data drive is not full Your mdf and ldf database files havent reached there full allocated size...

I cannot tell if this is a bug in SharePoint or if there is actually a limit to how many filter criteria you can apply to the metadata store. But you could try using CONTAINS instead og Equal To. The latter goes to the SQL Table of the metadata store whereas the first goes to the text index. So try using...

I can set up a web service as a datasource in Share Point Designer. However, when I attempt to pull that information into a drop down list list form control it does not populate with information. I've tried it several different ways, and paralleled it with a working model using a direct sql connection...

Use web parts that either actions(BDC Data), custom columns(List), or spgridview control(Database), to establish links that provide a query variable to your dynamic page. On your dynamic page, create a web part or embed server side code that creates a folder in each of your lists, document libraries...

Here’s another quirk for SharePoint Admins & Designers out there. If you ever come across something like “soap:ServerServer was unable to process request” while trying to work with pages in SharePoint Designer, congratulations! Now you can also be a part time DBA. Here’s a...

This post is really about performance. I had a situation where I started off using subqueries: SELECT DISTINCT Account.Name AS BusinessName, Test.New_name AS TestName, (SELECT COUNT(*) FROM New_Test T2 WHERE T2.New_AccountId = Account.AccountId AND T2.new_testtypeid = Test.new_testtypeid AND new_result...

Hey all, I am an IT Consultant with Levi, Ray, and Shoup, Inc. I attended their Portal University in July - October '05 and have worked with LRS as a SharePoint Consultant ever since. I have been on numerous successful engagements deploying SharePoint 2003, MOSS 2007, InfoPath 2003 and 2007. I have...