SQL Server Performance Forum – Threads Archive

Attaching .mdf/.ldf

Hi All: One of my client has copy+pasted .mdf & .ldf from one machine to another machine and attached it over there. I dont want to allow him to do that. Is there any way out ? Thanks in advance.

Why do you want to restrict this? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

Bcoz i dont want him to know the Database Structure…

I don’t understand. He should be able to see the structure on either machine. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

You can protect your code, no structure. More if is your client.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirÃ¡ luego de tu muerte
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Okey, let me explain this way… We have deployed an application ( vb/sql ) to one of my client. He dont know the login UserName/PWD so he is not able to connect to the database. But what he has done is, copy+pasted .mdf/.ldf from one machine to another SQL server machine and attached it. Now he can open the database there and able to see the database structure and thats my company dont want.

Well, if you have a legal contract that forbids your client seeing (not changing!) the structure, and you can prove he’s violating this agreement, sue him. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

First time I see that.
Is an open database not for change but not for seeing? Agree with Frank if you have a legal contract…… Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirÃ¡ luego de tu muerte
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>