Best Practice-working with SQL Express Database

Hot Topic

OLE DB Source & Excel Destination
Find versus Select error in SQL Express.
Company Logo in Header of Report Builder
How to ignore timepart when using LookUp with date.
Installing Sql Server 2005 Trial Software From Microsoft Website - Self Extracting Executable
System Configuration Check
nvarchar or varchar in function?
dealing with .dll files after creating Assembly
re-establishing mirror
Best way to make a database not in use?

SQL Server

Set Primary Key when normalizing data?
Update/Delete/Insert not working (by using the DataSource)
Package Configurations not so portable?
Best solution for this "problem"
2000 Client Connectivity .msi?
SQL Server 2000 Null problem
How to Delete Files on Maintenance Plan
Error rendering sub-reports
How to transfer data from a SqlServer database to a SqlServer Express database
Cannot alter or drop fields

Best Practice-working with SQL Express Database

Hi,

I am new to working with Database using .net C#. i will really appreciate if someone can point me to a link where i can find best practices of working with sql express database with my c# web service applications.

preferably i would like to have answers for:

- to have one db or to have one for testing and one real db

- db security

- use windows authentication or db user authentication

etc.




Answer this question

Best Practice-working with SQL Express Database

  • MGM54

    Best practices for SqlExpress will depend somewhat on your environment/requirements. Since you are developing a web service, I suggest asking the question in one of the asp.net forums (forums.asp.net).

    SqlExpress has it's own forum here on the MSDN forums. I'll move the thread over there for more general info on Express best practices.


  • Best Practice-working with SQL Express Database
Answer this question