SQL Server useful system stored procedures

madeinstein ,
sp_helprotect [object_name]
Returns a report with information about user permissions for an object, or statement permissions, in the current database.

sp_helptext [view_name]
Prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, computed column, or view.

Full list of System Stored Procedures

Comments

Post a Comment

Popular posts from this blog

How to enable Kerberos Delegation in Google Chrome

madeinstein ,
* Using Registry Key Set/Add this string registry key [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Chrome] Name: AuthNegotiateDelegateWhitelist Value: * * Using Command Line param --auth-negotiate-delegate-whitelist=* Delegation can be restricted to servers in the specific domain *.mydomain.com I’ve tested it with IIS + SQL Server and double hop delegation works fine. You can read more about Google Chrome command line params here .
Read more

Parse XML to dynamic object in C#

madeinstein ,
<? xml version="1.0" encoding="utf-8" ?> < contacts > < contact id = '1' > < firstName > Michael </ firstName > < lastName > Jordan </ lastName > < age > 40 </ age > < dob > 1965 </ dob > < salary > 100.35 </ salary > </ contact > < contact id = '2' > < firstName > Scottie </ firstName > < lastName > Pippen </ lastName > < age > 38 </ age > < dob > 1967 </ dob > < salary > 55.28 </ salary > </ contact > </ contacts > public class XmlToDynamic { public static void Parse(dynamic parent, XElement node) { if (node.HasElements) { if (node.Elements(node.Elements().First().Name.LocalName).Count() > 1) { //list var item = new ExpandoObject(); var list = new List<dynamic...
Read more