Post Profile






Restricting logon to SQL Server

Discussion and few different approaches how to restrict logon to SQL Server using logon trigger or a a database specific procedure.
read more

share
See more about: SQL Server

Related Posts


Generating a SQL Server CE database schema from a SQL Server database using Entity Framework

Programming / Windows Development : CodeProject

How to generate a SQL Server CE database schema from a SQL Server database using Entity Framework.

Use SQL Server to Manage Completly DB Backups on Mirrored Databases

Programming / Windows Development : CodeProject

Use SQL Server to manage completely Databases backups,network copy and deletion using only stored procedures.

Use SQL Server to Manage Completely DB Backups on Mirrored Databases

Programming / Windows Development : CodeProject

Use SQL Server to manage completely databases backups, network copy and deletion using only stored procedures

Generate insert statements from the specific table data using SQL Server

Programming / Windows Development : CodeProject

When you are deploying your application, sometimes you may want to generate SQL script with the insert statement of the specific database table. The following article shows two easiest ways to do this with SQL Server and SQL Server ...

SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem

Programming / Windows Development : CodeProject

Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.

Comments


Copyright © 2016 Regator, LLC