Books on Full Text Search

Are there any decent books that cover full text search?How about http://www.apress.com/book/bookDisplay.html?bID=146
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Brad" <me@.privacy.net> wrote in message
news:MPG.1a9e06a3e883e9a98bc4a@.news...
> Are there any decent books that cover full text search?

Books on Full Text Search

Are there any decent books that cover full text search?How about http://www.apress.com/book/bookDisplay.html?bID=146
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Brad" <me@.privacy.net> wrote in message
news:MPG.1a9e06a3e883e9a98bc4a@.news...
> Are there any decent books that cover full text search?

Book Recommendation?

Can anyone recommend a good book or site on Full Text Searching which goes
into detail about things like full text ranked search across multiple tables
especially using phrases not single words? I find the whole thing counter
intuitive compared to normal SQL
Chris,
Not at this time... but look for http://www.SQLFTS.com to come online soon
with content as I own this URL and I'm currently developing the content. As
for a book, I just today re-submitted a new book proposal to a publisher's
Editor-in-Chief (at her request) as the overall technical book market has
been in decline and new books have been difficult to launch on this subject.
However, with the Google IPO and with various announcements from Microsoft,
MSN and Steve Ballmer -
http://www.boston.com/business/techn...llenge_google/
- to quote this article - "Meanwhile, Ballmer left no doubt that Microsoft
has targeted Internet search services for the kind of all-out competitive
push that the company once used to seize dominance in Web browser software.
Despite Google's popularity, "the search market is still quite fragmented,"
Ballmer said, and existing tools still generate lots of useless results.
Ballmer said Microsoft plans to invent new search technology that will
change this, and make life more difficult for Google and other rivals."
So, now it seems to be a good time to be writing a book on Microsoft Search
Technology, including SQL Server 2005! Anyone should feel free to post &/or
email me (mailto:jt-kane@.comcast.net) with comments, encouragements,
feedback, suggestions etc. on both website content as well as future book
content!
Thanks,
John
Looking for a book &/or information on SQL FTS?
http://www.SQLFTS.com - First To Search for SQL Full-Text Search
"Chris Kennedy" <chrisknospam@.cybase.co.uk> wrote in message
news:O0WRakQkEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Can anyone recommend a good book or site on Full Text Searching which goes
> into detail about things like full text ranked search across multiple
tables
> especially using phrases not single words? I find the whole thing counter
> intuitive compared to normal SQL
>

Bold AND Italic Text Not Possible?

Is it not possible to format text as bold and italic in SRS? I find
this hard to believe, but whenener I specify both properties
(FontWeight and FontStyle), the italic property overrides the bold
property. Anyone else encountered this problem? Is there a work-
around?On Feb 8, 10:40 am, m...@.swbell.net wrote:
> Is it not possible to format text as bold and italic in SRS? I find
> this hard to believe, but whenener I specify both properties
> (FontWeight and FontStyle), the italic property overrides the bold
> property. Anyone else encountered this problem? Is there a work-
> around?
Are you using RS 2005?|||On Feb 8, 10:19 am, "DMcM" <mcmah...@.twcny.rr.com> wrote:
> On Feb 8, 10:40 am, m...@.swbell.net wrote:
> > Is it not possible to format text as bold and italic in SRS? I find
> > this hard to believe, but whenener I specify both properties
> > (FontWeight and FontStyle), the italic property overrides the bold
> > property. Anyone else encountered this problem? Is there a work-
> > around?
> Are you using RS 2005?
Thanks for your reply. Yes I am. I am setting both properties at
design time. It appears that FontStyle is the dominant property. Its
strange. You can do this with every other Microsoft product...

Body values in Header and header values in body

Hi,

I want to display a value from db in the header section. I have read a couple of information that I should place the value in a in-visible text field an reference it in the header with the ReportItems. This works great with the first page but on the second page the header information are empty (I think because the Textfield is on Page 1 not Page 2)... So is there a way to accomplish that for all pages? Not only the first page....

My second one, hope you don't mind that I post it in the same thread, is:

My Report needs to display the total size of pages in the body. I did not realy found anything useful where I can retrieve from the total size of pages of my reports....

thanks for any help

f.

I have run into issues with wanting to display data in the report headers. I have pretty much moved on from wanting to do it since it is such a pain.

Also to show the total pages I put this code in the page footer, ="Page " & Globals!PageNumber & " of " & Globals!TotalPage. This will show the current page out of how many pages at the bottom of each page.

|||I have tried Globals!TotalPage but it cannot be placed in the body... I got an error message|||The Globals!TotalPages can only be used in a page header or footer, not in the body. You will have to add a page header or footer and then put it in a textbox there.

blog select with comment count

The following sql works great when the field for my main blog message is type nvarchar but doesn't work for text which I need to convert to.

select
a.id, b.textField
count(b.a_id) as myCount
from a left join b on a.id = b.a_id
group by a.id, b.textField

What other methods could i use to get "myCount" within one sql statement?

Thanks in advance, JeffHere is more information:

using sql server 2000 (from asp.net) the following sql works great when the "textForm" field is of type nvarchar but doesn't work for the text type.

I don't believe nvarchar will work for my needs since it is limited to 8000 (4000 due to double storage). I believe I will need to use the text type.

select bm.message_id,
bm.title,
bm.display_date,
bm.message,
count(bc.comment_id) as commentCount
from blog_messages as bm LEFT JOIN blog_comments as bc
on bm.message_id = bc.message_id
where bm.active_flag = 1
group by bm.message_id, bm.title, bm.display_date, bm.message
order by display_date DESC

The purpose of the select statement is to display a list of blog entries that includes the number of comments on each entry. An example of this in cold fusion is found at
http://www.camdenfamily.com/morpheus/blog/

With my limited knowledge of the asp.net repeater control, I'm not sure how to integrate 2 select statements (1st for blog content, 2nd for comment count). It seems the fastest way to get all of the information I want is to use a stored procedure using either a temp table or a cursor to compile all of the data together. However this method may forcee me to select the count from table b for each record of table a which could be time consuming.

Is there any way to achieve this goal with one select using the union statement or another type of join?

Although this might be a better sql question, I am also wondering about alternative asp.net solutions including repeaters with 2 or more select statements or using an array or list.|||How about something like:

select a.id,
b.textField,
myCount = (select count(*) from b where a_id = a.id)
from a

You might need to include a COALESCE function around the correlated subquery to check for NULL and send back a zero.|||it worked! thanks!

select bm.message_id,
bm.title,
bm.display_date,
bm.message,
commentCount = (select count('x')
from blog_comments as bc
where bc.message_id = bm.message_id)
from blog_messages as bm
where bm.active_flag = 1
order by bm.display_date DESC

BLOBs and the 8K rows

Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
they more like images and text and not restricted to 8KB?
ThanksDepend how is setup the table's option "text in row" for this specific table
.
See "sp_tableoption" in BOL for more info.
AMB
"Robert Kinesta" wrote:

> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks|||Hi
BLOB is a synonym for Image and Text data types.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:BFD95D29-B5A7-4DB1-BCB6-E26FAFD8CF7C@.microsoft.com...
> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks|||BLOBs (image and text) are not restricted by the 8KB row size. A BLOB could
be as big as 2Gb. It is stored to multiple 8KB pages and managered by a
btree-like structure.
Stephen Jiang
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:BFD95D29-B5A7-4DB1-BCB6-E26FAFD8CF7C@.microsoft.com...
> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks

BLOBs and the 8K rows

Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
they more like images and text and not restricted to 8KB?
Thanks
Depend how is setup the table's option "text in row" for this specific table.
See "sp_tableoption" in BOL for more info.
AMB
"Robert Kinesta" wrote:

> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks
|||Hi
BLOB is a synonym for Image and Text data types.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:BFD95D29-B5A7-4DB1-BCB6-E26FAFD8CF7C@.microsoft.com...
> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks
|||BLOBs (image and text) are not restricted by the 8KB row size. A BLOB could
be as big as 2Gb. It is stored to multiple 8KB pages and managered by a
btree-like structure.
Stephen Jiang
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:BFD95D29-B5A7-4DB1-BCB6-E26FAFD8CF7C@.microsoft.com...
> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks

BLOBs and the 8K rows

Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
they more like images and text and not restricted to 8KB?
ThanksDepend how is setup the table's option "text in row" for this specific table.
See "sp_tableoption" in BOL for more info.
AMB
"Robert Kinesta" wrote:
> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks|||Hi
BLOB is a synonym for Image and Text data types.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:BFD95D29-B5A7-4DB1-BCB6-E26FAFD8CF7C@.microsoft.com...
> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks|||BLOBs (image and text) are not restricted by the 8KB row size. A BLOB could
be as big as 2Gb. It is stored to multiple 8KB pages and managered by a
btree-like structure.
--
Stephen Jiang
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:BFD95D29-B5A7-4DB1-BCB6-E26FAFD8CF7C@.microsoft.com...
> Does anyone know if BLOBs are restricted by the 8KB row size rule? Or are
> they more like images and text and not restricted to 8KB?
> Thanks

Blob as text

Hi,

I have a conversion application which convertts an access database to an sql server(different versions). I'm using stored procedures. The thins is that I export the OLe Object form access to SQL varbinary. what I do is to convert the binary data from the OLE Object to string using ToBase64String. The thing is that when I execute the SQL statement I get the following error:

Error:Operand type clash: text is incompatible with varbinary.

Can anyone tell me what I do wrong and how can I fix this? Thanks.

Can you post the SQL Statement that is being sent? At the very least print the text out and post it here. In the statement the value should look something like:

'010101'

and not like:

0x010101

If not, you might want to go to the language specific forum to ask there by posting the code you are trying to use.

|||

the value is something like:

'DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg=='

|||

That is not binary, binary would be something like this 0x53516C20536572766572

what you posted is some (.NET) encrypted value that is stored in a column

The person/program who encrypted that is the person who will be able to decrypt that value also

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||well if you'd read the hole post you 'd notice that I've applied the ToBase64String function to the binary data. |||

That value looks okay enough. What about the query that is doing the entering? Can you capture that with profiler?
If this is a varchar or text column, that value should work just fine. For example:

CREATE TABLE testText
(
textValue text --use varchar(max) if this is SQL Server 2005
)
go
INSERT INTO testText
SELECT 'DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg=='
go
SELECT *
FROM testText

textValue
-
DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg==

So there is something else going on...

|||

Well as I've said I'm using SQL statements stored in a file. The statement is something like:

CREATE TABLE testBin
(
textValue varbinary

)
go
INSERT INTO testBin('DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg==')
go

|||

Try this

CREATE TABLE testBin
(
textValue varbinary(5000)

)
go
INSERT INTO testBin VALUES(convert(varbinary(5000),'DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg=='))
go

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

You are trying to convert a string literal that is not in hexadecimal format to varbinary implicitly and this will not work. You need to use either text/ntext in SQL Server 2000 or varchar(max)/nvarchar(max) in SQL Server 2005 for the destination column. Or you can cast the value from one type to another which hurts performance. See BOL topic below on how to specify values for various data types:

http://msdn2.microsoft.com/en-us/ms179899(SQL.90).aspx

And also the CAST topic that has a table showing various conversions possible (implicit/explicit).

http://msdn2.microsoft.com/en-us/ms187928(SQL.90).aspx

|||well do you have a better solution for importing blob data using stored sql statements? And this should work with sql 2000 and 2005 also.|||Would this help.

create table tmp(i int identity primary key,img image default '0x0')
insert tmp(img) values(default)

go
create proc usp
@.i int,
@.img image
as
declare @.ptr binary(16)
select @.ptr=textptr(img)
from tmp
where i=@.i

writetext tmp.img @.ptr @.img
go
declare @.b varbinary(8000)
set @.b=0x0000007B

exec usp 1,@.b

select *,convert(int,@.b) ,convert(int,convert(binary(4),img)) [img]
from tmp
go
drop proc usp
drop table tmp|||

Thanks for your reply! But it doesn't help; because I want to do everything with SQL statements. Meaning I want to export the Access database to a file which contains SQL statements, which can be run on using an SQL command interpreter like osql.exe or my own SQL command interpreter. So the blob has to be in the SQL statement stored in the SQL file.

Any idea?

Blob as text

Hi,

I have a conversion application which convertts an access database to an sql server(different versions). I'm using stored procedures. The thins is that I export the OLe Object form access to SQL varbinary. what I do is to convert the binary data from the OLE Object to string using ToBase64String. The thing is that when I execute the SQL statement I get the following error:

Error:Operand type clash: text is incompatible with varbinary.

Can anyone tell me what I do wrong and how can I fix this? Thanks.

Can you post the SQL Statement that is being sent? At the very least print the text out and post it here. In the statement the value should look something like:

'010101'

and not like:

0x010101

If not, you might want to go to the language specific forum to ask there by posting the code you are trying to use.

|||

the value is something like:

'DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg=='

|||

That is not binary, binary would be something like this 0x53516C20536572766572

what you posted is some (.NET) encrypted value that is stored in a column

The person/program who encrypted that is the person who will be able to decrypt that value also

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||well if you'd read the hole post you 'd notice that I've applied the ToBase64String function to the binary data. |||

That value looks okay enough. What about the query that is doing the entering? Can you capture that with profiler?
If this is a varchar or text column, that value should work just fine. For example:

CREATE TABLE testText
(
textValue text --use varchar(max) if this is SQL Server 2005
)
go
INSERT INTO testText
SELECT 'DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg=='
go
SELECT *
FROM testText

textValue
-
DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg==

So there is something else going on...

|||

Well as I've said I'm using SQL statements stored in a file. The statement is something like:

CREATE TABLE testBin
(
textValue varbinary

)
go
INSERT INTO testBin('DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg==')
go

|||

Try this

CREATE TABLE testBin
(
textValue varbinary(5000)

)
go
INSERT INTO testBin VALUES(convert(varbinary(5000),'DQpbUmVmZXJlbmNlXQ0KRmllbGQxPUFrdGVuVlouQU5SDQpGaWVsZDI9QWt0ZW5WWi5Qcm9qTlINCkZpZWxkMz1Ba3RlblZaLlJFRjENCkZpZWxkND1Ba3RlblZaLlJFRjINCkZpZWxkNT1Ba3RlblZaLkFDQVVTQQ0KRmllbGQ2PUtsaWVudFZaLlNob3J0Tm0NCkZpZWxkNz1LbGllbnRWWi5CT3J0DQpGaWVsZDg9R2VnbmVyVlouU2hvcnRObQ0KRmllbGQ5PUdlZ25lclZaLkJPcnQNCkZpZWxkMTA9QWt0ZW5WWi5BSU5SDQpGaWVsZFNlcD1UQUINCg=='))
go

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

You are trying to convert a string literal that is not in hexadecimal format to varbinary implicitly and this will not work. You need to use either text/ntext in SQL Server 2000 or varchar(max)/nvarchar(max) in SQL Server 2005 for the destination column. Or you can cast the value from one type to another which hurts performance. See BOL topic below on how to specify values for various data types:

http://msdn2.microsoft.com/en-us/ms179899(SQL.90).aspx

And also the CAST topic that has a table showing various conversions possible (implicit/explicit).

http://msdn2.microsoft.com/en-us/ms187928(SQL.90).aspx

|||well do you have a better solution for importing blob data using stored sql statements? And this should work with sql 2000 and 2005 also.|||Would this help.

create table tmp(i int identity primary key,img image default '0x0')
insert tmp(img) values(default)

go
create proc usp
@.i int,
@.img image
as
declare @.ptr binary(16)
select @.ptr=textptr(img)
from tmp
where i=@.i

writetext tmp.img @.ptr @.img
go
declare @.b varbinary(8000)
set @.b=0x0000007B

exec usp 1,@.b

select *,convert(int,@.b) ,convert(int,convert(binary(4),img)) [img]
from tmp
go
drop proc usp
drop table tmp|||

Thanks for your reply! But it doesn't help; because I want to do everything with SQL statements. Meaning I want to export the Access database to a file which contains SQL statements, which can be run on using an SQL command interpreter like osql.exe or my own SQL command interpreter. So the blob has to be in the SQL statement stored in the SQL file.

Any idea?

Blank Ones..

Hi !

I have a full text catalog for a table under a database. all was working, until 2-3 days back,which we created 4 months back.
Now my search in my website , doesnt retrieve any records .

when i checked job History for this Full text catalog, its showin this error:-
Full-Text Search is not enabled for the current database.
Use sp_fulltext_database to enable Full-Text Search. [SQLSTATE 42000] (Error 15601). The step failed.

what should i do to make everything ok..?

Please advice me...!

Thanks !i forgot to add...

I am using SQL 2000 with W2K.

Can i do INCREMENTAL POPULATION ..?

Please help me...!!!

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve