Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Do Users based on logins in master have access to other databases? Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 8:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 9:02 PM
Points: 33, Visits: 37
Lynn Pettis (3/20/2013)
Is this some sort of inventory database?


In a manner of speaking yes, this is a type of inventory database of all transactions when a pawnbroker or second-hand sales shop purchases an item from somebody that walks in off the street trying to sell your new Samung 55" Smart TV they obtained from a burglary.

So the state made a law that all these types of transactions must conform to a set of lawful mandates, a good part of which is describing the items with a level of detail that may help identify it if and when police put two and two together.

I would check your state for the same newly emerging laws.

My biggest problem right now is how to programmatically automate filling out an "official" form implemented as a Microsoft Word Form or a filllable pdf form.



Post #1433565
Posted Wednesday, March 20, 2013 9:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 9:02 PM
Points: 33, Visits: 37
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 Data is to try to ensure the files get backed up. I was thinking if there was a problem they could easily be restored using an Attach.


No, no, no, no!!

Copying files is not a SQL Server backup. At best it gets you a DB that you can reattach, at worse it gets you a DB that refuses to reattach because it's inconsistent.

The way to take SQL backups is via BACKUP DATABASE ... TO DISK ... and have that resulting backup file taken off to other storage. Do Not make the common mistake of thinking that you can copy the file of an active, in-use SQL database and you have a working backup. That's Russian roulette with your database.


Yes, Yes, Yes lol

I understand how to correctly backup a SQL Server and I'm only intending to locate the mdf/ldf in the file system because it gives me one last chance to at least try to get the LightSwitch app functional if and when one of the employees blows this sh!t up.

Do you have any experience with PowerShell? A thought just came to mind that perhaps I could build backing up the database correctly using script but generally I flake out and use SQL Management Studio so that's more to learn to do.




Post #1433567
Posted Wednesday, March 20, 2013 9:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 9:02 PM
Points: 33, Visits: 37
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 and lease the privilege to use it to these pawn shops. That way you host the application server and the database server. None of the clients have access to any of the machines. Makes it super secure because the database is tucked away safely right next to the application code on your server.


Your right and LightSwitch apps can be deployed to Azure and run in IE. In fact, if I can figure out how to programmatically automate filling out an official form on the server and then load that form as a pdf in the browser so it can be printed out and signed in ink as the law requires I would not be messing around on the desktop at all.



Post #1433568
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse