images

can someone please point me in the direction to storing and retrieving
images in sql server 2000
Mark wrote:
> can someone please point me in the direction to storing and retrieving
> images in sql server 2000
The language is important here. For an ADO example, see:
http://support.microsoft.com/default...;en-us;Q258038
From .Net:
http://msdn.microsoft.com/library/de...ql server.asp
David Gugick
Quest Software
www.imceda.com
www.quest.com

images

can someone please point me in the direction to storing and retrieving
images in sql server 2000Mark wrote:
> can someone please point me in the direction to storing and retrieving
> images in sql server 2000
The language is important here. For an ADO example, see:
http://support.microsoft.com/defaul...b;en-us;Q258038
From .Net:
http://msdn.microsoft.com/library/d...tosqlserver.asp
David Gugick
Quest Software
www.imceda.com
www.quest.com

images

can someone please point me in the direction to storing and retrieving
images in sql server 2000Mark wrote:
> can someone please point me in the direction to storing and retrieving
> images in sql server 2000
The language is important here. For an ADO example, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q258038
From .Net:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconservingresourceswhenwritingblobvaluestosqlserver.asp
David Gugick
Quest Software
www.imceda.com
www.quest.com

Image data type Size

I need to store images in MS SQL. I have the upload procedures and stuff but I'm missing the point about the image data type size.

It is supposed to be able to store up to 2Gb!!! but when I declare the data field image I can't specify the max size for the field and by default is 16 !!

16 bytes!! what can I do with that?
How can I insert a file?

Please helpThe pointer to the data is the only thing stored in this database row. The data is stored elsewhere and can be up to 2G. You don't get to specify the size.

Bill|||Thanks for the reply!

But that leads me to this question: How can I write the Insert Statement for the image field?

create table ImgTest (
imgID Int,
imgFName varchar(30),
imgFType varchar(30),
imgFile image
)

All I got so far is a procedure in vb net that tryes to insert a byte array asigned to parameter value:

Insert Into ImgTest Values (1, 'file.jpg', 'image file', @.bytearray)

That's where I'm having trouble because it returns the error: "Data will be truncated" or something like that. I guess it's because it tryes to store the file in the 16bytes that are reserved for the pointer...

Oh.. I'm so lost..

Thank you!sql

Image data type Size

I need to store images in MS SQL. I have the upload procedures and stuff but I'm missing the point about the image data type size.

It is supposed to be able to store up to 2Gb!!! but when I declare the data field image I can't specify the max size for the field and by default is 16 !!

16 bytes!! what can I do with that?
How can I insert a file?

Please helpThe pointer to the data is the only thing stored in this database row. The data is stored elsewhere and can be up to 2G. You don't get to specify the size.

Bill|||Thanks for the reply!

But that leads me to this question: How can I write the Insert Statement for the image field?

create table ImgTest (
imgID Int,
imgFName varchar(30),
imgFType varchar(30),
imgFile image
)

All I got so far is a procedure in vb net that tryes to insert a byte array asigned to parameter value:

Insert Into ImgTest Values (1, 'file.jpg', 'image file', @.bytearray)

That's where I'm having trouble because it returns the error: "Data will be truncated" or something like that. I guess it's because it tryes to store the file in the 16bytes that are reserved for the pointer...

Oh.. I'm so lost..

Thank you!sql

Image Data Type

Hello,
Does any one has any document or link about pros and cons of using Image
data type to store images? Specially performance point of view.
Thanks,
Mukesh
Well, it depends. A quick search on the web reveals this article:
http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
I hope this will get you started.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
> Hello,
> Does any one has any document or link about pros and cons of using Image
> data type to store images? Specially performance point of view.
> Thanks,
> Mukesh
|||Thanks Wei,
This will help a lot...
Thanks,
Mukesh
"Wei Xiao [MSFT]" wrote:

> Well, it depends. A quick search on the web reveals this article:
> http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
> I hope this will get you started.
>
> --
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
> news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
>
>

Image Data Type

Hello,
Does any one has any document or link about pros and cons of using Image
data type to store images? Specially performance point of view.
Thanks,
MukeshWell, it depends. A quick search on the web reveals this article:
http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
I hope this will get you started.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
> Hello,
> Does any one has any document or link about pros and cons of using Image
> data type to store images? Specially performance point of view.
> Thanks,
> Mukesh|||Thanks Wei,
This will help a lot...
Thanks,
Mukesh
"Wei Xiao [MSFT]" wrote:

> Well, it depends. A quick search on the web reveals this article:
> http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
> I hope this will get you started.
>
> --
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Mukesh" <Mukesh@.discussions.microsoft.com> wrote in message
> news:DBDBEF9F-4897-4043-8F2C-5E0BA9CCA541@.microsoft.com...
>
>

IL3 Cache Recommendations and Explaination

Can someone point me in the right drections?
I need detailed info on the benefits of IL3 Cache when considering new
hardware.
Thanks,
-Ben
See:
http://www.sql-server-performance.co...nce_update.asp
http://www.2cpu.com/articles/99_1.html
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Ben" <bmilliron@.gmail.com> wrote in message
news:O3dNLmekEHA.3152@.TK2MSFTNGP12.phx.gbl...
> Can someone point me in the right drections?
> I need detailed info on the benefits of IL3 Cache when considering new
> hardware.
> Thanks,
> -Ben

IL3 Cache Recommendations and Explaination

Can someone point me in the right drections?
I need detailed info on the benefits of IL3 Cache when considering new
hardware.
Thanks,
-BenSee:
http://www.sql-server-performance.com/jc_processor_performance_update.asp
http://www.2cpu.com/articles/99_1.html
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Ben" <bmilliron@.gmail.com> wrote in message
news:O3dNLmekEHA.3152@.TK2MSFTNGP12.phx.gbl...
> Can someone point me in the right drections?
> I need detailed info on the benefits of IL3 Cache when considering new
> hardware.
> Thanks,
> -Ben

IIS6 connect to sql server on another machine w/windows authentication

Can someone point me at an article that tells how to allow theASP.net worker process to connect, via windows authentication, to aremote sql server instance ?

Start with:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000008.asp

The remote server access is in the connection string, specifying server and instance.

Jeff

|||

Also make sure remote connections enabled on the remote SQL instnace. Check this KB:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277