Storing attachments in tables on SQL Server 2005

Tags:
.NET
SQL Server 2005
SQL Server migration
I am new on .NET and plan to migrate some applications to this new environment. I have a simple question – on SQL 2005, can you store attachments inside of tables?
ASKED: June 13, 2008  3:18 PM
UPDATED: June 13, 2008  5:24 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes you can. In SQL 2005 you will want to store the files within a column of the type VARBINARY(MAX). This will allow for up to 2 Gigs of data per record within that field.

However it is recommend that you not store files within the SQL Table. Instead store the file outside of the database, and store only the path to the file within the database. Using this method will greatly increase your system performance over storing the data within the database.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following