set password on database in sql server 2005

[SajjadZare]

How to set password on database in sql server 2005 ?

[Blue_Boy]

Which password?

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post. www.cacttus.com

[dan sh]

This one: *****.

"The worst code you'll come across is code you wrote last year.", wizardzz[^]

[Blue_Boy]

d@nish wrote:

This one: *****

:laugh: :thumbsup:

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post. www.cacttus.com

[SajjadZare]

Set a password that other people can't open my mdf file

[Blue_Boy]

I guess, this link [^]can help you

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post. www.cacttus.com

[Lost User]

You cannot set password on the SQL Server mdf file as you do with an Access mdb file. Use SQL Server Authentication to restrict what users can see.