Browse by Tags

• SQL CLR
• SQL Server 2005
• SQL Server 2005 Security

• How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code.

  As all of you know it is possible to query active directory from SQL Server with using ADSI provider as linked server. This solution works fine until you will have a lot of users in active directory. According to best practice guide windows system engineers Read More... Posted Thursday, March 22, 2007 3:08 PM by Igor Kovalenko | 20 Comments Filed under: TSQL, SQL Server 2005 Security, SQL Server 2005 Administration, SQL CLR Attachment(s): MSADHelper2.rar

• Workaround for “Unable to set Default Schema for a group”.

  Let assume you are using Windows Authentication with SQL Server 2005, you've added a new server account for domain group and would like to give it a default schema. The properties window is the same for users and groups but the default schema field is Read More... Posted Saturday, January 27, 2007 11:02 PM by Igor Kovalenko | 1 Comments Filed under: SQL Server 2005, TSQL, SQL Server 2005 Administration