显示标签为“basics”的博文。显示所有博文
显示标签为“basics”的博文。显示所有博文

2012年2月11日星期六

Basics, just the basics, please (BUMP)

John,
I've bumped this up because I have been so busy on other things that I was
afraid that it would get lost in the other messages...
On my SQL Server, as I had mentioned, I have two Server Groups: (local) and
SVR1/SHAREPOINT. When I try to use the SQL Analyzer to run the EXEC... you
wanted me to run, I cannot "see" the SVR1/SHAREPOINT server group, it will
only allow me to see the (local) one. I'm logging in as 'Administrator' so
I assumed that I should have access to everything. But in the SQL Analyzer
I can't get to it, but in the Enterprise Manager both groups show up.
Oh great guru, what words of wisdom can you impart on this lowly (read
'helpless'), but trying, IT worker?
Thanks for your help,
Rich

>You're welcome, Rich !
>Under your SHAREPOINT named instance of SQL Server, could you run the
>following code and post the result?
>EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
>'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOI NT', 'ObjectName'
>go
>The output Data should be the exact account that this named instance
>(SHAREPOINT) is running under. If it is a local Windows account, this could
>explain why the Full-Text Indexing menu items are grayed out. If so, please
>review KB article Q270671 (Q270671) "PRB: Full Text Search Menus Are Not
>Enabled for Local Windows NT Accounts" at:
>http://support.microsoft.com/default...;en-us;q270671 You should
>test using the system stored procs sp_fulltext_* to see if you can create a
>FT Catalog and run a Full Population. If you can change the SQL Server
named
>instance (SHAREPOINT) startup account to a new or existing DOMAIN\Account
>that is a member of the server's Admin. Group, and not the DOMAIN
>Administrator account (I'm assuming that CMSouth\Administrator is the
Domain
>Admin account) that could solve this issue too.
>Thanks,
>John "Genius" Kane ;-))
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:#9vvgTVhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> John,
> Thanks for your reply. I've got some reading to do, thanks for the lead.
> On the other issue I raised, regarding whether or not two groups would be
> handled as one, you indicated that both would need to have FTS set up
> through the wizard for FTS to take effect.
> The two groups I have are like this:
> Microsoft SQL Servers
> SQL Server Group
> (LOCAL) (Windows NT)
> (SVR1\SHAREPOINT) (Windows NT)
> When I highlight the LOCAL one, I get (under Tools) Full-Text Indexing...
as
> an enabled choice. But when I highlight the SHAREPOINT one, the Full-Text
> Indexing... is greyed out.
> I checked under Security on both and then Logins and both have
> BUILTIN\Administrators (group) and CMSouth\Administrator (user) (CMSouth
is
> the domain name of SVR1). Along with an 'sa' for both.
> Is there something I'm missing here? When I go into the Query Analyzer
and
> it prompts for the server to connect to, it only offers "local" and not
the[vbcol=seagreen]
> SHAREPOINT database group.
> I would appreciate any light you might shed on this.
> Rich
> PS: And yes, I did say genius. Anyone who can understand this as well as
> you deserves that label.
>
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:unU3fPMhEHA.3664@.TK2MSFTNGP11.phx.gbl...
reasons[vbcol=seagreen]
> Dummy's"
is[vbcol=seagreen]
> "full
titles[vbcol=seagreen]
for[vbcol=seagreen]
least[vbcol=seagreen]
> and
> schedule
> that
or[vbcol=seagreen]
and[vbcol=seagreen]
in
> *contributor*)
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> SQL
> your
> database
> all
up[vbcol=seagreen]
> externally
not[vbcol=seagreen]
14:22:05[vbcol=seagreen]
> Windows
Dummy's?"[vbcol=seagreen]
> is
> how
or
>
Hi Rich,
Not to worry... as I do actively monitor this newsgroup! Is the server
"SVR1" your local machine or a remote server? If it is local, then should be
able to run the follow EXEC from your (local) server when logged into your
(local) SQL Server as administrator or as sa as all it does is read a
registry key on the local server.
EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOIN T', 'ObjectName'
If SVR1 is not your local machine, could you have someone who has direct
access to the remote server run the above SQL code on the remove server?
Note, (s)he too should be admin or have sa access to that server. This is
less an issue of how you are logged on and more an issue of how the
MSSQLServer service on either your local or remote server is started and
what is the account for that service.
Thanks,
John
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:e$6jtwtjEHA.596@.TK2MSFTNGP11.phx.gbl...
> John,
> I've bumped this up because I have been so busy on other things that I was
> afraid that it would get lost in the other messages...
> On my SQL Server, as I had mentioned, I have two Server Groups: (local)
and
> SVR1/SHAREPOINT. When I try to use the SQL Analyzer to run the EXEC...
you
> wanted me to run, I cannot "see" the SVR1/SHAREPOINT server group, it will
> only allow me to see the (local) one. I'm logging in as 'Administrator'
so
> I assumed that I should have access to everything. But in the SQL
Analyzer[vbcol=seagreen]
> I can't get to it, but in the Enterprise Manager both groups show up.
> Oh great guru, what words of wisdom can you impart on this lowly (read
> 'helpless'), but trying, IT worker?
> Thanks for your help,
> Rich
>
>
could[vbcol=seagreen]
please[vbcol=seagreen]
should[vbcol=seagreen]
a[vbcol=seagreen]
> named
> Domain
>
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:#9vvgTVhEHA.2908@.TK2MSFTNGP10.phx.gbl...
lead.[vbcol=seagreen]
be[vbcol=seagreen]
Indexing...[vbcol=seagreen]
> as
Full-Text[vbcol=seagreen]
> is
> and
> the
as[vbcol=seagreen]
> reasons
> is
> titles
> for
> least
to[vbcol=seagreen]
Manager[vbcol=seagreen]
own[vbcol=seagreen]
FAQ's[vbcol=seagreen]
> or
> and
are[vbcol=seagreen]
Microsoft
> in
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
per[vbcol=seagreen]
both[vbcol=seagreen]
it's[vbcol=seagreen]
ends[vbcol=seagreen]
> up
> not
> 14:22:05
> Dummy's?"
much[vbcol=seagreen]
of[vbcol=seagreen]
> or
and[vbcol=seagreen]
same
>
>
|||Hi John,
I've about had it with this whole mess. I think I'm gonna issue 3x5 index
cards for everyone to just write down information and to heck with SQL
Server.
Okay. The server I've been trying to get FTS running on is about 12 feet
behind me. So I rolled my chair back there and logged off as Administrator
and logged in as myself. When I called Query Analyzer up, it asked for the
connection, so I gave it SVR1/SHAREPOINT and suddenly it just showed me what
it wouldn't show me before. <Grrrrrr>
I ran the EXEC and the response was Data=LocalSystem
So now that I found that out I went to the KB you indicated and read it, and
read it and read it and read it. It makes me think that I might just need a
16 pound sledge hammer instead of only an 8 pound sledge. I guess the
options of dealing with a stored procedure to perform the indexing
(database, table, column, etc) is a matter of review and considerations and
trade offs as far as speed and needs. I need to find the tech-writer for
WSS and have him/her reread the step by step instructions they show to make
FTS work. It isn't any little trivial thing and yet the documentation is
just, 'set this flag and save and voila!' Right, not hardly.
So I need to find out which table/column needs to be searchable and then
plan out which sp_ to use.
Your help has been enormous and I'm very appreciative. I still feel dumb,
but maybe some of this will finally sink in.
Thank you,
Rich
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%23ACDr5tjEHA.3896@.TK2MSFTNGP15.phx.gbl...
> Hi Rich,
> Not to worry... as I do actively monitor this newsgroup! Is the server
> "SVR1" your local machine or a remote server? If it is local, then should
be[vbcol=seagreen]
> able to run the follow EXEC from your (local) server when logged into your
> (local) SQL Server as administrator or as sa as all it does is read a
> registry key on the local server.
> EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
> 'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOIN T', 'ObjectName'
> If SVR1 is not your local machine, could you have someone who has direct
> access to the remote server run the above SQL code on the remove server?
> Note, (s)he too should be admin or have sa access to that server. This is
> less an issue of how you are logged on and more an issue of how the
> MSSQLServer service on either your local or remote server is started and
> what is the account for that service.
> Thanks,
> John
>
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:e$6jtwtjEHA.596@.TK2MSFTNGP11.phx.gbl...
was[vbcol=seagreen]
> and
> you
will[vbcol=seagreen]
> so
> Analyzer
> could
> please
Not[vbcol=seagreen]
> should
create[vbcol=seagreen]
> a
DOMAIN\Account[vbcol=seagreen]
> lead.
> be
> Indexing...
> Full-Text
(CMSouth[vbcol=seagreen]
Analyzer[vbcol=seagreen]
not[vbcol=seagreen]
> as
start[vbcol=seagreen]
on[vbcol=seagreen]
BOL[vbcol=seagreen]
> to
> Manager
> own
> FAQ's
below)[vbcol=seagreen]
behavior
> are
> Microsoft
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> per
time?[vbcol=seagreen]
> both
> it's
> ends
or[vbcol=seagreen]
Sharepoint[vbcol=seagreen]
> much
root[vbcol=seagreen]
> of
installed
> and
> same
>
|||You're welcome, Rich,
Yea, I hear you and understand your frustration as I once told an ex-SQL PM,
that troubleshooting FTS is like trying to figure out what's on the other
side of a black hole - as in nothing escapes a black hole, not even light -
so it's very difficult to see what's on the other side of a black hole!
Anyways, the fact that the EXEC returned LocalSystem is a good thing... Now,
what I need to understand is how you have the remote server "registered" in
your SQL Server Enterprise Manager. Are you using the machine name or it's
IP address or an alias for the server?
While KB articles are sometimes not easy to understand (even for me and I
wrote a few of them! ;), the following SharePoint KB article, while not
directly related to SQL Server and SharePoint Portal Server, *might* be
helpful to you...
837367 How to turn on full-text search (FTS) in WSS (SharePoint) on a
Windows SBS 2003-based computer
http://support.microsoft.com/?kbid=837367
823377 (WSS) The database this server is using does not support search When
You Configure Full-Text Search for the Virtual Server
http://support.microsoft.com/default.aspx?kbid=823377
Also, if you have the Windows SharePoint Services 2.0 Administrator's Guide
help (a .chm file), you should also checkout title "Migrating from WMSDE to
SQL Server".
Regards,
John
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:#JjQiBvjEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Hi John,
> I've about had it with this whole mess. I think I'm gonna issue 3x5 index
> cards for everyone to just write down information and to heck with SQL
> Server.
> Okay. The server I've been trying to get FTS running on is about 12 feet
> behind me. So I rolled my chair back there and logged off as Administrator
> and logged in as myself. When I called Query Analyzer up, it asked for the
> connection, so I gave it SVR1/SHAREPOINT and suddenly it just showed me
what
> it wouldn't show me before. <Grrrrrr>
> I ran the EXEC and the response was Data=LocalSystem
> So now that I found that out I went to the KB you indicated and read it,
and
> read it and read it and read it. It makes me think that I might just need
a
> 16 pound sledge hammer instead of only an 8 pound sledge. I guess the
> options of dealing with a stored procedure to perform the indexing
> (database, table, column, etc) is a matter of review and considerations
and
> trade offs as far as speed and needs. I need to find the tech-writer for
> WSS and have him/her reread the step by step instructions they show to
make[vbcol=seagreen]
> FTS work. It isn't any little trivial thing and yet the documentation is
> just, 'set this flag and save and voila!' Right, not hardly.
> So I need to find out which table/column needs to be searchable and then
> plan out which sp_ to use.
> Your help has been enormous and I'm very appreciative. I still feel dumb,
> but maybe some of this will finally sink in.
> Thank you,
> Rich
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:%23ACDr5tjEHA.3896@.TK2MSFTNGP15.phx.gbl...
should[vbcol=seagreen]
> be
your[vbcol=seagreen]
is[vbcol=seagreen]
> was
(local)[vbcol=seagreen]
EXEC...[vbcol=seagreen]
> will
'Administrator'[vbcol=seagreen]
> Not
> create
Server[vbcol=seagreen]
> DOMAIN\Account
would[vbcol=seagreen]
up[vbcol=seagreen]
> (CMSouth
> Analyzer
> not
well[vbcol=seagreen]
for[vbcol=seagreen]
> start
> on
and[vbcol=seagreen]
> BOL
not[vbcol=seagreen]
way[vbcol=seagreen]
the[vbcol=seagreen]
and[vbcol=seagreen]
your[vbcol=seagreen]
> below)
> behavior
issues
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
just[vbcol=seagreen]
(SVR1[vbcol=seagreen]
> time?
that[vbcol=seagreen]
> or
> Sharepoint
on[vbcol=seagreen]
how[vbcol=seagreen]
> root
> installed
the
>
|||John, you have the patience of Jobe.
And the saga continues...
In SQL Mgr a right click on the servers shows:
SVR1\SHAREPOINT
Server: SVR1\SHAREPOINT (combo box is disabled and ellipse is also
disabled)
Connection: Use Windows authentication is checked (Use SQL Server Auth
is NOT checked)
Options: Server Group = SQL Server Group (combo box only shows the one
group)
Display SQL Server in console = Checked
Show system db and objects = Checked
Auto start when connecting = Checked
(LOCAL)
Server: (LOCAL) (combo box is disabled and ellipse is also disabled)
Connection: Use Windows authentication is checked (Use SQL Server Auth
is NOT checked)
Options: Server Group = SQL Server Group (combo box only shows the one
group)
Display SQL Server in console = Checked
Show system db and objects = Checked
Auto start when connecting = Checked
When I click on the Add new registration for server the server I'm working
on (SVR1) is not listed. So the group only has (LOCAL) and SVR1\SHAREPOINT
but not SVR1 by itself.
You asked...
> Are you using the machine name or it's IP address or an alias for the
server?
I think the info above shows this (I think) but, the server name is SVR1 and
the domain name is CPM-South.
Also, I began to read the KB's you noted (thank you) and it seems that in
either case I've got to install SP3A. Well after viewing the webcast (some
of it anyway) on SP3A I'm not so sure that I want to get into that. I mean
there's a whole ton of new and different things any one of which could start
a nuclear meltdown on my SBS2003 server. If I don't do SP3A am I just
simply destined to have this orphan database (SVR1\SHAREPOINT), never to be
usable in either FTS or via Visual Studio? I hate to say this but my
options don't appear all that good.
All your info seems pretty good and I thank you for your help.
Rich
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%235l1KGxjEHA.3624@.TK2MSFTNGP10.phx.gbl...
> You're welcome, Rich,
> Yea, I hear you and understand your frustration as I once told an ex-SQL
PM,
> that troubleshooting FTS is like trying to figure out what's on the other
> side of a black hole - as in nothing escapes a black hole, not even
light -
> so it's very difficult to see what's on the other side of a black hole!
> Anyways, the fact that the EXEC returned LocalSystem is a good thing...
Now,
> what I need to understand is how you have the remote server "registered"
in
> your SQL Server Enterprise Manager. Are you using the machine name or it's
> IP address or an alias for the server?
> While KB articles are sometimes not easy to understand (even for me and I
> wrote a few of them! ;), the following SharePoint KB article, while not
> directly related to SQL Server and SharePoint Portal Server, *might* be
> helpful to you...
> 837367 How to turn on full-text search (FTS) in WSS (SharePoint) on a
> Windows SBS 2003-based computer
> http://support.microsoft.com/?kbid=837367
> 823377 (WSS) The database this server is using does not support search
When
> You Configure Full-Text Search for the Virtual Server
> http://support.microsoft.com/default.aspx?kbid=823377
> Also, if you have the Windows SharePoint Services 2.0 Administrator's
Guide
> help (a .chm file), you should also checkout title "Migrating from WMSDE
to[vbcol=seagreen]
> SQL Server".
> Regards,
> John
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:#JjQiBvjEHA.3536@.TK2MSFTNGP12.phx.gbl...
index[vbcol=seagreen]
Administrator[vbcol=seagreen]
the[vbcol=seagreen]
> what
> and
need[vbcol=seagreen]
> a
> and
for[vbcol=seagreen]
> make
dumb,[vbcol=seagreen]
> should
> your
direct[vbcol=seagreen]
server?[vbcol=seagreen]
> is
and[vbcol=seagreen]
I[vbcol=seagreen]
> (local)
> EXEC...
it[vbcol=seagreen]
> 'Administrator'
up.[vbcol=seagreen]
(read[vbcol=seagreen]
the[vbcol=seagreen]
instance[vbcol=seagreen]
this[vbcol=seagreen]
so,[vbcol=seagreen]
Are[vbcol=seagreen]
You[vbcol=seagreen]
> Server
the[vbcol=seagreen]
the[vbcol=seagreen]
> would
> up
and[vbcol=seagreen]
> well
<G>[vbcol=seagreen]
various[vbcol=seagreen]
> for
search[vbcol=seagreen]
under[vbcol=seagreen]
> and
the[vbcol=seagreen]
> not
> way
> the
> and
> your
either
> issues
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> just
> (SVR1
for[vbcol=seagreen]
server's[vbcol=seagreen]
> that
it[vbcol=seagreen]
something[vbcol=seagreen]
working[vbcol=seagreen]
2002[vbcol=seagreen]
Edition[vbcol=seagreen]
> on
> how
NT)
> the
>

Basics, just the basics please

Hello you geniuses,
I've read so many articles in here about full-text searching that it's all
beginning to slip out of my ears.
Most everyone seems to have gotten something working but then it ends up
with problems or issues when configurations change or something externally
effects it. As for me, I don't know if I have something working or not and
would just like to get the FTS working as part of Windows Sharepoint
Services (WSS).
SELECT @.@.version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: )
SELECT @.@.language:
us_english
OS: SBS2003 DC
Is there someplace that has a "SQL Full-Text Search Setup for Dummy's?" like
paper, so I can follow by the numbers rather than ponder just how much is
done and not done or jump in and out without understanding the root of how
FTS works? And does the FTS get set for ALL of SQL that's installed or just
per SQL Server Group? I have two groups; (LOCAL) (Windows NT) and
(SVR1 SHAREPOINT) (Windows NT), would they both be handled at the same time?
Any help would be appreciated by this addled brained IT guy,
Rich
Rich,
Well, thank you! I've not been called a "genius" in sometime! <G>
Unfortunately, books on this subject have been delayed for various reasons
(I'm writing one), so for now there is no "SQL Full-Text Search for Dummy's"
(yet), but look for one soon! In the meantime, the best place to start is
SQL Server 2000 Books online (BOL) using the search tab and search on "full
text search" using the double quotes. The basics are covered under titles
"Full-Text Query Architecture", "Full-Text Catalogs and Indexes" and
"Full-text Querying SQL Server Data". Also, you should review the BOL for
CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE and last but not least
"Full-Text Search Recommendations". Mostly, the best and easiest way to
FT-enable the database as well as table and columns is to launch the
Full-Text Indexing Wizard (sqlftwiz.exe) from the SQL Enterprise Manager and
it will prompt you through all the steps necessary to FT-enable and schedule
a Full Population for you or you can run a Full Population at your own
convience.
Yes, there are problems with SQL FTS, but mainly these are either FAQ's that
currently are not documented in KB articles (see a list of KB's below) or
are bugs or differences due to OS platforms, i.e., difference behavior and
results between Win2K and Win2003. Additionally, many SQL FTS issues are
related to either performance or scalability issues and lack of
customization. FYI, many of these bugs are being addressed by Microsoft in
the next release of SQL Server 2005 (codename Yukon).
You should also review the FTS Deployment whitepaper (I was a *contributor*)
and how to enable at:
http://support.microsoft.com/default...per.asp#enable
Q. And does the FTS get set for ALL of SQL that's installed or just per SQL
Server Group? I have two groups; (LOCAL) (Windows NT) and (SVR1
SHAREPOINT) (Windows NT), would they both be handled at the same time?
A. Yes and no... Specifically, FTS is installed and functional for both your
local and SVR1 SHAREPOINT (named instance), however, each server's database
must be FT-enabled separately via the FT Indexing Wizard.
Hope that helps!
John
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:eRVef2JhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> Hello you geniuses,
> I've read so many articles in here about full-text searching that it's all
> beginning to slip out of my ears.
> Most everyone seems to have gotten something working but then it ends up
> with problems or issues when configurations change or something externally
> effects it. As for me, I don't know if I have something working or not
and
> would just like to get the FTS working as part of Windows Sharepoint
> Services (WSS).
> SELECT @.@.version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: )
> SELECT @.@.language:
> us_english
> OS: SBS2003 DC
> Is there someplace that has a "SQL Full-Text Search Setup for Dummy's?"
like
> paper, so I can follow by the numbers rather than ponder just how much is
> done and not done or jump in and out without understanding the root of how
> FTS works? And does the FTS get set for ALL of SQL that's installed or
just
> per SQL Server Group? I have two groups; (LOCAL) (Windows NT) and
> (SVR1 SHAREPOINT) (Windows NT), would they both be handled at the same
time?
> Any help would be appreciated by this addled brained IT guy,
> Rich
>
|||John,
Thanks for your reply. I've got some reading to do, thanks for the lead.
On the other issue I raised, regarding whether or not two groups would be
handled as one, you indicated that both would need to have FTS set up
through the wizard for FTS to take effect.
The two groups I have are like this:
Microsoft SQL Servers
SQL Server Group
(LOCAL) (Windows NT)
(SVR1\SHAREPOINT) (Windows NT)
When I highlight the LOCAL one, I get (under Tools) Full-Text Indexing... as
an enabled choice. But when I highlight the SHAREPOINT one, the Full-Text
Indexing... is greyed out.
I checked under Security on both and then Logins and both have
BUILTIN\Administrators (group) and CMSouth\Administrator (user) (CMSouth is
the domain name of SVR1). Along with an 'sa' for both.
Is there something I'm missing here? When I go into the Query Analyzer and
it prompts for the server to connect to, it only offers "local" and not the
SHAREPOINT database group.
I would appreciate any light you might shed on this.
Rich
PS: And yes, I did say genius. Anyone who can understand this as well as
you deserves that label.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:unU3fPMhEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Rich,
> Well, thank you! I've not been called a "genius" in sometime! <G>
> Unfortunately, books on this subject have been delayed for various reasons
> (I'm writing one), so for now there is no "SQL Full-Text Search for
Dummy's"
> (yet), but look for one soon! In the meantime, the best place to start is
> SQL Server 2000 Books online (BOL) using the search tab and search on
"full
> text search" using the double quotes. The basics are covered under titles
> "Full-Text Query Architecture", "Full-Text Catalogs and Indexes" and
> "Full-text Querying SQL Server Data". Also, you should review the BOL for
> CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE and last but not least
> "Full-Text Search Recommendations". Mostly, the best and easiest way to
> FT-enable the database as well as table and columns is to launch the
> Full-Text Indexing Wizard (sqlftwiz.exe) from the SQL Enterprise Manager
and
> it will prompt you through all the steps necessary to FT-enable and
schedule
> a Full Population for you or you can run a Full Population at your own
> convience.
> Yes, there are problems with SQL FTS, but mainly these are either FAQ's
that
> currently are not documented in KB articles (see a list of KB's below) or
> are bugs or differences due to OS platforms, i.e., difference behavior and
> results between Win2K and Win2003. Additionally, many SQL FTS issues are
> related to either performance or scalability issues and lack of
> customization. FYI, many of these bugs are being addressed by Microsoft in
> the next release of SQL Server 2005 (codename Yukon).
> You should also review the FTS Deployment whitepaper (I was a
*contributor*)
> and how to enable at:
>
http://support.microsoft.com/default...per.asp#enable
>
> Q. And does the FTS get set for ALL of SQL that's installed or just per
SQL
> Server Group? I have two groups; (LOCAL) (Windows NT) and (SVR1
> SHAREPOINT) (Windows NT), would they both be handled at the same time?
> A. Yes and no... Specifically, FTS is installed and functional for both
your
> local and SVR1 SHAREPOINT (named instance), however, each server's
database[vbcol=seagreen]
> must be FT-enabled separately via the FT Indexing Wizard.
> Hope that helps!
> John
>
>
> "RDavid" <r@.c-m.NOSPAMcomm> wrote in message
> news:eRVef2JhEHA.3272@.TK2MSFTNGP11.phx.gbl...
all[vbcol=seagreen]
externally[vbcol=seagreen]
> and
Windows[vbcol=seagreen]
> like
is[vbcol=seagreen]
how
> just
> time?
>
|||You're welcome, Rich !
Under your SHAREPOINT named instance of SQL Server, could you run the
following code and post the result?
EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Services\MSSQL$SHAREPOIN T', 'ObjectName'
go
The output Data should be the exact account that this named instance
(SHAREPOINT) is running under. If it is a local Windows account, this could
explain why the Full-Text Indexing menu items are grayed out. If so, please
review KB article Q270671 (Q270671) "PRB: Full Text Search Menus Are Not
Enabled for Local Windows NT Accounts" at:
http://support.microsoft.com/default...;en-us;q270671 You should
test using the system stored procs sp_fulltext_* to see if you can create a
FT Catalog and run a Full Population. If you can change the SQL Server named
instance (SHAREPOINT) startup account to a new or existing DOMAIN\Account
that is a member of the server's Admin. Group, and not the DOMAIN
Administrator account (I'm assuming that CMSouth\Administrator is the Domain
Admin account) that could solve this issue too.
Thanks,
John "Genius" Kane ;-))
"RDavid" <r@.c-m.NOSPAMcomm> wrote in message
news:#9vvgTVhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> John,
> Thanks for your reply. I've got some reading to do, thanks for the lead.
> On the other issue I raised, regarding whether or not two groups would be
> handled as one, you indicated that both would need to have FTS set up
> through the wizard for FTS to take effect.
> The two groups I have are like this:
> Microsoft SQL Servers
> SQL Server Group
> (LOCAL) (Windows NT)
> (SVR1\SHAREPOINT) (Windows NT)
> When I highlight the LOCAL one, I get (under Tools) Full-Text Indexing...
as
> an enabled choice. But when I highlight the SHAREPOINT one, the Full-Text
> Indexing... is greyed out.
> I checked under Security on both and then Logins and both have
> BUILTIN\Administrators (group) and CMSouth\Administrator (user) (CMSouth
is
> the domain name of SVR1). Along with an 'sa' for both.
> Is there something I'm missing here? When I go into the Query Analyzer
and
> it prompts for the server to connect to, it only offers "local" and not
the[vbcol=seagreen]
> SHAREPOINT database group.
> I would appreciate any light you might shed on this.
> Rich
> PS: And yes, I did say genius. Anyone who can understand this as well as
> you deserves that label.
>
>
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:unU3fPMhEHA.3664@.TK2MSFTNGP11.phx.gbl...
reasons[vbcol=seagreen]
> Dummy's"
is[vbcol=seagreen]
> "full
titles[vbcol=seagreen]
for[vbcol=seagreen]
least[vbcol=seagreen]
> and
> schedule
> that
or[vbcol=seagreen]
and[vbcol=seagreen]
in
> *contributor*)
>
http://support.microsoft.com/default...per.asp#enable[vbcol=seagreen]
> SQL
> your
> database
> all
up[vbcol=seagreen]
> externally
not[vbcol=seagreen]
14:22:05[vbcol=seagreen]
> Windows
Dummy's?"[vbcol=seagreen]
> is
> how
or
>

basics with stored procedures.....please

Hi there, I'm still fairly new to asp.net / c#

I've setup my stored procedure, but now what?
I want to display the information (only one record it will return) on the page / NOT using a datagrid or list, just simple....I guess using an asp:label???
Could someone tell me what I need to do!!!

Also, are there any proper resources out there that just show you right out of the box howto insert / update / delete with sp's?, show / view, just proper simple source code?

THANKS!

my code:
// Creating the database connection
SqlConnection objConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_conn_main"]);

// Creating the stored procedure 4 the webpage
// Instantiate a Sql Command
SqlCommand webpage_view = new SqlCommand("stpr_webpage_view", objConn);
// Declare that the T-SQL statement that will be executed is a stored procedure
// Use a CommandType.Text to execute a T-SQL Query
webpage_view.CommandType = CommandType.StoredProcedure;
SqlParameter webpage_id_parm = webpage_view.Parameters.Add("@.webpage_id", SqlDbType.Int);
webpage_id_parm.Value = "1";
// Create a SqlDataAdapter to manage the connection and retrieve the data
SqlDataAdapter da_1 = new SqlDataAdapter();
// Instantiate a Dataset that will hold the data retrieved from the database using the select command
DataSet ds_webpage = new DataSet();
da_1.SelectCommand = webpage_view;
// Retrieve the data into the dataset using the SqlDataAdapter.Fill command
da_1.Fill( ds_webpage, "webpage_title" );
DataView dv2 = ds_webpage.Tables[0].DefaultView;
if ( !this.IsPostBack ) {
this.DataBind ( );
}


// C#
// To place a single value from a recordset into a label
// drag an ASP:Label onto the Web form and give it an ID of myLabel
myLabel.Text = "No data";
// Be compulsive and make sure there is a datatable in the dataset and that it has at least one row
if( ds_webpage.Tables.Count > 0 && ds_webpage.Tables[0].Rows.Count > ) ){
myLabel.Text = ds_webpage.Tables[0].Rows[0].ToString();
}

The simplest way to see how stored procedures can be used to select and update data is to let VS.Net create it for you.

1. Go to Design View for a web form.
2. Drag an SqlDataAdapter onto the form. A DataAdapter Configuration Wizard will open
3. Select your database connection and click Next.
4. On the Choose a Query Type screen select the second option "Create a new Stored Procedure". Click Next
5. On the Generate a Stored Procedure screen enter a select statement for the fields you want to use. For example, just something like Select * from SomeTable. Click Next.
6. On the Create the Stored Procedures screen enter appropriate stored procedure names. Be sure to click the "Yes, create them in the database for me" radio button.

Look at the code behind generated for this data adapter to see how it all works. Use it like the one you created above for the select. For the update, after you changed data in the data set just call:
da_1.Update( ds_webpage, "webpage_title" );

Basics Question for Non tecnical people

Hi, Anybody can give me a link where I can find basic information about
SQLserver2000.
I mean information like how many records a DB can hold, those questions that
have no answer in the product overview or What are the advantages comparing
it to Oracle etc.
I need to talk to Non technical people, and those are pretty much the
questions they ask.
ThanksHi
There are plenty of case studies and information on the SQL server web site
www.microsoft.com/sql. It would make more sense to compare SQL 2005 if you
are looking at a new purchase.
As far as number of records, the capacity is really dependent on hardware
and design rather than the DBMS for both.
John
"Kenny M." wrote:

> Hi, Anybody can give me a link where I can find basic information about
> SQLserver2000.
> I mean information like how many records a DB can hold, those questions th
at
> have no answer in the product overview or What are the advantages comparin
g
> it to Oracle etc.
> I need to talk to Non technical people, and those are pretty much the
> questions they ask.
> Thanks|||John Bell a écrit :
> Hi
> There are plenty of case studies and information on the SQL server web sit
e
> www.microsoft.com/sql. It would make more sense to compare SQL 2005 if you
> are looking at a new purchase.
> As far as number of records, the capacity is really dependent on hardware
> and design rather than the DBMS for both.
> John
> "Kenny M." wrote:
>
About how many rows wich must be query as how much data cans I have in
SQL Server, according to Wintercorp, there is a firm that use SQL Server
for _ 20 To database...
A +
Frédéric BROUARD, MVP SQL Server, expert bases de données et langage SQL
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
********************* http://www.datasapiens.com ***********************

Basics of T-Sql and XQuery

Pl let me know
1)the different between those two.
2)when to use?
and
3)anyone is Microsoft specific?

4) for and open xml can be used only in xquery?

1) XQuery is for querying XML fragments and T-SQL is a language that augments SQL for querying relational data.

2) You should use SQL for querying relation data and XQuery for querying XML within your applcation.

3) T-SQL has constructs that are SQL Server specific (i.e declaring a variable, while loops). The SQL part of the language has various Microsoft specific stuff, but we do try to align to the standard.

4) FOR XML and OPENXML are not part of XQuery. These were SQL Server 2000 technologies (still in 2005) used for composing and shredding xml to and from relational data.

Please see Books Online for more information: http://msdn2.microsoft.com/en-us/library/ms187875.aspx.

Regards,

Galex

Basics

Hi there,

I've recently bought Visual Studio 2005, and I got SQL server 2005. I have no idea how to work it. I can't even find where you make a table.

Any basic help about SQL server 2005 is needed.

Thanks,
AliQ

Hello AliQ,

SQL Server Books Online has all the information you need, including tutorials and the like. Perhaps do a google on "SQL Server tutorial".

Cheers,
Rob

|||

Hi AliQ:

To find books online from machines you have installed SQL Server 2005, go to Start -> Programs -> Microsoft SQL Server 2005 -> Documentation and Tutorials -> SQL Server Books On Line.

To start using SQL Server, Launch Microsoft SQL Server Management Studio by:

Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio.

When launched, if "Server name:" field is empty, please try to enter one of the following:

1. your computer name. or

2. (local)

and click "Connect" buttom.

Once when you connected to Database engine, you can create database, table, management database security..etc from here.

To learn more about SQL Server 2005, I'd recommand the following reference from MSDN.

http://msdn2.microsoft.com/en-us/library/ms950403.aspx

Hope this helps. :-)

Thanks.