Sean Lange (3/20/2013)

---

Sounds to me like this app you are working on would be an excellent candidate for SaaS (Software as a Service). In other words, you create the application...

GilaMonster (3/20/2013)

---

clintonG (3/20/2013)

---

Not to my foreknowledge but I may actually be trying to do a trick niavely as my intent to locate the mdf/ldf files at My Documents > My...

In a manner of speaking yes, this is a type of inventory database of all transactions when a pawnbroker or second-hand sales...

To be honest, I would strongly recommend disassociating yourself from this project because from what I have read up until now it can only end in tears.

...

This story...

Also, I wasn't talking about SQL permissions, you need to lock down the windows machine, limit administrative access, make sure that no one has permissions to the machine unless they...

GilaMonster (3/19/2013)

---

clintonG (3/19/2013)

---

I don't know what's supposed to be so funny. How else could somebody lock down a Windows 7 client OS functioning as a "server" than to use...

kevaburg (3/18/2013)

---

When I look at the SSMS console for a database, I can see under the Permissions section that for a given user/group, DENY DELETE can be granted. Is...

I don't know what's supposed to be so funny. How else could somebody lock down a Windows 7 client OS functioning as a "server" than to use Group Policy...

GilaMonster (3/17/2013)

---

Errrr....

SQL is not Access. It's not a file-based database that sits on a share. It's...

This and similar projects use P2P LANs. The SQLExpress database will be...

kevaburg (3/17/2013)

---

Logins created within the instance have by default no automatic access to any database within that instance. Each created user needs to be explicitly mapped to a database...

// FAILED:

When I ran...

clintonG (3/16/2013)

---

I was going to try it this way:

EXEC sp_addrolemember db_datareader, $(DatabaseUserName)

EXEC sp_addrolemember db_datawriter, ...

I was going to try it this way:

EXEC sp_addrolemember db_datareader, $(DatabaseUserName)

EXEC sp_addrolemember db_datawriter, $(DatabaseUserName)

REVOKE...

Perry Whittle (3/16/2013)

---

clintonG (3/14/2013)

---

Circumstances require a user that can be restricted to login to a specific database to create and edit data entered into tables but cannot delete anything. I...