Hi,
Is it possible to do a full text catalogue on an indexed view in SQL 2000?
It looks like you can only do tables and the functionality for indexed views
is in SQL 2005, is this correct?
Thanks
You are correct, you can only full-text index indexed views in SQL 2005.
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Letford" <Letford@.discussions.microsoft.com> wrote in message
news:AAA3603B-F2E6-4FCB-838A-7FC07FF1CBEF@.microsoft.com...
> Hi,
> Is it possible to do a full text catalogue on an indexed view in SQL 2000?
> It looks like you can only do tables and the functionality for indexed
> views
> is in SQL 2005, is this correct?
> Thanks
2012年3月27日星期二
2012年3月26日星期一
full text search on views?
Can we buld full text search on views? If yes, can I build a search catalog on a view that allowed both varchar and text columns?
Hi Abhi,
I've asked help for Tony Ting which is full text expert and here are his comments:
Answer is yes, but you could only build fulltext on indexed view (materialized view) and column are limited to all available in normal case but not on text/ntext/image/xml column. The later constraint is came from the current limitation that index could not be created on a indexed view w/ text/ntext/image/xml, but fulltext column need a primary index to work on.
Hope this helps.
Thanks,
Ana Elisa - MSFT
full text search on views?
Can we buld full text search on views? If yes, can I build a search catalog on a view that allowed both varchar and text columns?
Hi Abhi,
I've asked help for Tony Ting which is full text expert and here are his comments:
Answer is yes, but you could only build fulltext on indexed view (materialized view) and column are limited to all available in normal case but not on text/ntext/image/xml column. The later constraint is came from the current limitation that index could not be created on a indexed view w/ text/ntext/image/xml, but fulltext column need a primary index to work on.
Hope this helps.
Thanks,
Ana Elisa - MSFT
full text search on views in express edition
Hi
Is full text indexing possible on views in SQL server express edition with
advanced services? If Yes then how to do it on a view where I want to do
full text search on five different columns?
Thanks
ontario, canada
I am fairly certain that you can only have one full-text index per table or
*indexed* view. So, if your view is not indexed, you will need to create
your FT index on the underlying table(s).
"db" <db@.discussions.microsoft.com> wrote in message
news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> Hi
> Is full text indexing possible on views in SQL server express edition with
> advanced services? If Yes then how to do it on a view where I want to do
> full text search on five different columns?
> Thanks
> --
> ontario, canada
|||I created a full text index on the base table. Will use base table(L.B22) and
not view using syntex:
create fulltext index on L.B22
key index ui_fts22 on B221_fulltextcatalog
with change_tracking AUTO
Now I want to
1. View details about full text index in my database/table.
2. When I created index I created it on one column. I want to use full text
search on multiple columns. Can I add more columns and if yes how.
ontario, canada
"Aaron Bertrand [SQL Server MVP]" wrote:
> I am fairly certain that you can only have one full-text index per table or
> *indexed* view. So, if your view is not indexed, you will need to create
> your FT index on the underlying table(s).
>
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
>
>
Is full text indexing possible on views in SQL server express edition with
advanced services? If Yes then how to do it on a view where I want to do
full text search on five different columns?
Thanks
ontario, canada
I am fairly certain that you can only have one full-text index per table or
*indexed* view. So, if your view is not indexed, you will need to create
your FT index on the underlying table(s).
"db" <db@.discussions.microsoft.com> wrote in message
news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> Hi
> Is full text indexing possible on views in SQL server express edition with
> advanced services? If Yes then how to do it on a view where I want to do
> full text search on five different columns?
> Thanks
> --
> ontario, canada
|||I created a full text index on the base table. Will use base table(L.B22) and
not view using syntex:
create fulltext index on L.B22
key index ui_fts22 on B221_fulltextcatalog
with change_tracking AUTO
Now I want to
1. View details about full text index in my database/table.
2. When I created index I created it on one column. I want to use full text
search on multiple columns. Can I add more columns and if yes how.
ontario, canada
"Aaron Bertrand [SQL Server MVP]" wrote:
> I am fairly certain that you can only have one full-text index per table or
> *indexed* view. So, if your view is not indexed, you will need to create
> your FT index on the underlying table(s).
>
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
>
>
full text search on views in express edition
Hi
Is full text indexing possible on views in SQL server express edition with
advanced services? If Yes then how to do it on a view where I want to do
full text search on five different columns?
Thanks
--
ontario, canadaI am fairly certain that you can only have one full-text index per table or
*indexed* view. So, if your view is not indexed, you will need to create
your FT index on the underlying table(s).
"db" <db@.discussions.microsoft.com> wrote in message
news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> Hi
> Is full text indexing possible on views in SQL server express edition with
> advanced services? If Yes then how to do it on a view where I want to do
> full text search on five different columns?
> Thanks
> --
> ontario, canada|||I created a full text index on the base table. Will use base table(L.B22) and
not view using syntex:
create fulltext index on L.B22
key index ui_fts22 on B221_fulltextcatalog
with change_tracking AUTO
Now I want to
1. View details about full text index in my database/table.
2. When I created index I created it on one column. I want to use full text
search on multiple columns. Can I add more columns and if yes how.
ontario, canada
"Aaron Bertrand [SQL Server MVP]" wrote:
> I am fairly certain that you can only have one full-text index per table or
> *indexed* view. So, if your view is not indexed, you will need to create
> your FT index on the underlying table(s).
>
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> >
> > Hi
> >
> > Is full text indexing possible on views in SQL server express edition with
> > advanced services? If Yes then how to do it on a view where I want to do
> > full text search on five different columns?
> >
> > Thanks
> > --
> > ontario, canada
>
>
Is full text indexing possible on views in SQL server express edition with
advanced services? If Yes then how to do it on a view where I want to do
full text search on five different columns?
Thanks
--
ontario, canadaI am fairly certain that you can only have one full-text index per table or
*indexed* view. So, if your view is not indexed, you will need to create
your FT index on the underlying table(s).
"db" <db@.discussions.microsoft.com> wrote in message
news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> Hi
> Is full text indexing possible on views in SQL server express edition with
> advanced services? If Yes then how to do it on a view where I want to do
> full text search on five different columns?
> Thanks
> --
> ontario, canada|||I created a full text index on the base table. Will use base table(L.B22) and
not view using syntex:
create fulltext index on L.B22
key index ui_fts22 on B221_fulltextcatalog
with change_tracking AUTO
Now I want to
1. View details about full text index in my database/table.
2. When I created index I created it on one column. I want to use full text
search on multiple columns. Can I add more columns and if yes how.
ontario, canada
"Aaron Bertrand [SQL Server MVP]" wrote:
> I am fairly certain that you can only have one full-text index per table or
> *indexed* view. So, if your view is not indexed, you will need to create
> your FT index on the underlying table(s).
>
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> >
> > Hi
> >
> > Is full text indexing possible on views in SQL server express edition with
> > advanced services? If Yes then how to do it on a view where I want to do
> > full text search on five different columns?
> >
> > Thanks
> > --
> > ontario, canada
>
>
2012年3月9日星期五
Full Text Image Type
Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
Pra
With
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Pra" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Pra
>
>
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
Pra
WithSELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Pra
" <ekke_nikhil@.yahoo.co.uk> wrote in messagenews:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Pra
>
>
Full Text Image Type
Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
Prasad
With
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
Prasad
With
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>
Full Text Image Type
Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PrasadWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PrasadWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>
Full Text Image Type
Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PrasadWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PrasadWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>
2012年3月7日星期三
FULL SEARCH
Is there a simple way to search all the views/stored procedures in a database which contain particular text without having to open each one?
The object search which i thought might work in query analyzer will only search by object name so thats a dead end.
A point to make here though... you should have ALL of your system object create/alter scripts stored to file and preferably a source control system (like VSS). You could take this as an opportunity to save everything to file. You can then easily use the windows search function (or similar) to search inside those files.
Full Screen in Report Manager?
Hi all...
I'm curious if there is a way to default to "full screen" mode when a
user first views a report through report manager. The users here can
click the arrows on the right side and thus make the "header" of the
page collapse, but is there a way to default to that so that the users
don't have to click the arrows?
I had read something about the option to collapse the parameter portion
of the report coming with SP1, which we just installed, but haven't
been able pinpoint how to do it.
We've also given users to ability to access reports via our intranet by
physically typing in the address to our intranet. That address
redirects to the report server - wondering if this may make a
difference in the ability to default to full screen.
Any help is appreciated.
Thanks,
MattIn the link you use to call the report add in &rc:Toolbar=false and
possibly &rc:Parameters=false to remove everything.
ie
src="http://myreportserver/ReportServer?%2fReportfolder%2fParameter&rc%3aParameters=false&rc:LinkTarget=_self&rc:ToolBar=false"|||Thanks for the info! I know that the answer to my problem is in there
somewhere, but when I copy what you have after
"myreportserver/ReportServer" in the link above and add it to the URL
that my project points to, I'm being asked for login/password, and that
shouldn't be happening?
Am I able to take parts of what you wrote above to make the parameters
not be viewable? Sorry to wollow in the details of this as I'm guessing
it's not all that complicated, but it's the first time I've given this
a shot, so thanks for your patience.
Matt|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Thanks once again for the help.
When I add the piece to suppress parameters and/or the toolbar, I end
up with this link as what is entered for the TargetURL for the
solution:
http://servername/ReportServer&rc:ToolBar=false
When I hit F5 to push the changes to the server, I end up getting the
following:
"A connection could not be made to the report server
http://servername/ReportServer&rc:ToolBar=false"
Any idea what I'm missing or doing wrong here? Do I need a "?" directly
after "reportserver"....this is one of those things that is a small
problem, but the annoyance that it is causing is growing!!
Again, thanks for the help...
Matt
I'm curious if there is a way to default to "full screen" mode when a
user first views a report through report manager. The users here can
click the arrows on the right side and thus make the "header" of the
page collapse, but is there a way to default to that so that the users
don't have to click the arrows?
I had read something about the option to collapse the parameter portion
of the report coming with SP1, which we just installed, but haven't
been able pinpoint how to do it.
We've also given users to ability to access reports via our intranet by
physically typing in the address to our intranet. That address
redirects to the report server - wondering if this may make a
difference in the ability to default to full screen.
Any help is appreciated.
Thanks,
MattIn the link you use to call the report add in &rc:Toolbar=false and
possibly &rc:Parameters=false to remove everything.
ie
src="http://myreportserver/ReportServer?%2fReportfolder%2fParameter&rc%3aParameters=false&rc:LinkTarget=_self&rc:ToolBar=false"|||Thanks for the info! I know that the answer to my problem is in there
somewhere, but when I copy what you have after
"myreportserver/ReportServer" in the link above and add it to the URL
that my project points to, I'm being asked for login/password, and that
shouldn't be happening?
Am I able to take parts of what you wrote above to make the parameters
not be viewable? Sorry to wollow in the details of this as I'm guessing
it's not all that complicated, but it's the first time I've given this
a shot, so thanks for your patience.
Matt|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Thanks once again for the help.
When I add the piece to suppress parameters and/or the toolbar, I end
up with this link as what is entered for the TargetURL for the
solution:
http://servername/ReportServer&rc:ToolBar=false
When I hit F5 to push the changes to the server, I end up getting the
following:
"A connection could not be made to the report server
http://servername/ReportServer&rc:ToolBar=false"
Any idea what I'm missing or doing wrong here? Do I need a "?" directly
after "reportserver"....this is one of those things that is a small
problem, but the annoyance that it is causing is growing!!
Again, thanks for the help...
Matt
Full Screen in Report Manager
Hi all....
I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?
We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.
Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,
I have been investigating this further and can offer the following:
Using the url
http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>
produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.
If you point the user to the url
http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render
you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.
&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it
I hope this helps
Cheers
Rich
Full Screen in Report Manager
Hi all....
I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?
We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.
Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,
I have been investigating this further and can offer the following:
Using the url
http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>
produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.
If you point the user to the url
http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render
you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.
&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it
I hope this helps
Cheers
Rich
Full Screen in Report Manager
Hi all....
I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?
We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.
Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,
I have been investigating this further and can offer the following:
Using the url
http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>
produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.
If you point the user to the url
http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render
you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.
&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it
I hope this helps
Cheers
Rich
订阅：
博文 (Atom)