.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Best way of storing Serialized objects into Sql server

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :ASP.Net
For some reason, my app need to store serialized objects into SQL Server. Can you guys please tell me the pros and cons and what's the best way of doing it.

View Complete Post

More Related Resource Links

Data Points: SQL Server Management Objects


SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.

John Papa

MSDN Magazine June 2007

SQL Server and DMO: Distributed Management Objects Enable Easy Task Automation


SQL Server can be administered programmatically using system stored procedures, but Distributed Management Objects (DMO) offer a more modern, object-oriented alternative. This article introduces SQL-DMO in SQL Server 7.0 and SQL Server 2000 and describes the SQL-DMO object model, then focuses primarily on the Databases tree and the JobServer tree of the object model. The sample code and the article show how to use various objects such as the Registry object, the Configuration object, and the Database object to automate common administration tasks such as programmatically retrieving configuration settings, creating new databases, applying T-SQL scripts, and creating and scheduling backups.

Francesco Balena

MSDN Magazine May 2001

storing Session in sql server?



I want to show all the activities of the logged in user in a gridview. I am using VS 2010. please suggest some good ways of doing it.



Generating and storing html pages in User Directories on the server



I come from corporate asp.net development, and I am now working on a public website which will get a lot of traffic, perhaps a million users a day.  So I am faced with a ton of performance and scalability questions.

I would like to share some thoughts and see if my approaches resonate with any good practices, or perhaps I am heading down the wrong path...  Either way, I want to hear opinions.

(My number one concern is the fact that I am using asp.net for a public website.  I don't know of a lot of websites using asp.net)

I am using asp.net 2.0 (I know, its not the latest technology but I don't need any advanced features of asp.net 3.5 or 4, unless there are significant improvements geared towards what I am doing) 

On launch date, this will be running on a dedicated Windows Server 2008 running on Intel ATOM 330 1MB L2 Cache 1.6Ghz Dual-Core with 2GB DDR RAM.  Its fully managed by a full service hosting company which gives me an option to upgrade to a bigger server within a few hours.  I can even move the site to a webfarm if the traffic demands it.

So I have a User Dashboard, where users can create albums and upload pictures.  So what I am doing

Educational question: How server objects are accessed from multiple client threads?

I will appreciate it if someone can help me to undestand how the following scenario works:   There is remoting server that is registered as WellKnownObjectMode.Singleton. Server implementation: It instantiates a class TestServer that implements interface IFoo interface IFoo { IHelper GetHelper() }   interface IHelper { void StoreString(); }   Implementation of TestServer: internal sealed class TestServer: System.MarshalByRefObject, IFoo { private IHelper> helper = new Helper(); public IHelper GetHelper(string helper){return helper;} }   Implementation of Helper: internal sealed class Helper : System.MarshalByRefObject, IHelper { public void StoreString (string val) {}; }   Implementation of a client (simplified; shown to illustrate the question only): static class Program { public static IFoo TestService; public static IHelper Helper; public TestThreads testmultiplecalls; [STAThread] static void Main() { TestService = (IFoo)Activator.GetObject(typeof(IFoo),"ipc://Channel"); Helper = TestService.GetHelper(); testmultiplecalls.Start(); } }   internal class TestThreads { public Start() { for (int i = 0; i < 20; i++) ThreadPool.QueueUserWorkItem((new TestCall(i.ToString())).DoWork); } }     internal class TestCall { private string m_str; public TestCall (string str) {m_str = str;} public void DoWork() { Program.Helper.StoreString(m_str); } }     Que

Serialized objects not consistant between programs

I am experiencing a baffling problem regarding object serialization.  My project consists of two executables, a data editor and the main program, both of which use a common set of DLL object libraries.  The editor is used to create and manipulate a set of custom objects, which it then serializes to a data file.  The main program loads this data file on startup.  The objects are stored in an ObservableCollection, and the serialization routine simply serializes this collection to a data file using a binary formatter.  This routine is in the DLL, and the only data regarding serialization created in the EXEs is the stream, which is passed as a parameter to the function in the DLL. What I'm finding is that the data editor behaves as expected.  If I make changes to the data with the editor, it is writen to the file and the changes will reflect correctly when I run the program again.  However, the main program exhibits a strange behavior where it "remembers" the orginal values of the data objects when they were first persisted.  For instance, if I go into the editor and edit the name of one of the objects, the main program will still pull up the original name of the object when it deserializes the objects.  However, the change will persist in the data editor.  If I add new objects to the collection via the editor, t

Error 2908 while installing sql server 2005 management objects collection on Win 7

I have SQL Server native client 2005 installed on Win 7 64-bit machine. While installing SQL Server XMO 2005 it gives error 2908 and aborts installation. Any suggestion on the error?

"Server Objects and Events" missing

Using in-line code in VS 2010 RC and I can't get the "server objects and Events" drop down to show up.Not sure if this is a bug or what...in VS 2005 / 2008 it would just appear at the top of in-line code files.  I've checked the options/settings menus and haven't found any way to enable it.

Transfer SQL Server Objects reporting success but nothing transferred

I'm trying to "clone" the structure of one database to a new blank database. I can copy the tables over using the Transfer Sql server object without any problems. When I create a separate task "Transfer Sql server object" for the views (CopyAllViews set to true or picking individual views), it always reports success however none of the views were copied. The same problem occurs when I attempt to copy stored procedures. Anyone have an idea of what's going wrong?  

PS2007/MSSQL2008: Cannot install Microsoft SQL Server 2005 Management Objects Collection (sqlserver2

Hi folks, about 1,5 months ago I have set up a - 1 server - development environment for PS2007. I had installed all components on one Windows 2008 box. Everything worked fine, now I receive an error. •MOSS 2007 •SQL 2008 SP1 •MOPS 2007 SP2 I have done the additional installation for the cube building part according to this page http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx Microsoft SQL Server Native Client (sqlncli.msi) Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi) Microsoft SQL Server 2005 Backwards Compatibility Components (SQLServer2005_BC.msi) Everything worked fine. Cubes were able to be built.. everything was good. In order to have Reports built I added SSRS 2008 Reporting Services Addin for MOSS (rsSharePoint_x64) Business Intelligence Development Studio (=Visual Studio for MSSQL) No CUs have been added to this box. NOW, Cube creation fails with the error: ULS LOG: [CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <IPADDRESS>. Error: ActiveX component can't create object 08efbc13-299a-4abe-9021-c46887ca6915 Eventlog says: SSP Name: SharedServices1 PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection i

Transfer SQL Server Objects Task

I'm trying to use the Transfer SQL Server Objects Task to copy database users and database roles from one database to another. The problem is that some of the users already exists in the destination database. Is there a setting or expression or error handler that will allow me to specify to only copy the objects that don't already exist? I can ignore the failure but I won't know if it's really a copy failure or a duplicate. I read the roll-your-own blog referenced in a similar post (http://blogs.msdn.com/b/mattm/archive/2007/04/18/roll-your-own-transfer-sql-server-objects-task.aspx) but I don't know if a property exists for the transfer object with will allow me to indicate that I want to copy users that aren't already in the destination. Has anyone successfully done this? It seems like it would be a simple task.

Find unused objects in a SQL Server 2000 database


Hello All,

I want to know all the objects in a database which are not been used from a long period (Unused in the sense not executed from a long period; example procedures.). Could anyone show be the way of how to get it done.

Thanks in advance.

Pavan Kokkula Infosys Technologies Limited.

Does Transfer SQL Server Objects task transfer objects created in the source AFTER the package has b

I created an SSIS package which contains a Transfer SQL Server Objects Task. I configured this task to copy table objects, stored procedures, and object permissions to the destination. Between the time I created my SSIS package and the time it was run, someone created a new table object in the source, and changed permissions on a stored proc in the source. My question is this, at the time the SSIS package is created, behind the scenes, does SSIS create a list of objects to transfer? I had hoped that it creates the list of what specific objects (of the pre-defined type) to transfer at runtime so that whatever changes were made to the source database would be included at runtime.

Is there any way to get the Transfer SQL Server Objects Task to not throw error if an object already


I've asked this before but never got an answer. Is there a way to configure the Transfer SQL Server Objects Task so that it will only transfer objects that don't already exist in the destination? Or to skip over objects that already exist?

I do not want to "roll my own". I want to use the task in order to save time.

Why does BI "Transfer SQL Server Objects Task" error occur?


I'm using SSIS to copy all tables and the data from server1 to server2.  Database names are same on both source and destination servers. dbo.MyTable definately exists in the source so I don't understand this error message:

 [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37. An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E37  Description: "Invalid object name 'dbo.MyTable'.".  helpFile=dtsmsg100.rll helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}".

 There's nothing fancy about MyTable:

CREATE TABLE [dbo].[MyTable](

[MyId] [

"Transfer SQL Server Objects Task" doesn't always copy the data when it's configured to do so

Can someone enlighten me on why this is happening? I have three instances of the "Transfer SQL Server Objects Task" in an SSIS package, each instance copies tables and data from a different source database. Two of the three copy the data without a problem, but one of them does not copy the data even though I have set the CopyData property = true.  And it does not give an error. The status at the end reports Success. Why is this happening?

Sql Server 2005 32 objects limitation


I have ran into this limitation because using many triggers.  I am using the free 2005 database.  If I want to use more triggers, I need to buy a full version?

Fernand St-Georges
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend