Browse by Tags

Related Posts

  • Optimizing connection pooling

    Hi, I'm trying to optimize an ASP.NET 2.0 app where, with a load of 100 users, the CPU usage on the web server is a reasonable <20% but the db server (SQL Server 2005) often goes up to 100% and never below 20%. When viewing the Performance Monitor counter SQL Server :General Statistics/User Connections...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by fimatronn on 02-16-2007, 12:00 AM
    Filed under: SQL Server 2005, ASP.NET, Connnection String, Microsoft SQL Server 2005, Connection String, .NET SQL Server 2005, SQL, Database, SQL 2005 ASP.NET, ADO.NET, SQL connection ControlParameter SelectParameters GridView, 2.0
  • Cannot open SQL DB request for this login. (System.Data.SqlClient.SqlException)

    Hi guys, Everything seems to be fine, can browse the DB from VS, Preview data works fine in dataset, and the page works fine before adding any SQL DB code. I draged n dropped a new DropDownList, Bind it to an object from dataset. And when I want to run the page I get this error !!! I appreciate any help...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mehdi6002 on 02-28-2007, 12:00 AM
    Filed under: .NET SQL Server 2005, SQL, aspnet_regsql.exe, SQL 2005 ASP.NET, SQL connection ControlParameter SelectParameters GridView, 2.0
  • How to maintain users permission and access level

    Hi guys, We have a scenario where there are about 50 tables in our database and we want to build an intranet web application for users to with the office to access those tables. Users ability to access tables falls into diferent category: Some users can NOT view some tables at all Some users can ONLY...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mehdi6002 on 03-09-2007, 12:00 AM
    Filed under: SQL datatable, SQL Server 2005, ASP.NET, SQL Permissions, Microsoft SQL Server 2005, SQL, Database, SQL Server 2000, SQL 2005 ASP.NET, Roles, sql server database diagram asp.net, ADO.NET, sql 2000, sql 2000 "sql server express 2005", 2.0, sql 2005, SQL Server 2005 ADO.NET ASP.NET Large File, Membership, SqlCommand
  • Re: How to get the database file into .bak file format using C#

    Hi, They Above Article is useful for me. But this coding is stored is database Queries in text(txt) format but i need the database table values stored in .bak format. Give the solution please
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by subashini on 02-20-2007, 12:00 AM
    Filed under: ASP.NET, .NET SQL Server 2000, Database Export, .NET SQL Server 2005, SQL, Database, SQL Server 2000, SQL 2005 ASP.NET, Datatables, sql c# textbox asp.net, ADO.NET, sql 2000, 2.0, sql 2005, SQL 2005 Compact Edition, SQL 2000 Server Connection
Page 1 of 1 (4 items)