Click here to Skip to main content
12,949,601 members (59,985 online)

Hannes Foulds - Professional Profile


    Blog RSS


For more information on Reputation please see the FAQ.


Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege, and the given member types also gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilverAdmin
Bypass spam checks when posting contentsilversilversilversilversilversilversilverSitebuilder, Subeditor, Mentor, Protector, Editor, Staff, Admin
Store personal files in your account areaplatinumplatinumSitebuilder, Subeditor, Supporter, Editor, Staff
Have live hyperlinks in your biographybronzebronzebronzebronzebronzebronzesilverSubeditor, Protector, Editor, Staff, Admin
Edit a Question in Q&AsilversilversilversilverYesSubeditor, Protector, Editor, Admin
Edit an Answer in Q&AsilversilversilversilverYesSubeditor, Protector, Editor, Admin
Delete a Question in Q&AYesSubeditor, Protector, Editor, Admin
Delete an Answer in Q&AYesSubeditor, Protector, Editor, Admin
Report an ArticlesilversilversilversilverSubeditor, Mentor, Protector, Editor, Staff, Admin
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubeditor, Mentor, Protector, Editor, Staff, Admin
Edit other members' articlesSubeditor, Protector, Editor, Admin
Create an article without requiring moderationplatinumSubeditor, Mentor, Protector, Editor, Staff, Admin
Approve/Disapprove a pending QuestionProtector, Admin
Approve/Disapprove a pending AnswerProtector, Admin
Report a forum messagesilversilverbronzeProtector, Editor, Admin
Approve/Disapprove a pending Forum MessageProtector, Admin
Create a new tagsilversilversilversilverAdmin
Modify a tagsilversilversilversilverAdmin

Actions with a green tick can be performed by this member.

GeneralSharePoint Tool Pane Pin
Hannes Foulds13-Nov-08 1:04
memberHannes Foulds13-Nov-08 1:04 
GeneralASP.NET and showModalDialog Pin
Foulds.NET13-Jun-07 22:33
memberFoulds.NET13-Jun-07 22:33 
GeneralRe: ASP.NET and showModalDialog Pin
Hannes Foulds7-Aug-07 8:03
memberHannes Foulds7-Aug-07 8:03 
GeneralSharePoint 2003 Ghosted pages Pin
Foulds.NET22-Aug-06 20:50
memberFoulds.NET22-Aug-06 20:50 
GeneralXML Serialization & Deserialization Pin
Foulds.NET14-Aug-06 1:25
memberFoulds.NET14-Aug-06 1:25 
GeneralSharePoint 2003 Dynamic Web Part Page Title Pin
Foulds.NET9-Aug-06 23:59
memberFoulds.NET9-Aug-06 23:59 
GeneralDecompile CHM Pin
Foulds.NET28-Jul-06 1:20
memberFoulds.NET28-Jul-06 1:20 
GeneralSQL Server 2000: Full-Text Indexing Pin
Foulds.NET13-Jul-06 0:32
memberFoulds.NET13-Jul-06 0:32 
Today I have to work on full-text indexing to do a bit of searching, I found this usefull little Article[^] that shows you how to create the index with scripts.

Here is what I came up with:

-- create the full text index
sp_fulltext_database 'enable'
sp_fulltext_catalog 'search', 'create'
-- create index for the question table
sp_fulltext_table 'Question', 'create', 'search', 'PK_Question' 
sp_fulltext_column 'Question', 'Title', 'add'
sp_fulltext_column 'Question', 'Question', 'add'
sp_fulltext_table 'Question', 'activate'
-- perform a full index
sp_fulltext_catalog 'search', 'start_full'

This is my attempt to also script the scheduled full index:

use master
exec msdb..sp_delete_job @job_name = 'Start_Full on Alexandria.Search.'
declare @id BINARY(16)  
exec msdb..sp_add_job 	@job_name = 'Start_Full on Alexandria.Search.', 
			@description = 'Scheduled full-text full population for 
                                        full-text Catalog Search in database Alexandria. 
                                        This job was created by the full-text scheduling dialog or 
                                        full-text index wizard..',
			@enabled = 1, 
			@start_step_id = 1, 
			@notify_level_eventlog = 2, 
			@notify_level_email = 0, 
			@notify_level_netsend = 0, 
			@notify_level_page = 0, 
			@delete_level = 0, 
			@category_name = 'Full-Text', 
			@job_id = @id OUTPUT  select @id

exec msdb..sp_add_jobstep	@job_id = @id,
				@step_id = 1, 
				@cmdexec_success_code = 0, 
				@on_success_action = 1, 
				@on_success_step_id = 0, 
				@on_fail_action = 2, 
				@on_fail_step_id = 0, 
				@retry_attempts = 0, 
				@retry_interval = 0, 
				@os_run_priority = 0, 
				@flags = 0, 
				@step_name = 'Full-Text Indexing', 
				@subsystem = 'TSQL', 
				@command = 'use [Alexandria] exec sp_fulltext_catalog ''Search'', ''start_full''', 
				@database_name = 'master'
exec msdb..sp_add_jobserver	@job_id = @id, 
				@server_name = '(local)'
exec msdb..sp_add_jobschedule 	@job_id = @id, 
				@name = 'complete', 
				@enabled = 1, 
				@freq_type = 4, 
				@freq_interval = 1, 
				@freq_subday_type = 1, 
				@freq_subday_interval = 0, 
				@freq_relative_interval = 0, 
				@freq_recurrence_factor = 1, 
				@active_start_date = 20060713, 
				@active_end_date = 99991231, 
				@active_start_time = 120000, 
				@active_end_time = 235959
exec msdb.dbo.sp_update_job	@job_id = @id, 
				@automatic_post = 0 , 
				@owner_login_name = 'sa'
exec msdb..sp_help_job @job_id = @id, @job_aspect = N'job'
exec msdb..sp_help_jobstep @job_id = @id
exec msdb..sp_help_jobschedule @job_id = @id

GeneralAbsolute Path Pin
Foulds.NET11-Jul-06 21:30
memberFoulds.NET11-Jul-06 21:30 
GeneralHello World Pin
Foulds.NET11-Jul-06 21:24
memberFoulds.NET11-Jul-06 21:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Advertise | Privacy | Mobile
Web02 | 2.8.170524.1 | Last Updated 25 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid