The article is a little hard to understand, but it has some prettygood information about creating additional buttons in libraries so youcan say “New Excel file” or “New Word file” no matter the defaultdocument library's new file type: http://msd2d.com/newsletter_tip.aspx?section=sharepoint&id=cd3fd32d-b989-4bff-aae7-a65846b795b6

There are some who want to find the least amount of privileges forSharePoint to have in SQL. So, to help out, here is what I have sofar: The account the SharePoint Application Pool is using needs to haveread/write privileges on the content database. It also needs to haveexecute privileges on stored procedures.

Some info on how IIS works with host headers and SSL:You shouldn't have two sites setup with the same host header (even ifthey are on different servers, UNLESS you are using load-balancing!).A suggestion might be to call it site.dev.domain.com , site.qa.domain.com,site.domain.com as you go through devlopment, testing, and productionenvironments. Also, you have to understand how IIS works. It receives a request for“domain.com” and looks to see if there is a virtual server listeningon port 80 (because no port was defined in the request) that islistening for domain.com (using a host header). If it doesn't findone, it looks for a site listening on port 80 with no host headerdefined. If it…

To change the application pool for an existing Windows SharePointServices site (IIS virtual server):-Ensure that the new application pool is running under the sameidentity the old AppPool is running as. (if you don't, then SharePointmay not be able to connect to the content or configuration database)-In IIS, expand Web Sites.-Right-click on the virtual server you want to change and select properties.-On the ‘Home Directory' tab, under the ‘Application settings'section, change the ‘Application pool:' to the new application pooland click Apply, then OK.-Back in the Internet Information Services Manager, expand the virtualserver you are changing by clicking the + sign beside the name.-For every Virtual Directory (default virtual directories for a…

You can map a network share to a SharePoint site (or individualdocument library) doing the following: net use s: http://sharePointserver/somesite/doclib Note that if there is a space in the path, you need to use quotesaround the url: net use s: “http://sharePointserver/somesite/shared documents” Also need to ensure the WebClient service is running.This would be really useful for automated uploading of documentsthrough scripts, etc. Sources:(http://www.sharepointu.com/forums/m_18100/mpage_1/key_//tm.htm#18872)

1-Copy the databases from the old SQL server to the new one.2-Then, in the config database on the new SQL server, open the Serverstable in the config database.3-Change the Name and Address fields that have the old SQL server nameto the new SQL server name.4-Open the SharePoint Central Administration page and click on “Setconfiguration database server” under the Server Configuration section.5-Change old SQL server name to new SQL server name. Click OK.6-Again on the SharePoint Central Administration page, click on“Configure virtual server settings”, and then click on a website youwant to change.7-Click on “Manage content databases” under Virtual Server Management.8-Click “Add a content database” and then ensure “Specify databaseserver settings”…

Here is a little info on setting alerts using the STSADM command (from the Windows SharePoint Services Admin Guide). It can also check/change many other settings. Take a look: You can manage alerts from the command line by using the GetProperty and SetProperty operations with Stsadm.exe. You can set the following properties to configure how alerts work. Property —-> Descriptionalerts-enabled —-> Turn alerts on or off.alerts-limited —-> Specify whether users are limited to a specificnumber of alerts.alerts-maximum —-> Specify the maximum number of alerts users can create.job-immediate-alerts —-> Specify how often to check for immediatealerts (in minutes).job-daily-alerts —-> Specify the time of day (using a 24-hour clock)to send out daily…