.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

Temporarily isolate database changes based on HostName

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

I want to configure SQL Server so that any commands coming from a specific host get processed separately. My goal is to be able to test the impact of rather drastic changes without having to make a copy of a gigantic database. Ideally, I would also be able to tell how much of a resource impact this was causing on the server.

When I finish, I am perfectly happy to throw it all away and repeat the parts I wanted 'for real' as a test for the push to the staging / production servers. I guess it would be like transactions but across connections and applications... a big, cumulative transaction per-connecting-machine. I believe snapshots offer similar functionality but as far as I know they are read-only.

Thanks; I hope this is the right place to ask whether or not this type of feature exists in SQL Server.

View Complete Post

More Related Resource Links

using policy based management to exclude database access

After reading information on the link http://www.mssqltips.com/tip.asp?tip=1492 I was wondering whether its possible to have a policy in place such that database A cannot make reference to objects in database_B, I am guessing that one would have a policy such that the contents of the objects must not be like %database_B.%   Let me know whether there is a better way to do this. Thanks.

Form Based Authentication with Custom database

Hi, I have a Sharepoint 2010 web application and I want to implement FBA(Form Based Authentication) for that. I don't want to use any membership providers and role providers. I have a SQL server database where we will maintain users and roles. I want to use this database for validating user credentials and authenticating them. Is this possible in Sharepoint 2010? Please reply ASAP.

Suppose we are building a web-based application to retrieve and enter information into a database.

Please help me out with thisSuppose we are building a web-based application to retrieve and enter information into a database.  The user-interface invokes web services.  Which architecture  would use for the application.

Forms based authentication allow only specific users from database table


I have the following implementation and I'm sure there is an easy way to do what I want to do but I can't figure it out. 

1. I use forms based authentication to authenticate to my site

2.  I use active directory to authenticate the users

3.  I use the Allow Users="xxx" tag to authorize the users limited to the list that can access my site. (e.g.. even though Mary is an AD user she can't access my site unless I put her credentials in the allow users tag in the web.config file)

All is working well but I want to move the users access list (e.g.. <allow users="john" />" from the web.config to a database table so that I can create a user maintenance page for my admins to add and delete user access.   For the life of me I can't figure out how to do this and I can't seem to find an article on it either.  I'm sure I'm just not looking for the right thing, so help is greatly appreciated. 

Here is my web.config file..

        <add name="DBConnectionString" connectionString="Data Source=PRIMSRV;Initial Catalog=MAINDB;Persist Security Info=True;User ID=svc.Test;Password=password

Form Based Authentication(FBA) with Oracle database

can anybody give me configuration details for share point Form Based Authentication with Oracle database

create sql server database based on the dataset c#


Hi all,

I am reading xml file using dataset.readxml() method. . . after this i want to send this data to the database. I want c# code to create a database in sql sever and push watever data in the dataset to that created database.... i am dealing with many xml documents... some could be of same format.. lets say... if 2 docs of same format exists... then it shud not create new database or new tables.. it shud push the data to the suitable format...as i am a newbie its a bit confusing for me... i dont even have any idea on how to proceed with this... please reply if you know the answer for any part of the requirement... any help is very much appreciated..




Managing user accounts in SQL database for form based authentication


Hi everyone

I have just configured form based authentication using a SQL database created using aspnet_regsql.exe.
Does anyone know of an good solutions that my customer can use to manage it, add users, delete user etc


I would like to update my database based upon files that are found in a certain directory.


I'm having an incredibly hard time with this, I'm really new to it.  I'm creating a website for free web graphics and I would like to add data to my database whenever more files are added to my server.  I've found a way to list all the files in the directory:

<script language="C#" Runat="server">
        // declare the page level variable for the path
        String FilePath;
        protected void Page_Load(object sender, EventArgs e)
            FilePath = Server.MapPath("~/thumbs");            
            GetFiles();  //call the GetFiles method
            lblHeader.Text = "Files in " + FilePath;
        private void GetFiles()
            //Create the DataTable, with columns in which to add the file list
            DataTable dt=new DataTable();
            dt.Columns.Add("Thumb Exists?", typeof(System.String));
            DataRow dr=null;
            DirectoryInfo dir=new DirectoryInfo(FilePath);

            // Iterate through the datatable,
            // adding file to a new row, along with the  filesize to each row
            foreach (FileInfo 

How to make a Bangla language based database and software ?


I want to create a software using C#.NET which is a Spell Checker for Bangla Language. For this, I need to build a database which will store the 'Bangla' words and by programming, it will check the spelling.
I also asked the same question in Codeproject.com .Anyone replied me "Make sure your database is Unicode capable and aware".So which which are Unicode Capable database.Is SQL Server?

So how can I do it?

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

5 GridView Themes Based on Google's Personalized Homepage (igoogle)

One of the silly features I have found that I like about igoogle is how the pages color palette changes depending upon the time of day. So as the day progresses from morning to afternoon to evening the colors on the page change as well. Like I said, I know this is a silly feature, but I like it. And I have asked around a little bit and seems like other people like it to. To get a better idea of how the colors change, here are the background images from a few of the HTML elements.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.
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