Extract More Than 1000 Active Directory Accounts

This is a simple method to load a SQL database with active directory account information without running into the 1000 record limit.  You will need to change the SERVERNAME, PORT, DATABASENAME, USERID, AND PASSWORD values in the connection strings to your own values.  You will also need to change the LDAP connection string values ('LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld') […]

5 (2)

2011-11-21 (first published: )

2,793 reads

Change to readable date format

Trigger to insert date into table in the form of01/01/00 12:00:00instead of SQL standard date format2000-01-01 12:00:00.000This allows easily comparing to or updating based onOracle date formats or a readable format for the web.triggername - name of the triggerTABLENAME - name of the table that trigger is created onCOLUMNNAME - name of column in TABLENAME […]

2006-08-21 (first published: )

463 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Resetting Gmail Password Can Be Sorted Out Via Gmail Customer Service

By Celina Disuza

Are you one of those who are encountering technical problems during the course of...

Oppose the Premier League

By thanhthuy02

Oppose the Premier League[/b] Between 2005 and 2012 the English Premier League boasted at...

Using All Your Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using All Your Tools

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers