Browse by Tags

All Tags » SQL Server (RSS)

Show images on Grid View from File Stream SQL Server 2008 by aghausman12

Background : In my last post about SQL Server 2008 new feature File Stream (Saving and Retrieving File Using FileStream SQL Server 2008) , we did an example of saving an image to the file stream and then retrieve it back and make it available for download...
Filed under: , ,

Storing/Retrieving Hierarchies In SQL Server Database by aghausman12

Hierarchies are one of the most important part of many applications. It can be in shape of categories, family tree, organization charts etc. Maintaining hierarchies in data source like XML is not a big deal but when it comes to the database like SQL Server...
Filed under: ,

Saving and Retrieving File Using FileStream SQL Server 2008 by aghausman12

FileStream data type is a very important feature of SQL Server 2008 and gradually getting popular amongst developer for it’s feasibility. And in the past few days specially after “ Configure SQL Server 2008 for File Stream ” post. I received several feedbacks...
Filed under: , , ,

Configure SQL Server 2008 for File Stream by aghausman12

Well, from past two days I am working on SQL Server 2008 new feature called File Stream. In the period of SQL Server 2005 when we want to store some files to the database we can have that using varbinary(max) but that approach is not either smart nor...
Filed under: ,

Installing SQL Server 2008 Express by aghausman12

Currently, by the time I am posting this stuff SQL Server 2008 is in CTP. And off course, it has several installation issues. For the very first time, when I sit for the installation of SQL Server 2008 Express believe me I run the setup up to four times...
Filed under:

Backup Failed : System.Data.SqlClient.SqlError: Failed to pause catalog for backup. Backup was aborted. by aghausman12

This morning when I was taking backup of the database located on one of our dedicated server. I hunt the following error. System.Data.SqlClient.SqlError: Failed to pause catalog for backup. Backup was aborted. In short, you are no more able to take backups...
Filed under:

Beta Components Detected on SQL Server 2005 Installation by aghausman12

This weekend, I was in Morgan Technologies as they were facing some installation problem in SQL Server 2005 enterprise edition. So they called me up with relation to the community work. So the error was Errors occurred during the installation: Beta components...
Filed under:

CLR Integration and Lightweight Pooling Conflict by aghausman12

I thought I am CLR Integration Guru in Sql Server but this morning I came to know that there are lots of things left to grab. While I was moving the local database on the new live server I run some CLR Procedure which Says these procedures required CLR...
Filed under: ,
More Posts