Imports System.Web Imports System.Web.Services Imports System.Web.Services.Protocols Imports System.Data Imports System.Web.Script.Serialization Imports System.Runtime.Serialization.Json Imports System.IO _ _ _ Public Class WS Inherits System.Web.Services.WebService Private strConn As String _ _ Public Function GetSummaryDynamic(ByVal startrowindex As String, ByVal maximumrows As

DirectoryEntry entry = new DirectoryEntry("Domain", "UserName", "Password", AuthenticationTypes.None); DirectorySearcher dSearch = new DirectorySearcher(entry); dSearch.SearchScope = System.DirectoryServices.SearchScope.Subtree; dSearch.ReferralChasing = ReferralChasingOption.All; dSearch.PageSize = 5000; dSearch.Filter = "(&(objectClass=user))"; foreach (SearchResult sResultSet in dSearch.FindAll()) { if (sResultSet.Properties["

To kill all the connections to your database you can use the ALTER DATABASE command. Sometimes you want to restore the database from a backup but can't because people are connected. Here is one way which will kick off all the users immediately TSQLLINE NUMBER OFF | HIDE | SELECT

TSQL CREATE TABLE #TBL_ADM_USER ( user_id INT, user_name NVARCHAR(1000) ) INSERT INTO #TBL_ADM_USER VALUES (1,'NAME1') INSERT INTO #TBL_ADM_USER VALUES (2,'NAME2') INSERT INTO #TBL_ADM_USER VALUES (3,'NAME3') DECLARE @XML_STR AS NVARCHAR(MAX) SET

SELECT 'EXEC SP_RENAME ''' + name + ''' , ''' + 'X_20170223_' + name + '''' FROM sys.objects WHERE type = 'P' and modify_date > '2016-09-09 16:37:38.913' and name not like '

Download SQL Server Data Tools (SSDT) What happened to SQL Server Data Tools in SQL Server 2014? SQL Server Data Tools in SQL Server 2014I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014 (a full version, not