SQL, Analysis Services & related stories.
- Posts
- 8 from 2 Dec 2006 to 28 Apr 2007
- Posting
- archived, read-only
- Kind
- personal blog
- Feed
- https://learn.microsoft.com/en-us/archive/blogs/ikovalenko/feed.xml
2007 7
- SQL 2000 to SQL 2005 migration: temporary tables reuse issue.
- SQL 2000 to 2005 migration: execution plan change issue.
- How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code.
- Switching context with using EXECUTE AS ... not always switch it in fact as you wish.
- Workaround for “Unable to set Default Schema for a group”.
- SQL Server 2005: building security model based on DDL triggers.
- db_securityadmin is very powerfull and … dangerous.