Delete all tables EXEC sp_MSforeachtable @command1 = “DROP TABLE ?” Grant execute permissions to all stored procedures to a specific user CREATE PROC grantexecutepermission( @UserName NVARCHAR(250)) AS DECLARE curse CURSOR …
Usage string domain = “ExampleDomain”; string userName = “ExampleUserName”; string password = “ExamplePassword”; using (Impersonation impersonation = new Impersonation(domain, userName, password)) { // impersonation occuring…
Simple export of a datatable to excel without using COM+ Excel will ask if you want to open this as ‘An XML List’ SaveFileDialog fileDialog…
Heres the results of converting the corresponding number to an character (i.e. Convert.ToChar(34).ToString()) 33 = ! 34 = “ 35 = # 36 =…