service of sqlexpress protect from mdf file when it Attached to sqlexpress

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi
i create a program that it use database(sql).

i tested it in another computer that installed sqlexpress with Advanced Services in it.
i installed part of sqlexpress(only SQL Server Database Engine and Full-Text Search) in target computer.

Now,service of sqlexpress don't protect from delete mdf file when it Attached to sqlexpress.

i want that service of sqlexpress protect from mdf file when it Attached to sqlexpress.

Please guide me,Thanks.

Posted 2-Sep-10 21:57pm

saeid2010

Updated 3-Sep-10 8:29am

v5

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Steve Maier · Answer 1 · 2010-09-03T09:50:00

You might want to setup SQL user accounts so that other accounts do not have permission to drop the database, only look at / add things.

If you are talking about the fact the it seems that SQL Express 2008 will let you delete the mdf file from under it when you startup if nobody is using the database then you could always make a small app/service that gets put on the startup of the system to start pinging that database so that it gets loaded into memory. I know that is a bit extreme way to do it but it is not hard to do.