set password

[little83]

Dear all

can I set a password for each mdf sql database file...or the password for the whole server..

I used the follwoing string


string query = " CREATE DATABASE " + textBox6.Text.T oString() + " ON PRIMARY "
+ " (NAME = " + textBox6.Text.T oString() + ", "
+ " FILENAME = '" + path + "' ,"
+ "Password =" + textBox8.Text.T oString()
+ ") ";

and I got the following error

Invalid usage of the option Password in the CREATE/ALTER DATABASE statement.

[ck9663]

What are you trying to accomplish?

-- CK