How to Script User and Role Object Permissions in SQL Server for Database

Rédigé par M Sozezzo - - Aucun commentaire

This article is nice ( we have a little bug ) , and the SQL script is not execute-safe (if you run twice, you have errors ).

It is for a specific database, when you need to save all SQL Server, you must run for each database.

Lire la suite de How to Script User and Role Object Permissions in SQL Server for Database

Finding Table and Primary Key and Foreign Key

Rédigé par M Sozezzo - - Aucun commentaire

SQL Server does not help to easily determine the dependencies between tables.
This research presents the parent table and the child tables and columns used.

 

https://msdn.microsoft.com/en-us/library/ms179610.aspx
http://stackoverflow.com/questions/925738/how-to-find-foreign-key-dependencies-in-sql-server
 

well, however, we have many databases with bad design that didn’t have foreign keys defined but that did have related data.

Lire la suite de Finding Table and Primary Key and Foreign Key

Fil RSS des articles de ce mot clé