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') […]
2011-11-21 (first published: 2007-08-01)
2,834 reads
2011-11-18 (first published: 2008-01-29)
2,919 reads
Calculates server uptime in days, hours, and minutes. Also calculates the UTC date (smalldatetime) when the server was started.
2011-11-17 (first published: 2007-08-31)
2,455 reads
Script reassigns database orphan users to the matching SQL Server logins.
2011-11-15 (first published: 2011-10-24)
2,579 reads
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
701 reads
Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.
2011-11-11 (first published: 2011-09-27)
1,180 reads
Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year
2011-11-08 (first published: 2011-10-11)
9,178 reads
There are many occasions in programs where you need to manipulate strings of characters that are delimited by a particular character, such as a comma, or a space. This function enables you to extract a substring from the string at a specified occurence of the delimter. declare @Data varchar(255) set @Data = 'A,B,C,D,E' print dbo.field(@data,',',2,2) […]
2011-11-07 (first published: 2007-08-03)
2,634 reads
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,540 reads
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,325 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers