Click here to Skip to main content

Hannes Foulds - Professional Profile

@Hannes-Foulds

Summary

3,100
Author
50
Authority
26
Debator
1
Enquirer
8
Organiser
225
Participant
0
Editor
Member since Thursday, May 6, 2004 (10 years, 2 months)

Contributions

Articles 3 (Writer)
Tech Blogs 0
Messages 29 (Lurker)
Q&A Questions 0
Q&A Answers 0
Tips/Tricks 0
Comments 0

Links

Reputation

For more information on Reputation please see the FAQ.

Privileges

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
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
Report a forum messagesilversilverbronzeProtector, Editor, Admin
Create a new tagsilversilversilversilverAdmin
Modify a tagsilversilversilversilverAdmin

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


 
GeneralSharePoint Tool Pane PinmemberHannes Foulds13-Nov-08 1:04 
GeneralASP.NET and showModalDialog PinmemberFoulds.NET13-Jun-07 22:33 
GeneralRe: ASP.NET and showModalDialog PinmemberHannes Foulds7-Aug-07 8:03 
GeneralSharePoint 2003 Ghosted pages PinmemberFoulds.NET22-Aug-06 20:50 
GeneralXML Serialization & Deserialization PinmemberFoulds.NET14-Aug-06 1:25 
GeneralSharePoint 2003 Dynamic Web Part Page Title PinmemberFoulds.NET9-Aug-06 23:59 
GeneralDecompile CHM PinmemberFoulds.NET28-Jul-06 1:20 
GeneralSQL Server 2000: Full-Text Indexing PinmemberFoulds.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'
go
 
sp_fulltext_catalog 'search', 'create'
go
 
-- create index for the question table
sp_fulltext_table 'Question', 'create', 'search', 'PK_Question' 
go
 
sp_fulltext_column 'Question', 'Title', 'add'
go
 
sp_fulltext_column 'Question', 'Question', 'add'
go
 
sp_fulltext_table 'Question', 'activate'
go
 
-- perform a full index
sp_fulltext_catalog 'search', 'start_full'
go
 
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 PinmemberFoulds.NET11-Jul-06 21:30 
GeneralHello World PinmemberFoulds.NET11-Jul-06 21:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web01 | 2.8.140721.1 | Last Updated 26 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid