Can you post the code you are using to save the image data? 

Are you trying to upload and download the image from asp or .Net?

Charles, thanks for the input.

I apologize.  i should have mentioned the above is a hypothetical example.  It's not real but just set up to represent my question at hand.  I...

I wonder if setting the database compatibility level to 70 will work?

Restore the backup to SQL Server 2000.  Then, within enterprise, select the properties of the database and go to the...

I have never defined a db without it.  I just can't imagine doing so.  All i can picture is two-three years down the road all kinds of orphaned rows.

Just remember,...

Joe Celko.  I already know what you are going to say (about identities), so please don't bother.  I would like to hear from others as I rarely care for your...

Same here, don't have time to test it, but what about creating a view where you only have the last 4 digits of CC in a column?  Do search queries...

You might want to try INSTEAD OF INSERT trigger on the table and handle the insert yourself.  Insert the rows you want and ignore the rows you do not want.

How is your report designed?  Is it columnar using the table control?  I too have found that if the report is not columnar, going to excel puts most of the...

Ok,

You cannot do that with ntext, text, image..etc fields.  Instead, you need to grab a portion of the text field using the substring function.  Use a length that you are...

Not sure of your exact needs here, but you may be better off creating a view having a column that is the concatenation of all the needed fields.  Otherwise, you...

Praveen,

If I understand correctly, you want to execute a stored procedure from within a SQL block (or another stored procedure) and work with the result set.

You need to execute the...

I'll stay out of this one.  Oh, what the heck...

The way to correct grammar is not to limit one's language.  Rather, it's best done with education and experience.

By the way...

By the way, John.  Where are you?  You posted only twice to this thread?  You started this fiasco and have not done a good job of moderating the conversation.

Stay in...

Joe is just out right rude in his reply.  I see it as a sign of insecurity. 

"Let's make others feel stupid so I can feel smarter."

That's how you sound,...

"P.P.S.  If I'm not run out of town with this one maybe I can start a fire with the "why are developers re-inventing the wheel by implementing their own user/security...