Re: Hide SQL Server DB

Hi
You cannot really hide the databases. In SQL Server 2005 you can implement
DENY VIEW ANY DEFINITION...... (For more details please see BOL)





"mal hit" <malehit@xxxxxxxxx> wrote in message
news:O8aDI6XoGHA.1592@xxxxxxxxxxxxxxxxxxxxxxx
I would like to know if it's possible to embed a SQL Server 2000/2005 DB
within a desktop application so that the end users cannot view the DB.
Also, this will prevent them from copying the database on to their other
SQL Servers.

*** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is friggin dead.. ... SQL Server has taken over the world. ... than read-only access to central company databases. ... I learned to write queries in Access after an hours' ...
    (microsoft.public.excel)