Books Online Help..

I have installed SQL Server 2000 Personal edition on my desktop, which has a C: and a D: drive. All the program files, WINNT folder are on D: drive and the SQL Server has also been installed on the D: Drive.
Now when I try to open the Books online then I get the error " unable to open D:\Program files\Microsoft SQL Server\~sql80.col.
Any help??Have you tried reinstalling?

Did you check to see whether sql80.col exists on your D drive?

Do you get this error when you invoke the help system through both the Windows Menu bar and Query Analyzer's help menu?

Can you run the following command:
C:\WINNT\hh.exe "D:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col"?

blindman|||The location should be "D:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col"

Books OnLine (chm files) Problem

Hi All,

I searched this news group but couldn't find that problem which
is suprising... maybe I'm doing something stupid.

I start one of the chm files (books on line help files).
I read about a topic. There are links.
I click on them. It tells me "Selection is not associated with any
topic. Please try again.". Its ahref link to jscript function:
javascript:hhobj_1.Click() but I do not have it and cannot find it.
So I have to go between all those chm files hoping to find the topic
of my choice.
Plus I want to search them all at once.
There must be a (smart) and easy way to do this.
Please, do you have any suggestions.

Thankfully

Jimmy Ol' BoyJimmy,

> I start one of the chm files (books on line help files). I read about a
> topic. There are links. I click on them. It tells me "Selection is not
> associated with any topic. Please try again.".

A number of the security patches for Internet Explorer that Microsoft
has released this year are known to break the HTML Help ActiveX
control, which is the component that provides the navigation
facilities in help files.

The problem is described in Knowledge Base article 822989 and, in most
cases, installing Critical Update 811630 should sort it out.

822989: http://support.microsoft.com/?kbid=822989
811630: http://support.microsoft.com/?kbid=811630

The exception to this is Windows 2000 with Service Pack 4 installed.
In this case, you must unregister the ActiveX control and then
re-register it, by running the following two commands from a command
prompt:

regsvr32 /u <drive>:\winnt\system32\hhctrl.ocx
regsvr32 <drive>:\winnt\system32\hhctrl.ocx

--
Pete (Microsoft Help MVP)

BOL May 2007 shows no index and no table of contents

I downloaded and installed SqlServer2K5_BOL_May2007.msi, and it had no index and no table of contents. The shortcut is
"C:\Program Files\Common Files\Microsoft Shared\Help 8\dexplore.exe" /helpcol ms-help://MS.SQLCC.v9 /usehelpsettings SQLServerBooksOnline.9.0 /LaunchFKeywordTopic sql9.portal.f1

there are table of contents files:

Directory of C:\Program Files\Microsoft SQL Server\90\Tools\Books\1033

01/26/2007 11:59 AM 12,949 sql90.hxt
07/27/2006 07:53 AM 271 SQLCC.hxt
11/07/2006 02:16 PM 687 ssm3.hxt

and there are index files too -- the most important one seeming to be :

05/23/2007 12:44 PM 13,630,606 sql90.hxq

I re-executed the .msi and chose repair.
That didn't work to show the index or TC either.

I will try a reboot -- but then I'll have to resintall the previous BOL.

I downloaded and installed it, I was asked about a previous version and choose yes to override it. I am also running Katamai BOL both runs fine. I have no problems, so I think you should delete the download and get a new file for the next install. Hope this helps.|||TOC and index have showed up after a reboot. (Windows XP SP2)

bmp BLOP fields

Hi,
Does Sql reporting services support Bmp BLOB files?
SapnilSapnil, I believe the answer is yes.
You'll need an image control and choose 'Database' as the 'Source' and
the appropriate column name as the 'Value'. Also select the appropriate
MIME type.
Chris
Sapnil wrote:
> Hi,
> Does Sql reporting services support Bmp BLOB files?
> Sapnil|||Having re-read your post, I should clarify that I assume you mean
bitmaps stored in the database as BLOB fields?
If you mean external files then again yes it can, either using a field
containing the url/unc path or some other direct path are expression to
the path.
Chris
Chris McGuigan wrote:
> Sapnil, I believe the answer is yes.
> You'll need an image control and choose 'Database' as the 'Source' and
> the appropriate column name as the 'Value'. Also select the
> appropriate MIME type.
> Chris
> Sapnil wrote:
> > Hi,
> >
> > Does Sql reporting services support Bmp BLOB files?
> >
> > Sapnil|||I tried as you said. But the BMP imgaes are not displayed in the report.
I tried the same with crystal reports and it worked.
"Chris McGuigan" wrote:
> Having re-read your post, I should clarify that I assume you mean
> bitmaps stored in the database as BLOB fields?
> If you mean external files then again yes it can, either using a field
> containing the url/unc path or some other direct path are expression to
> the path.
> Chris
>
> Chris McGuigan wrote:
> > Sapnil, I believe the answer is yes.
> > You'll need an image control and choose 'Database' as the 'Source' and
> > the appropriate column name as the 'Value'. Also select the
> > appropriate MIME type.
> >
> > Chris
> >
> > Sapnil wrote:
> >
> > > Hi,
> > >
> > > Does Sql reporting services support Bmp BLOB files?
> > >
> > > Sapnil
>|||Sapnil,
I've just checked the Sample Report, Product Catalogue. This uses this
feature and works. It shows an image for each stock item and the image
is taken directly from the database. I suspect you've a setting wrong.
I suggest you load and take a look at this sample report. Look up
sample reports in BOL for details.
In the sample the image is inside a rectangle, which may confuse you
when trying to select it. In the properties pane, in the drop-down list
of property names select ProdPhoto.
Chris
Sapnil wrote:
> I tried as you said. But the BMP imgaes are not displayed in the
> report. I tried the same with crystal reports and it worked.
> "Chris McGuigan" wrote:
> > Having re-read your post, I should clarify that I assume you mean
> > bitmaps stored in the database as BLOB fields?
> > If you mean external files then again yes it can, either using a
> > field containing the url/unc path or some other direct path are
> > expression to the path.
> >
> > Chris
> >
> >
> > Chris McGuigan wrote:
> >
> > > Sapnil, I believe the answer is yes.
> > > You'll need an image control and choose 'Database' as the
> > > 'Source' and the appropriate column name as the 'Value'. Also
> > > select the appropriate MIME type.
> > >
> > > Chris
> > >
> > > Sapnil wrote:
> > >
> > > > Hi,
> > > >
> > > > Does Sql reporting services support Bmp BLOB files?
> > > >
> > > > Sapnil
> >
> >|||Chirs,
I have tried the sample product catalog sample report and it works for me too.
But If I am not wrong the images stored in the BLOB fieds are of type GIF
I tried the same thing with the Northwind database, trying to display the
employees on the report, but there seems to be some problem.
Sapnil
"Chris McGuigan" wrote:
> Sapnil,
> I've just checked the Sample Report, Product Catalogue. This uses this
> feature and works. It shows an image for each stock item and the image
> is taken directly from the database. I suspect you've a setting wrong.
> I suggest you load and take a look at this sample report. Look up
> sample reports in BOL for details.
> In the sample the image is inside a rectangle, which may confuse you
> when trying to select it. In the properties pane, in the drop-down list
> of property names select ProdPhoto.
> Chris
>
> Sapnil wrote:
> > I tried as you said. But the BMP imgaes are not displayed in the
> > report. I tried the same with crystal reports and it worked.
> >
> > "Chris McGuigan" wrote:
> >
> > > Having re-read your post, I should clarify that I assume you mean
> > > bitmaps stored in the database as BLOB fields?
> > > If you mean external files then again yes it can, either using a
> > > field containing the url/unc path or some other direct path are
> > > expression to the path.
> > >
> > > Chris
> > >
> > >
> > > Chris McGuigan wrote:
> > >
> > > > Sapnil, I believe the answer is yes.
> > > > You'll need an image control and choose 'Database' as the
> > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > select the appropriate MIME type.
> > > >
> > > > Chris
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Does Sql reporting services support Bmp BLOB files?
> > > > >
> > > > > Sapnil
> > >
> > >
>|||It's MIME type is set to image/bmp, so I assume it's bmp!
I've never actually used Blob fields. So I'm going by the book rather
than experience! Have you tried all the different MIME types against
your data? Are you 100% sure your fields contain bitmaps and not gifs
or jpegs? I guess you are because you've had it working in Crystal, but
it's worth a check!
Regards
Chris
Sapnil wrote:
> Chirs,
> I have tried the sample product catalog sample report and it works
> for me too. But If I am not wrong the images stored in the BLOB
> fieds are of type GIF I tried the same thing with the Northwind
> database, trying to display the employees on the report, but there
> seems to be some problem.
> Sapnil
> "Chris McGuigan" wrote:
> > Sapnil,
> > I've just checked the Sample Report, Product Catalogue. This uses
> > this feature and works. It shows an image for each stock item and
> > the image is taken directly from the database. I suspect you've a
> > setting wrong.
> >
> > I suggest you load and take a look at this sample report. Look up
> > sample reports in BOL for details.
> >
> > In the sample the image is inside a rectangle, which may confuse you
> > when trying to select it. In the properties pane, in the drop-down
> > list of property names select ProdPhoto.
> >
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > I tried as you said. But the BMP imgaes are not displayed in the
> > > report. I tried the same with crystal reports and it worked.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Having re-read your post, I should clarify that I assume you
> > > > mean bitmaps stored in the database as BLOB fields?
> > > > If you mean external files then again yes it can, either using a
> > > > field containing the url/unc path or some other direct path are
> > > > expression to the path.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Chris McGuigan wrote:
> > > >
> > > > > Sapnil, I believe the answer is yes.
> > > > > You'll need an image control and choose 'Database' as the
> > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > select the appropriate MIME type.
> > > > >
> > > > > Chris
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > >
> > > > > > Sapnil
> > > >
> > > >
> >
> >|||I have tried all MIME types.
And you are right, its working with crystal reports.
Actually I am in the process of evaluating repoting tools.
"Chris McGuigan" wrote:
> It's MIME type is set to image/bmp, so I assume it's bmp!
> I've never actually used Blob fields. So I'm going by the book rather
> than experience! Have you tried all the different MIME types against
> your data? Are you 100% sure your fields contain bitmaps and not gifs
> or jpegs? I guess you are because you've had it working in Crystal, but
> it's worth a check!
> Regards
> Chris
>
> Sapnil wrote:
> > Chirs,
> > I have tried the sample product catalog sample report and it works
> > for me too. But If I am not wrong the images stored in the BLOB
> > fieds are of type GIF I tried the same thing with the Northwind
> > database, trying to display the employees on the report, but there
> > seems to be some problem.
> >
> > Sapnil
> >
> > "Chris McGuigan" wrote:
> >
> > > Sapnil,
> > > I've just checked the Sample Report, Product Catalogue. This uses
> > > this feature and works. It shows an image for each stock item and
> > > the image is taken directly from the database. I suspect you've a
> > > setting wrong.
> > >
> > > I suggest you load and take a look at this sample report. Look up
> > > sample reports in BOL for details.
> > >
> > > In the sample the image is inside a rectangle, which may confuse you
> > > when trying to select it. In the properties pane, in the drop-down
> > > list of property names select ProdPhoto.
> > >
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I tried as you said. But the BMP imgaes are not displayed in the
> > > > report. I tried the same with crystal reports and it worked.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Having re-read your post, I should clarify that I assume you
> > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > If you mean external files then again yes it can, either using a
> > > > > field containing the url/unc path or some other direct path are
> > > > > expression to the path.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Chris McGuigan wrote:
> > > > >
> > > > > > Sapnil, I believe the answer is yes.
> > > > > > You'll need an image control and choose 'Database' as the
> > > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > > select the appropriate MIME type.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > >
> > > > > > > Sapnil
> > > > >
> > > > >
> > >
> > >
>|||Hi Sapnil,
I'm a bit stumped I'm afraid. What exactly are you getting?
In terms of evaluation, I'm an ex-Crystal user who switched to RS last
February and have had little need to revert back since.
That's not to say that there are things Crystal doesn't do better than
RS, but for my environment, RS has many more advantages. I'm playing
with RS2005 now (due to be "launched" early November) and it's looking
good with ReportBuilder filling many of the RS's shortcomings against
Crystal. This is a bit off topic now but if you trawl this newsgroup
you'll see plenty of worthwhile exchanges on the pro's and con's of
various reporting tools.
Obviously this image issue is a problem for you! Are you using SP1 or
SP2?
Chris
Sapnil wrote:
> I have tried all MIME types.
> And you are right, its working with crystal reports.
> Actually I am in the process of evaluating repoting tools.
> "Chris McGuigan" wrote:
> > It's MIME type is set to image/bmp, so I assume it's bmp!
> > I've never actually used Blob fields. So I'm going by the book
> > rather than experience! Have you tried all the different MIME types
> > against your data? Are you 100% sure your fields contain bitmaps
> > and not gifs or jpegs? I guess you are because you've had it
> > working in Crystal, but it's worth a check!
> >
> > Regards
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > Chirs,
> > > I have tried the sample product catalog sample report and it works
> > > for me too. But If I am not wrong the images stored in the BLOB
> > > fieds are of type GIF I tried the same thing with the Northwind
> > > database, trying to display the employees on the report, but there
> > > seems to be some problem.
> > >
> > > Sapnil
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Sapnil,
> > > > I've just checked the Sample Report, Product Catalogue. This
> > > > uses this feature and works. It shows an image for each stock
> > > > item and the image is taken directly from the database. I
> > > > suspect you've a setting wrong.
> > > >
> > > > I suggest you load and take a look at this sample report. Look
> > > > up sample reports in BOL for details.
> > > >
> > > > In the sample the image is inside a rectangle, which may
> > > > confuse you when trying to select it. In the properties pane,
> > > > in the drop-down list of property names select ProdPhoto.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > the report. I tried the same with crystal reports and it
> > > > > worked.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > If you mean external files then again yes it can, either
> > > > > > using a field containing the url/unc path or some other
> > > > > > direct path are expression to the path.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Chris McGuigan wrote:
> > > > > >
> > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > Also select the appropriate MIME type.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > >
> > > > > > > > Sapnil
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||I am using SP2
"Chris McGuigan" wrote:
> Hi Sapnil,
> I'm a bit stumped I'm afraid. What exactly are you getting?
> In terms of evaluation, I'm an ex-Crystal user who switched to RS last
> February and have had little need to revert back since.
> That's not to say that there are things Crystal doesn't do better than
> RS, but for my environment, RS has many more advantages. I'm playing
> with RS2005 now (due to be "launched" early November) and it's looking
> good with ReportBuilder filling many of the RS's shortcomings against
> Crystal. This is a bit off topic now but if you trawl this newsgroup
> you'll see plenty of worthwhile exchanges on the pro's and con's of
> various reporting tools.
> Obviously this image issue is a problem for you! Are you using SP1 or
> SP2?
> Chris
>
> Sapnil wrote:
> > I have tried all MIME types.
> > And you are right, its working with crystal reports.
> > Actually I am in the process of evaluating repoting tools.
> >
> > "Chris McGuigan" wrote:
> >
> > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > I've never actually used Blob fields. So I'm going by the book
> > > rather than experience! Have you tried all the different MIME types
> > > against your data? Are you 100% sure your fields contain bitmaps
> > > and not gifs or jpegs? I guess you are because you've had it
> > > working in Crystal, but it's worth a check!
> > >
> > > Regards
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > Chirs,
> > > > I have tried the sample product catalog sample report and it works
> > > > for me too. But If I am not wrong the images stored in the BLOB
> > > > fieds are of type GIF I tried the same thing with the Northwind
> > > > database, trying to display the employees on the report, but there
> > > > seems to be some problem.
> > > >
> > > > Sapnil
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Sapnil,
> > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > uses this feature and works. It shows an image for each stock
> > > > > item and the image is taken directly from the database. I
> > > > > suspect you've a setting wrong.
> > > > >
> > > > > I suggest you load and take a look at this sample report. Look
> > > > > up sample reports in BOL for details.
> > > > >
> > > > > In the sample the image is inside a rectangle, which may
> > > > > confuse you when trying to select it. In the properties pane,
> > > > > in the drop-down list of property names select ProdPhoto.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > > the report. I tried the same with crystal reports and it
> > > > > > worked.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > > If you mean external files then again yes it can, either
> > > > > > > using a field containing the url/unc path or some other
> > > > > > > direct path are expression to the path.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Chris McGuigan wrote:
> > > > > > >
> > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > > Also select the appropriate MIME type.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > >
> > > > > > > > > Sapnil
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||What exactly do you get in your image control, have you tried deploying
it? The VS Preview renderer is not the same as the RM renderer.
Maybe you could look at the code around the image control in the sample
report and that on your report for some clues.
Regards
Chris
Sapnil wrote:
> I am using SP2
>
> "Chris McGuigan" wrote:
> > Hi Sapnil,
> > I'm a bit stumped I'm afraid. What exactly are you getting?
> >
> > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > last February and have had little need to revert back since.
> > That's not to say that there are things Crystal doesn't do better
> > than RS, but for my environment, RS has many more advantages. I'm
> > playing with RS2005 now (due to be "launched" early November) and
> > it's looking good with ReportBuilder filling many of the RS's
> > shortcomings against Crystal. This is a bit off topic now but if
> > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > on the pro's and con's of various reporting tools.
> >
> > Obviously this image issue is a problem for you! Are you using SP1
> > or SP2?
> >
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I have tried all MIME types.
> > > And you are right, its working with crystal reports.
> > > Actually I am in the process of evaluating repoting tools.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > I've never actually used Blob fields. So I'm going by the book
> > > > rather than experience! Have you tried all the different MIME
> > > > types against your data? Are you 100% sure your fields contain
> > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > had it working in Crystal, but it's worth a check!
> > > >
> > > > Regards
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Chirs,
> > > > > I have tried the sample product catalog sample report and it
> > > > > works for me too. But If I am not wrong the images stored in
> > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > the Northwind database, trying to display the employees on
> > > > > the report, but there seems to be some problem.
> > > > >
> > > > > Sapnil
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Sapnil,
> > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > uses this feature and works. It shows an image for each
> > > > > > stock item and the image is taken directly from the
> > > > > > database. I suspect you've a setting wrong.
> > > > > >
> > > > > > I suggest you load and take a look at this sample report.
> > > > > > Look up sample reports in BOL for details.
> > > > > >
> > > > > > In the sample the image is inside a rectangle, which may
> > > > > > confuse you when trying to select it. In the properties
> > > > > > pane, in the drop-down list of property names select
> > > > > > ProdPhoto.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > it worked.
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > or some other direct path are expression to the path.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Chris McGuigan wrote:
> > > > > > > >
> > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > >
> > > > > > > > > > Sapnil
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||The images are not displayed on the report, instead I get X marks on the
report.
I checked the RDL for the reports and there is no difference
Pretty strange
"Chris McGuigan" wrote:
> What exactly do you get in your image control, have you tried deploying
> it? The VS Preview renderer is not the same as the RM renderer.
> Maybe you could look at the code around the image control in the sample
> report and that on your report for some clues.
> Regards
> Chris
>
> Sapnil wrote:
> > I am using SP2
> >
> >
> > "Chris McGuigan" wrote:
> >
> > > Hi Sapnil,
> > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > >
> > > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > > last February and have had little need to revert back since.
> > > That's not to say that there are things Crystal doesn't do better
> > > than RS, but for my environment, RS has many more advantages. I'm
> > > playing with RS2005 now (due to be "launched" early November) and
> > > it's looking good with ReportBuilder filling many of the RS's
> > > shortcomings against Crystal. This is a bit off topic now but if
> > > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > > on the pro's and con's of various reporting tools.
> > >
> > > Obviously this image issue is a problem for you! Are you using SP1
> > > or SP2?
> > >
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I have tried all MIME types.
> > > > And you are right, its working with crystal reports.
> > > > Actually I am in the process of evaluating repoting tools.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > I've never actually used Blob fields. So I'm going by the book
> > > > > rather than experience! Have you tried all the different MIME
> > > > > types against your data? Are you 100% sure your fields contain
> > > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > > had it working in Crystal, but it's worth a check!
> > > > >
> > > > > Regards
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Chirs,
> > > > > > I have tried the sample product catalog sample report and it
> > > > > > works for me too. But If I am not wrong the images stored in
> > > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > > the Northwind database, trying to display the employees on
> > > > > > the report, but there seems to be some problem.
> > > > > >
> > > > > > Sapnil
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Sapnil,
> > > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > > uses this feature and works. It shows an image for each
> > > > > > > stock item and the image is taken directly from the
> > > > > > > database. I suspect you've a setting wrong.
> > > > > > >
> > > > > > > I suggest you load and take a look at this sample report.
> > > > > > > Look up sample reports in BOL for details.
> > > > > > >
> > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > confuse you when trying to select it. In the properties
> > > > > > > pane, in the drop-down list of property names select
> > > > > > > ProdPhoto.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > > it worked.
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > > or some other direct path are expression to the path.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Chris McGuigan wrote:
> > > > > > > > >
> > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > > Sapnil wrote:
> > > > > > > > > >
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > > >
> > > > > > > > > > > Sapnil
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||The only thing that comes to mind is some minor difference in the way
the bitmap is stored in the DB compared to what Microsoft expects.
It may be worth raising a support incident with Microsoft if you have
an MSDN subscription. It would be a shame for you to decide not to use
RS because of this one glitch. In an enterpirise environment RS is far
better than Crystal, in my view, not to mention a whole lot cheaper if
you already use MS SQL Server.
Chris
Sapnil wrote:
> The images are not displayed on the report, instead I get X marks on
> the report.
> I checked the RDL for the reports and there is no difference
> Pretty strange
> "Chris McGuigan" wrote:
> > What exactly do you get in your image control, have you tried
> > deploying it? The VS Preview renderer is not the same as the RM
> > renderer.
> >
> > Maybe you could look at the code around the image control in the
> > sample report and that on your report for some clues.
> >
> > Regards
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I am using SP2
> > >
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Hi Sapnil,
> > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > >
> > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > RS last February and have had little need to revert back since.
> > > > That's not to say that there are things Crystal doesn't do
> > > > better than RS, but for my environment, RS has many more
> > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > early November) and it's looking good with ReportBuilder
> > > > filling many of the RS's shortcomings against Crystal. This is
> > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > various reporting tools.
> > > >
> > > > Obviously this image issue is a problem for you! Are you using
> > > > SP1 or SP2?
> > > >
> > > > Chris
> > > >
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I have tried all MIME types.
> > > > > And you are right, its working with crystal reports.
> > > > > Actually I am in the process of evaluating repoting tools.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > book rather than experience! Have you tried all the
> > > > > > different MIME types against your data? Are you 100% sure
> > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > you are because you've had it working in Crystal, but it's
> > > > > > worth a check!
> > > > > >
> > > > > > Regards
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Chirs,
> > > > > > > I have tried the sample product catalog sample report and
> > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > thing with the Northwind database, trying to display the
> > > > > > > employees on the report, but there seems to be some
> > > > > > > problem.
> > > > > > >
> > > > > > > Sapnil
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Sapnil,
> > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > >
> > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > >
> > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > ProdPhoto.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > crystal reports and it worked.
> > > > > > > > >
> > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > >
> > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > expression to the path.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > >
> > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Hi,
> > > > > > > > > > > >
> > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > files?
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||Hi Chris,
Thankyou very much for you comments
Sapnil
"Chris McGuigan" wrote:
> The only thing that comes to mind is some minor difference in the way
> the bitmap is stored in the DB compared to what Microsoft expects.
> It may be worth raising a support incident with Microsoft if you have
> an MSDN subscription. It would be a shame for you to decide not to use
> RS because of this one glitch. In an enterpirise environment RS is far
> better than Crystal, in my view, not to mention a whole lot cheaper if
> you already use MS SQL Server.
> Chris
>
> Sapnil wrote:
> > The images are not displayed on the report, instead I get X marks on
> > the report.
> > I checked the RDL for the reports and there is no difference
> > Pretty strange
> >
> > "Chris McGuigan" wrote:
> >
> > > What exactly do you get in your image control, have you tried
> > > deploying it? The VS Preview renderer is not the same as the RM
> > > renderer.
> > >
> > > Maybe you could look at the code around the image control in the
> > > sample report and that on your report for some clues.
> > >
> > > Regards
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I am using SP2
> > > >
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Hi Sapnil,
> > > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > > >
> > > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > > RS last February and have had little need to revert back since.
> > > > > That's not to say that there are things Crystal doesn't do
> > > > > better than RS, but for my environment, RS has many more
> > > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > > early November) and it's looking good with ReportBuilder
> > > > > filling many of the RS's shortcomings against Crystal. This is
> > > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > > various reporting tools.
> > > > >
> > > > > Obviously this image issue is a problem for you! Are you using
> > > > > SP1 or SP2?
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I have tried all MIME types.
> > > > > > And you are right, its working with crystal reports.
> > > > > > Actually I am in the process of evaluating repoting tools.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > > book rather than experience! Have you tried all the
> > > > > > > different MIME types against your data? Are you 100% sure
> > > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > > you are because you've had it working in Crystal, but it's
> > > > > > > worth a check!
> > > > > > >
> > > > > > > Regards
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Chirs,
> > > > > > > > I have tried the sample product catalog sample report and
> > > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > > thing with the Northwind database, trying to display the
> > > > > > > > employees on the report, but there seems to be some
> > > > > > > > problem.
> > > > > > > >
> > > > > > > > Sapnil
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Sapnil,
> > > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > > >
> > > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > > >
> > > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > > ProdPhoto.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > > crystal reports and it worked.
> > > > > > > > > >
> > > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > > >
> > > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > > expression to the path.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > > >
> > > > > > > > > > > > Chris
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > > Hi,
> > > > > > > > > > > > >
> > > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > > files?
> > > > > > > > > > > > >
> > > > > > > > > > > > > Sapnil
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>

Blocking seen when two filegroups are backed up in parallel

When I backup two filegroups in parallel I see one backup
blocking the other.
eg two filegroups consisting of one data file each. Both
data files live on the f drive. One filegroup backup
writes to the h drive, the other to the i drive. Running
the backups in parallel results in one backup blocking the
other.
I suspect this is because both my data files live on the f
drive. Can anyone confirm this as the problem ?
Thanks.It's probably more to do with the fact they share the same log file and
backups need access to the logs and will put certain locks on them that
prevents some things from happening in parallel like that.
--
Andrew J. Kelly
SQL Server MVP
"anon" <anonymous@.discussions.microsoft.com> wrote in message
news:0db801c39f02$40fa1cb0$a401280a@.phx.gbl...
> When I backup two filegroups in parallel I see one backup
> blocking the other.
> eg two filegroups consisting of one data file each. Both
> data files live on the f drive. One filegroup backup
> writes to the h drive, the other to the i drive. Running
> the backups in parallel results in one backup blocking the
> other.
> I suspect this is because both my data files live on the f
> drive. Can anyone confirm this as the problem ?
> Thanks.
>|||Andrew - thanks for the reply. I think you're right.
Despite what SQL 2000 Books Online says under the
section 'Optimizing Database, Differential Database, and
File Backup Performance', I never see parallel backups.
I've now placed my two data files on different logical
drives and create the backups on two other logical drives
and still I get one backup blocked by the other.
Seems like this particular performance benefit of using
file groups doesn't really exist :( Again, nice if someone
could confirm this.
>--Original Message--
>It's probably more to do with the fact they share the
same log file and
>backups need access to the logs and will put certain
locks on them that
>prevents some things from happening in parallel like that.
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"anon" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0db801c39f02$40fa1cb0$a401280a@.phx.gbl...
>> When I backup two filegroups in parallel I see one
backup
>> blocking the other.
>> eg two filegroups consisting of one data file each. Both
>> data files live on the f drive. One filegroup backup
>> writes to the h drive, the other to the i drive. Running
>> the backups in parallel results in one backup blocking
the
>> other.
>> I suspect this is because both my data files live on
the f
>> drive. Can anyone confirm this as the problem ?
>> Thanks.
>
>.
>|||It can do "Parallel" backups as long as they aren't to the same database.
They are referring to backing up multiple db's at the same time.
--
Andrew J. Kelly
SQL Server MVP
"anon" <anonymous@.discussions.microsoft.com> wrote in message
news:08e001c39fa9$ea087ca0$a501280a@.phx.gbl...
> Andrew - thanks for the reply. I think you're right.
> Despite what SQL 2000 Books Online says under the
> section 'Optimizing Database, Differential Database, and
> File Backup Performance', I never see parallel backups.
> I've now placed my two data files on different logical
> drives and create the backups on two other logical drives
> and still I get one backup blocked by the other.
> Seems like this particular performance benefit of using
> file groups doesn't really exist :( Again, nice if someone
> could confirm this.
> >--Original Message--
> >It's probably more to do with the fact they share the
> same log file and
> >backups need access to the logs and will put certain
> locks on them that
> >prevents some things from happening in parallel like that.
> >
> >--
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"anon" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:0db801c39f02$40fa1cb0$a401280a@.phx.gbl...
> >> When I backup two filegroups in parallel I see one
> backup
> >> blocking the other.
> >>
> >> eg two filegroups consisting of one data file each. Both
> >> data files live on the f drive. One filegroup backup
> >> writes to the h drive, the other to the i drive. Running
> >> the backups in parallel results in one backup blocking
> the
> >> other.
> >>
> >> I suspect this is because both my data files live on
> the f
> >> drive. Can anyone confirm this as the problem ?
> >>
> >> Thanks.
> >>
> >
> >
> >.
> >

block comment??

Is there a block comment character that I can use in my SQL script files to
comment large sections of SQL code? Something like /* ... */.
Thanks.
-b"Barry" <Barry@.discussions.microsoft.com> wrote in message
news:452FF1A6-BE3E-4292-9A04-D8AF07908794@.microsoft.com...
> Is there a block comment character that I can use in my SQL script files
> to
> comment large sections of SQL code? Something like /* ... */.
> Thanks.
> -b
This isn't a joke, is it?
From Books OnLine:
/*...*/ (Comment)
Indicates user-provided text. The text between the /* and */ commenting
characters is not evaluated by the server.|||You have is the right commenting characters /*...*/ there for multi-line
block commenting.
( Also in QA, you can select a large chunk of code & press Ctrl+Shft+C to
comment it & Ctrl+Shift+R to remove it. )
Anith|||That's what I thought it meant too, but when I created a SQL script using
this to comment out a section of code that is not yet fully debugged and the
n
ran the script file, I got several errors from code inside the block comment
.
The specific commands were dealing with foreign key constraints, but they
were within the block comment.
Is that any problem with nesting line comments ( '--') inside a block
comment?
-b
"Raymond D'Anjou" wrote:

> "Barry" <Barry@.discussions.microsoft.com> wrote in message
> news:452FF1A6-BE3E-4292-9A04-D8AF07908794@.microsoft.com...
> This isn't a joke, is it?
> From Books OnLine:
> /*...*/ (Comment)
> Indicates user-provided text. The text between the /* and */ commenting
> characters is not evaluated by the server.
>
>|||I can't see what would cause the problems.
Did you highlight some code before running the script?
Mixing block and line comments does not generate an error (that I know of).
Go alone on a line throws an error:
/*comments
GO
comments*/
Trying to nest block comments doesn't work either:
/*comment
/*comment2*/
comment*/
"Barry" <Barry@.discussions.microsoft.com> wrote in message
news:045BF8F8-3EDE-44C9-8F69-AEBAB5FB6936@.microsoft.com...
> That's what I thought it meant too, but when I created a SQL script using
> this to comment out a section of code that is not yet fully debugged and
> then
> ran the script file, I got several errors from code inside the block
> comment.
> The specific commands were dealing with foreign key constraints, but they
> were within the block comment.
> Is that any problem with nesting line comments ( '--') inside a block
> comment?
> -b
> "Raymond D'Anjou" wrote:
>|||Barry
If you just commented out a whole block of code, you maybe have a GO
somewhere in there. This can cause problems.
The following is from Inside SQL Server 2000:
---
GO isn't an SQL command or keyword. It's the end-of-batch signal understood
only by certain client tools. The client interprets it to mean that
everything since the last GO should be sent to the server for execution. SQL
Server never sees the GO command and has no idea what it means. With a
custom application, a batch is executed with a single SQLExecute from ODBC
(or dbsqlexec from DB-Library).
If you include the GO command in the query window, SQL Query Analyzer breaks
up your statement into the indicated batches behind the scenes. Each batch
(as marked by the GO command) is sent individually to SQL Server.
A collection of batches that are frequently executed together is sometimes
called a script. Most of the client tools provide a mechanism for loading a
script that you've saved to a text file and for executing it. In SQL Query
Analyzer, you can use the File/Open command to load a script. From the
command-line OSQL or ISQL programs, we can specify the /i flag followed by a
filename to indicate that the SQL Server batches to execute should come from
the specified file. Alternatively, if we're using OSQL or ISQL
interactively, we can read in a file containing one or more SQL statement by
typing :r followed by the filename. (See SQL Server Books Online for details
about using OSQL and ISQL.)
The fact that the client tool and not SQL Server processes GO can lead to
some unexpected behavior. Suppose you have a script containing several
batches. During testing, you want to comment out a couple of the batches to
ignore them for the time being. Your commented script might look something
like this:
SELECT * FROM authors
/*
GO
SELECT * FROM sales
GO
SELECT * FROM publishers
GO
*/
SELECT * FROM titles
GO
The intention here was to comment out the SELECT from the sales and
publishers tables and to run the SELECT from authors and titles as a single
batch. However, if you run this script from SQL Query Analyzer, you'll get
exactly the opposite behavior! That is, you'll see the data from the sales
and publishers tables but not from authors or titles. If you look at this
script from the perspective of the client tool, the behavior makes sense.
The tool doesn't try to interpret any of your SQL statements; it just breaks
the statements into batches to be sent to SQL Server. A batch is marked by a
GO command at the beginning of a line.
So the above script contains four batches. The first batch (everything
before the first GO) is:
SELECT * FROM authors
/*
SQL Server generates an error message because there's an open comment with
no corresponding close comment.
The second and third batches are:
SELECT * FROM sales
and
SELECT * FROM publishers
Both of these batches are perfectly legal, and SQL Server can process them
and return results.
The fourth batch is:
*/
SELECT * FROM titles
SQL Server also generates an error for this last one because it has a close
comment without an open comment marker, and no data is returned.
If you want to comment out statements within a script that can contain the
end-of-batch GO command, you should use the alternative comment marker-the
double dash-in front of every GO. Alternatively, you can just use the double
dash in front of every line you want to comment out. Your script would then
look like this:
SELECT * FROM authors
-- GO
-- SELECT * FROM sales
-- GO
-- SELECT * FROM publishers
-- GO
SELECT * FROM titles
GO
SQL Query Analyzer makes it easy to comment out a group of lines as in the
code above. You can highlight all the lines to be commented out, and from
the Edit menu, choose Advanced/Comment Out. The keystroke combination to
perform the same action is Ctrl-Shift-C. With this revised script, the
client tool won't recognize the GO as the end-of-batch marker because it's
not the first thing on a line. The client will consider this script to be
one single batch and send it to SQL Server as such.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Barry" <Barry@.discussions.microsoft.com> wrote in message
news:045BF8F8-3EDE-44C9-8F69-AEBAB5FB6936@.microsoft.com...
> That's what I thought it meant too, but when I created a SQL script using
> this to comment out a section of code that is not yet fully debugged and
> then
> ran the script file, I got several errors from code inside the block
> comment.
> The specific commands were dealing with foreign key constraints, but they
> were within the block comment.
> Is that any problem with nesting line comments ( '--') inside a block
> comment?
> -b
> "Raymond D'Anjou" wrote:
>
>|||I've verified that there are no improperly commented GO statements. When I
rerun the script the error comes after several other similar calls from
inside the comment block (1034 lines into the block of 1137 lines). Is it
possible that these comment blocks are too long?
"Kalen Delaney" wrote:

> Barry
> If you just commented out a whole block of code, you maybe have a GO
> somewhere in there. This can cause problems.
> The following is from Inside SQL Server 2000:
> ---
> GO isn't an SQL command or keyword. It's the end-of-batch signal understoo
d
> only by certain client tools. The client interprets it to mean that
> everything since the last GO should be sent to the server for execution. S
QL
> Server never sees the GO command and has no idea what it means. With a
> custom application, a batch is executed with a single SQLExecute from ODBC
> (or dbsqlexec from DB-Library).
> If you include the GO command in the query window, SQL Query Analyzer brea
ks
> up your statement into the indicated batches behind the scenes. Each batch
> (as marked by the GO command) is sent individually to SQL Server.
> A collection of batches that are frequently executed together is sometimes
> called a script. Most of the client tools provide a mechanism for loading
a
> script that you've saved to a text file and for executing it. In SQL Query
> Analyzer, you can use the File/Open command to load a script. From the
> command-line OSQL or ISQL programs, we can specify the /i flag followed by
a
> filename to indicate that the SQL Server batches to execute should come fr
om
> the specified file. Alternatively, if we're using OSQL or ISQL
> interactively, we can read in a file containing one or more SQL statement
by
> typing :r followed by the filename. (See SQL Server Books Online for detai
ls
> about using OSQL and ISQL.)
> The fact that the client tool and not SQL Server processes GO can lead to
> some unexpected behavior. Suppose you have a script containing several
> batches. During testing, you want to comment out a couple of the batches t
o
> ignore them for the time being. Your commented script might look something
> like this:
> SELECT * FROM authors
> /*
> GO
> SELECT * FROM sales
> GO
> SELECT * FROM publishers
> GO
> */
> SELECT * FROM titles
> GO
> The intention here was to comment out the SELECT from the sales and
> publishers tables and to run the SELECT from authors and titles as a singl
e
> batch. However, if you run this script from SQL Query Analyzer, you'll get
> exactly the opposite behavior! That is, you'll see the data from the sales
> and publishers tables but not from authors or titles. If you look at this
> script from the perspective of the client tool, the behavior makes sense.
> The tool doesn't try to interpret any of your SQL statements; it just brea
ks
> the statements into batches to be sent to SQL Server. A batch is marked by
a
> GO command at the beginning of a line.
> So the above script contains four batches. The first batch (everything
> before the first GO) is:
> SELECT * FROM authors
> /*
> SQL Server generates an error message because there's an open comment with
> no corresponding close comment.
> The second and third batches are:
> SELECT * FROM sales
> and
> SELECT * FROM publishers
> Both of these batches are perfectly legal, and SQL Server can process them
> and return results.
> The fourth batch is:
> */
> SELECT * FROM titles
> SQL Server also generates an error for this last one because it has a clos
e
> comment without an open comment marker, and no data is returned.
> If you want to comment out statements within a script that can contain the
> end-of-batch GO command, you should use the alternative comment marker-the
> double dash-in front of every GO. Alternatively, you can just use the doub
le
> dash in front of every line you want to comment out. Your script would the
n
> look like this:
> SELECT * FROM authors
> -- GO
> -- SELECT * FROM sales
> -- GO
> -- SELECT * FROM publishers
> -- GO
> SELECT * FROM titles
> GO
> SQL Query Analyzer makes it easy to comment out a group of lines as in the
> code above. You can highlight all the lines to be commented out, and from
> the Edit menu, choose Advanced/Comment Out. The keystroke combination to
> perform the same action is Ctrl-Shift-C. With this revised script, the
> client tool won't recognize the GO as the end-of-batch marker because it's
> not the first thing on a line. The client will consider this script to be
> one single batch and send it to SQL Server as such.
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Barry" <Barry@.discussions.microsoft.com> wrote in message
> news:045BF8F8-3EDE-44C9-8F69-AEBAB5FB6936@.microsoft.com...
>
>|||OK - Here is what I've narrowed it down to.
If I comment out (using block comments) anything in the script except
another '*' character, it seems to work. However when the commented section
includes a '*' it causes the code to uncomment.
For example the following generated an error
/*
-- if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_PolicySectionMap_policyFileID]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
*/
but changing the '*' to 'id' did not.
I decided to use QA to comment the block with line comments instead.
-b
"Barry" wrote:
> I've verified that there are no improperly commented GO statements. When
I
> rerun the script the error comes after several other similar calls from
> inside the comment block (1034 lines into the block of 1137 lines). Is it
> possible that these comment blocks are too long?
> "Kalen Delaney" wrote:
>|||Barry
This seems very strange.
This batch works for me:
USE pubs
select * from authors
/*
select * from titles
*/
select * from publishers
What exact version are you using? Are you getting the error using QA?
Thanks
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Barry" <Barry@.discussions.microsoft.com> wrote in message
news:846D3E3A-34D8-47EF-A22D-CAC114D7CCB8@.microsoft.com...
> OK - Here is what I've narrowed it down to.
> If I comment out (using block comments) anything in the script except
> another '*' character, it seems to work. However when the commented
> section
> includes a '*' it causes the code to uncomment.
> For example the following generated an error
> /*
> -- if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[FK_PolicySectionMap_policyFileID]') and
> OBJECTPROPERTY(id,
> N'IsForeignKey') = 1)
> */
> but changing the '*' to 'id' did not.
> I decided to use QA to comment the block with line comments instead.
> -b
> "Barry" wrote:
>
>|||Did you copy this SQL into notepad (or another 3rd party editor) and then
paste back into Enterprise Manager or Query Analyzer? There is a very rare
(but insideous) bug at least in SQL Server 2000 where a line ending in a
CRTL byte but no LF byte (or perhaps vice versa) will look normal when
viewed in QA or EM, but when executed, the SQL interpreter will think there
is no new line.
For example:
Here is what it looks like when viewed in Enterprise Manager:
-- Here is a comment
print 'Hello World'
Here is what gets executed:
-- Here is a comment print 'Hello World'
"Barry" <Barry@.discussions.microsoft.com> wrote in message
news:145BDC63-89E3-4979-9377-29199B3A10EB@.microsoft.com...
> I've verified that there are no improperly commented GO statements. When
> I
> rerun the script the error comes after several other similar calls from
> inside the comment block (1034 lines into the block of 1137 lines). Is it
> possible that these comment blocks are too long?
> "Kalen Delaney" wrote:
>

BLOBS vs. regular files

Over the weekend I was told that my SQL Server was going to start doubling as
a file server. I guess now the other option is to store files as BLOBS. I
have no experience with either scenario. Can anyone give me the procs/ cons
of doing it either way?
--
TIA,
ChrisRChris,
If they meant a file server for Word documents, executables, and so forth,
then the SQL Server will not be any help to you. You will have a server
running the SQL Server process and also hosting file services. This will
affect how you configure resources on the server since it will no longer be
dedicated.
If you are going to be getting only files associated with a database, then
there are plenty of discussions and opinions.
Try Googling 'blob file sql versus' and read the several hundred comments.
:-)
Here is a link to the thinking behind what the TerraServer guys did.
www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx
RLF
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:8BCD21FE-97EC-4B1E-84FA-57A40844A4A1@.microsoft.com...
> Over the weekend I was told that my SQL Server was going to start doubling
> as
> a file server. I guess now the other option is to store files as BLOBS. I
> have no experience with either scenario. Can anyone give me the procs/
> cons
> of doing it either way?
> --
> TIA,
> ChrisR|||The pro for BLOBs is very simple, the "files" are part of the database, are
kept in sync transactionally, participate in the backups, and can be
processed by SQL. In other words, they have all the traditional benefits of
a database system.
The cons are more extensive. They don't appear in the filesystem namespace.
Before they can be processed by a regular program they have to be copied
into a temporary file, they aren't structured as efficiently as files for
bulk copying (and can't be directly copied by kernel mode services). In
other words, performance is generally poor by comparison.
Now as a database guy I'd be inclined to store just about everything in the
database, get the management/integrity benefits, and give up some
performance. But realistically
usage would dictate which model I would use. The more the object will need
to be processed by an external file-based application the more likely I'd be
to store it in the file system. The more important it was to keep it
tightly bound to the data in the database system the more likely I'd be to
store it in a blob. For example, say you want to store an employee's photo
with their personnel data. I'd store that in a Blob in the database.
But if I were creating a library of photographs that were going to be
primarily accessed by Photoshop, and the purpose of the database was to make
searching etc easier, then I'd probably keep the photographs in the
filesystem with pointers from the database. Of course, then I'd have to
create more complex backup/resore procedures for my shop.
--
Hal Berenson, President
PredictableIT, LLC
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:8BCD21FE-97EC-4B1E-84FA-57A40844A4A1@.microsoft.com...
> Over the weekend I was told that my SQL Server was going to start doubling
> as
> a file server. I guess now the other option is to store files as BLOBS. I
> have no experience with either scenario. Can anyone give me the procs/
> cons
> of doing it either way?
> --
> TIA,
> ChrisR

BLOBS vs. regular files

Over the weekend I was told that my SQL Server was going to start doubling as
a file server. I guess now the other option is to store files as BLOBS. I
have no experience with either scenario. Can anyone give me the procs/ cons
of doing it either way?
TIA,
ChrisR
Chris,
If they meant a file server for Word documents, executables, and so forth,
then the SQL Server will not be any help to you. You will have a server
running the SQL Server process and also hosting file services. This will
affect how you configure resources on the server since it will no longer be
dedicated.
If you are going to be getting only files associated with a database, then
there are plenty of discussions and opinions.
Try Googling 'blob file sql versus' and read the several hundred comments.
:-)
Here is a link to the thinking behind what the TerraServer guys did.
http://www.microsoft.com/technet/pro...rt3/c1161.mspx
RLF
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:8BCD21FE-97EC-4B1E-84FA-57A40844A4A1@.microsoft.com...
> Over the weekend I was told that my SQL Server was going to start doubling
> as
> a file server. I guess now the other option is to store files as BLOBS. I
> have no experience with either scenario. Can anyone give me the procs/
> cons
> of doing it either way?
> --
> TIA,
> ChrisR
|||The pro for BLOBs is very simple, the "files" are part of the database, are
kept in sync transactionally, participate in the backups, and can be
processed by SQL. In other words, they have all the traditional benefits of
a database system.
The cons are more extensive. They don't appear in the filesystem namespace.
Before they can be processed by a regular program they have to be copied
into a temporary file, they aren't structured as efficiently as files for
bulk copying (and can't be directly copied by kernel mode services). In
other words, performance is generally poor by comparison.
Now as a database guy I'd be inclined to store just about everything in the
database, get the management/integrity benefits, and give up some
performance. But realistically
usage would dictate which model I would use. The more the object will need
to be processed by an external file-based application the more likely I'd be
to store it in the file system. The more important it was to keep it
tightly bound to the data in the database system the more likely I'd be to
store it in a blob. For example, say you want to store an employee's photo
with their personnel data. I'd store that in a Blob in the database.
But if I were creating a library of photographs that were going to be
primarily accessed by Photoshop, and the purpose of the database was to make
searching etc easier, then I'd probably keep the photographs in the
filesystem with pointers from the database. Of course, then I'd have to
create more complex backup/resore procedures for my shop.
Hal Berenson, President
PredictableIT, LLC
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:8BCD21FE-97EC-4B1E-84FA-57A40844A4A1@.microsoft.com...
> Over the weekend I was told that my SQL Server was going to start doubling
> as
> a file server. I guess now the other option is to store files as BLOBS. I
> have no experience with either scenario. Can anyone give me the procs/
> cons
> of doing it either way?
> --
> TIA,
> ChrisR

BLOBS vs. regular files

Over the weekend I was told that my SQL Server was going to start doubling a
s
a file server. I guess now the other option is to store files as BLOBS. I
have no experience with either scenario. Can anyone give me the procs/ cons
of doing it either way?
--
TIA,
ChrisRChris,
If they meant a file server for Word documents, executables, and so forth,
then the SQL Server will not be any help to you. You will have a server
running the SQL Server process and also hosting file services. This will
affect how you configure resources on the server since it will no longer be
dedicated.
If you are going to be getting only files associated with a database, then
there are plenty of discussions and opinions.
Try Googling 'blob file sql versus' and read the several hundred comments.
:-)
Here is a link to the thinking behind what the TerraServer guys did.
www.microsoft.com/technet/prodtechn...art3/c1161.mspx
RLF
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:8BCD21FE-97EC-4B1E-84FA-57A40844A4A1@.microsoft.com...
> Over the weekend I was told that my SQL Server was going to start doubling
> as
> a file server. I guess now the other option is to store files as BLOBS. I
> have no experience with either scenario. Can anyone give me the procs/
> cons
> of doing it either way?
> --
> TIA,
> ChrisR|||The pro for BLOBs is very simple, the "files" are part of the database, are
kept in sync transactionally, participate in the backups, and can be
processed by SQL. In other words, they have all the traditional benefits of
a database system.
The cons are more extensive. They don't appear in the filesystem namespace.
Before they can be processed by a regular program they have to be copied
into a temporary file, they aren't structured as efficiently as files for
bulk copying (and can't be directly copied by kernel mode services). In
other words, performance is generally poor by comparison.
Now as a database guy I'd be inclined to store just about everything in the
database, get the management/integrity benefits, and give up some
performance. But realistically
usage would dictate which model I would use. The more the object will need
to be processed by an external file-based application the more likely I'd be
to store it in the file system. The more important it was to keep it
tightly bound to the data in the database system the more likely I'd be to
store it in a blob. For example, say you want to store an employee's photo
with their personnel data. I'd store that in a Blob in the database.
But if I were creating a library of photographs that were going to be
primarily accessed by Photoshop, and the purpose of the database was to make
searching etc easier, then I'd probably keep the photographs in the
filesystem with pointers from the database. Of course, then I'd have to
create more complex backup/resore procedures for my shop.
--
Hal Berenson, President
PredictableIT, LLC
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:8BCD21FE-97EC-4B1E-84FA-57A40844A4A1@.microsoft.com...
> Over the weekend I was told that my SQL Server was going to start doubling
> as
> a file server. I guess now the other option is to store files as BLOBS. I
> have no experience with either scenario. Can anyone give me the procs/
> cons
> of doing it either way?
> --
> TIA,
> ChrisR

Blobs in SQL Server

We have a blob in one table that is storing pdf files. I need to
write a select query that will grab that column and write those *.pdf
files out to a location on my hard drive. Does anyone know how that
can be done? All suggestions would be greatly appreciated...Connie (csawyer@.rwbaird.com) writes:

Quote:

Originally Posted by

We have a blob in one table that is storing pdf files. I need to
write a select query that will grab that column and write those *.pdf
files out to a location on my hard drive. Does anyone know how that
can be done? All suggestions would be greatly appreciated...

I have a very quick sketch for this on
http://www.sommarskog.se/blobload.txt.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 15, 4:26 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

Connie (csaw...@.rwbaird.com) writes:

Quote:

Originally Posted by

We have a blob in one table that is storing pdf files. I need to
write a select query that will grab that column and write those *.pdf
files out to a location on my hard drive. Does anyone know how that
can be done? All suggestions would be greatly appreciated...

>
I have a very quick sketch for this onhttp://www.sommarskog.se/blobload.txt.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Here is some good information that I found in my search to complete
the above task, I am posting as this may help others working with
blobs:
In this article I want to show, how you can copy a single text or
image value into or out of SQL Server with textcopy.exe utility. You
can find this utility in the directory containing the standard SQL
Server EXE files (C:\Mssql\Binn by default for SQL Server 6.5 and C:
\Mssql7\Binn by default for SQL Server 7.0).

The Textcopy utility is not described in SQL Server Books Online, but
you can get its description by typing textcopy /? from the command
prompt. This is the description:

Copies a single text or image value into or out of SQL Server. The
value
is a specified text or image 'column' of a single row (specified by
the
"where clause") of the specified 'table'.

If the direction is IN (/I) then the data from the specified 'file' is
copied into SQL Server, replacing the existing text or image value. If
the
direction is OUT (/O) then the text or image value is copied from
SQL Server into the specified 'file', replacing any existing file.

TEXTCOPY [/S [sqlserver]] [/U [login]] [/P [password]]
[/D [database]] [/T table] [/C column] [/W"where clause"]
[/F file] [{/I | /O}] [/K chunksize] [/Z] [/?]

/S sqlserver The SQL Server to connect to. If 'sqlserver' is
not
specified, the local SQL Server is used.
/U login The login to connect with. If 'login' is not
specified,
a trusted connection will be used.
/P password The password for 'login'. If 'password' is not
specified, a NULL password will be used.
/D database The database that contains the table with the
text or
image data. If 'database' is not specified, the
default
database of 'login' is used.
/T table The table that contains the text or image value.
/C column The text or image column of 'table'.
/W "where clause" A complete where clause (including the WHERE
keyword)
that specifies a single row of 'table'.
/F file The file name.
/I Copy text or image value into SQL Server from
'file'.
/O Copy text or image value out of SQL Server into
'file'.
/K chunksize Size of the data transfer buffer in bytes.
Minimum
value is 1024 bytes, default value is 4096 bytes.
/Z Display debug information while running.
/? Display this usage information and exit.

You will be prompted for any required options you did not specify.

You can use the following stored procedure to simplify the using of
textcopy utility:

CREATE PROCEDURE sp_textcopy (
@.srvname varchar (30),
@.login varchar (30),
@.password varchar (30),
@.dbname varchar (30),
@.tbname varchar (30),
@.colname varchar (30),
@.filename varchar (30),
@.whereclause varchar (40),
@.direction char(1))
AS
DECLARE @.exec_str varchar (255)
SELECT @.exec_str =
'textcopy /S ' + @.srvname +
' /U ' + @.login +
' /P ' + @.password +
' /D ' + @.dbname +
' /T ' + @.tbname +
' /C ' + @.colname +
' /W "' + @.whereclause +
'" /F ' + @.filename +
' /' + @.direction
EXEC master..xp_cmdshell @.exec_str

This is the example to copy image into SQL Server database pubs, table
pub_info, column name logo from picture.bmp file where pub_id='0736':

sp_textcopy @.srvname = 'ServerName',
@.login = 'Login',
@.password = 'Password',
@.dbname = 'pubs',
@.tbname = 'pub_info',
@.colname = 'logo',
@.filename = 'c:\picture.bmp',
@.whereclause = " WHERE pub_id='0736' ",
@.direction = 'I'

BLOB

Hi all!
I want to save some .exe files in a database, but I dont get this BLOB thing

How do I declare a BLOB in the database table and as a variable in a stored
procedure?
Regards
MarreBLOB (Binary Large OBject) is a general term. You will find no data type in
SQL that is a blob per say. Depending on the version of SQL, you should be
using an "image" field (2000) or varbinary(MAX) in SQL 2005.
-Andrew
"Marre" <news@.supremelink.se> wrote in message
news:uPTPLqS4FHA.1864@.TK2MSFTNGP12.phx.gbl...
> Hi all!
> I want to save some .exe files in a database, but I dont get this BLOB
> thing
> How do I declare a BLOB in the database table and as a variable in a
> stored procedure?
>
> Regards
> Marre
>|||Hi Andrew!
Thanx for youre answer! As I understand it, i can use binary and varbinary
for files up to 8kb and if I want to work with larger files, I should use
Image.
Does this sound right to you?
Regards
Marre
"Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
news:ugA$rmV4FHA.1276@.TK2MSFTNGP09.phx.gbl...
> BLOB (Binary Large OBject) is a general term. You will find no data type
> in SQL that is a blob per say. Depending on the version of SQL, you should
> be using an "image" field (2000) or varbinary(MAX) in SQL 2005.
> -Andrew
> "Marre" <news@.supremelink.se> wrote in message
> news:uPTPLqS4FHA.1864@.TK2MSFTNGP12.phx.gbl...
>|||Yes.
Image and VARCHAR(MAX) / VARBINARY(MAX) have a performace hit. Store it in a
varbinary(8000) if you can.
-A
"Marre" <news@.supremelink.se> wrote in message
news:%23awky%23f4FHA.3276@.TK2MSFTNGP10.phx.gbl...
> Hi Andrew!
> Thanx for youre answer! As I understand it, i can use binary and varbinary
> for files up to 8kb and if I want to work with larger files, I should use
> Image.
> Does this sound right to you?
> Regards
> Marre
> "Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
> news:ugA$rmV4FHA.1276@.TK2MSFTNGP09.phx.gbl...
>|||Thank you for helping me out here!
/Marre
"Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
news:%23zaMkhn4FHA.472@.TK2MSFTNGP15.phx.gbl...
> Yes.
> Image and VARCHAR(MAX) / VARBINARY(MAX) have a performace hit. Store it in
> a varbinary(8000) if you can.
> -A
> "Marre" <news@.supremelink.se> wrote in message
> news:%23awky%23f4FHA.3276@.TK2MSFTNGP10.phx.gbl...
>|||Can you give more info on the performance hit?
Thanks.
"Andrew Robinson" wrote:

> Yes.
> Image and VARCHAR(MAX) / VARBINARY(MAX) have a performace hit. Store it in
a
> varbinary(8000) if you can.
> -A
> "Marre" <news@.supremelink.se> wrote in message
> news:%23awky%23f4FHA.3276@.TK2MSFTNGP10.phx.gbl...
>
>|||"yluo" <yluo@.plexus-group.net> wrote in message
news:0818E574-53A7-4936-9C36-CA8BC3F2B957@.microsoft.com...[vbcol=seagreen]
> Can you give more info on the performance hit?
> Thanks.
>
> "Andrew Robinson" wrote:
>
A varbinary(8000) column will live on the data page itself as part of the
row.
VARCHAR(MAX) and VARBINARY(MAX) will use BLOB objects. In the row itself,
a 16-byte pointer will now point at separate data pages which store the BLOB
object.
That = more reads, possibly more unused space etc.
Rick Sawtell
MCT, MCSD, MCDBA