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,795 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: )

464 reads

Blogs

Azure Data Engineer Associate

By

You can read about all the new role based qualifications from Microsoft here –...

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Update table and then executeJob in loop

By khushbu

I need to write a query which will first update the table, then execute...

Using two different backup products for each of data and log

By Fal

  To shorten a long story, my organisation has decided to have a vendor...

Compare sql-2012 and sql-2016 settings

By rohitkocharda

Hi everyone, W are just doing a migration from sql 2012 enterprise  to sql...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers