This function is very useful if you have a CSV string and you want to make a table of all the values or you have a sentance and you want to make a table of words.
Open Query Analyzer
Login as sa
Copy the code and paste into the Query Analyzer
Click on Query->Execute or Press F5
Test the function
SELECT * FROM dbo.MakeTable('Hari Kishan Charora', ' ')
CREATE FUNCTION MakeTable (@LongText varchar(8000), @Delimiter char(1))
RETURNS @RetResult TABLE (ID int IDENTITY (1, 1) NOT NULL, Value varchar(20))
AS
BEGIN
declare @Value varchar(10)
SET @Value = ''
while PATINDEX('%'+@Delimiter+'%', @LongText) > 0
begin
SET @Value = LTRim(SUBSTRING(@LongText, 1, PATINDEX('%'+@Delimiter+'%', @LongText)-1))
INSERT INTO @RetResult (Value) VALUES (@Value)
SET @LongText = LTRim(SUBSTRING(@LongText, PATINDEX('%'+@Delimiter+'%', @LongText)+1, LEN(@LongText)-PATINDEX('%'+@Delimiter+'%', @LongText)))
end
SET @Value = LTrim(@LongText)
INSERT INTO @RetResult (Value) VALUES (@Value)
RETURN
END
SYMPTOMS
Whatever you try to search for in SharePoint Portal Server 2003, You do not get any results, you may receive the following error message in the error log if you go to "Site Settings->Configure search and indexing->View errors and warnings on:" and click on "portal content" or "non portal content"
The address could not be found, (0x80041209 - Cannot Connect to the server. Please make sure the site is accessible. )
The address could not be found, (0x80041206 - A server error occurred. Check that the server is available. )
CAUSE
full-text search is not configured properly
WORKAROUND
To work around this problem, follow these steps.
1. Login as SharePoint Administrator Group Account
2. Go to SharePoint Central Administration
3. Click on Windows SharePoint Services from left navigation bar.
4. Click on Configure full-text search and uncheck and check "Enable full-text search and index component" under Search Settings and type "SharePoint Administrator Group Account" User ID and Password if prompted.
4. Open Enterprise Manager in SQL Server 2000 or SQL Server Management Studio in SQL Server 2005.
5. Go to the database server then open the "SITE" database
6. You should see Full-Text Catalog node, right click on the catalog icon to start full population. If you receive an error message then run this stored procedure. Make sure you are running the stored procedute in the "Site" database.
EXEC sp_fulltext_database 'enable'
GO
This should fix the problem
Write Comment
If you want to upload certain files on your website frequently, this script can help you.
1. Create a folder "c:\upload\"
2. Copy file1.htm, file2.htm etc to "c:\upload\"
3. Copy this script and paste into notepad
4. Make Necessary Changes
Specify username and password in Line 9
Specify remote folder name in Line 11
Change www.charora.com to your domain name in Line 24
5. SaveAs "upload.bat"
6. Run upload.bat
@echo off
rem Author: Sushma Charora
rem Date: 8/30/2006 11:30 AM PST
rem This script FTP over files to
rem the web-site automatically.
rem If you have any question contact me at
rem first we build a response file containing the FTP commands
ECHO verbose off > c:\upload\ftp.in
ECHO user usernamepassword >> c:\upload\ftp.in
ECHO bin >> c:\upload\ftp.in
ECHO cd /remotefolder >> c:\upload\ftp.in
ECHO put c:\upload\file1.htm >> c:\upload\ftp.in
ECHO put c:\upload\file2.htm >> c:\upload\ftp.in
ECHO put c:\upload\file3.htm >> c:\upload\ftp.in
ECHO put c:\upload\file4.htm >> c:\upload\ftp.in
ECHO put c:\upload\file5.htm >> c:\upload\ftp.in
ECHO put c:\upload\file6.htm >> c:\upload\ftp.in
ECHO put c:\upload\file7.htm >> c:\upload\ftp.in
ECHO quit >> c:\upload\ftp.in
rem ok, now we have created the file we want to be executed by ftp
rem start ftp
rem -n means suppress autologin
rem -s:c:\upload\ftp.in means take commands from that file
ftp -n -s:c:\upload\ftp.in www.charora.com
del c:\upload\ftp.in
rem Done!
GOTO QUIT
:QUIT
Echo that's it!
Watch your thoughts; they become words. Watch your words; they become actions. Watch your actions; they become habits. Watch your habits; they become character. Watch your character; it becomes your destiny. -Frank Outlaw
