Technical Article

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)

You rated this post out of 5. Change rating

2011-11-21 (first published: )

2,812 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2006-08-21 (first published: )

472 reads

Blogs

Query multiple Azure SQL Databases

By

I was sick of changing context in Azure Data Studio while cleaning up things...

KDA: Echoes of Deception - Case 3

By

The crime spree in Digitown is not ending. This time 20 cars have been...

The Book of Redgate: Do Your Best Work

By

One of our mission statements in the Book of Redgate says: attempt to do...

Read the latest Blogs

Forums

Helpful Management Studio Settings and Features

By Tony Savoie

Comments posted to this topic are about the item Helpful Management Studio Settings and...

The Minimal Linked Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Minimal Linked Server

The AI View From Above

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI View From Above

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers