What will be the output message?

SQL Server Unique Constraints for Large Text Columns

We are storing large text and URLs that are over 900 bytes in some of our tables and have a requirement to enforce uniqueness in those columns. But SQL Server has a limitation that index size can't be over 900 bytes. How do I enforce uniqueness in these columns and is it possible to achieve this in SQL Server 2005 and above? What are my different options to solve this problem? I heard that we can use CHECKSUM to create a hash, but is it possible to avoid collisions in the hash value as we are storing millions of rows?

Remote BLOB Store Provider Library Implementation Specification

This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.

Binary Files Import and Export

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.

Storing Images and BLOB files in SQL Server Part 4

Part 4 of this series focuses on storing BLOBs on the Windows File System and using Microsoft SQL Server to organize them from a web page.

Storing Images and BLOB files in SQL Server Part 2

Part two of this article focuses on using the SQL Server Binary data type to store small image files.

Revenge of the BLOB

Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.

Storing Images and BLOB files in SQL Server

This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.

RE: Login failed for user ''''(null)'''' in linked server

check this articles. you need to set up security account delegationhttp://www.sql-server-performance.com/tb_kerberos_protocol_transition.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_24tv.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp 

RE: how to get my backup to dump the transaction file?

hi sqlbill,can you tell me exactly how to do this?thanks