June 15, 2011 – Knowledgebase

Soloving the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered" in Microsoft SQL Server 2008 R2

15 June, 2011 Roel van Lisdonk 1 Comment Uncategorized 11:36

When you don’t have Microsoft Office 2007 installed on a machine running Microsoft SQL Server 2008 R2 Integration Services, you might get the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered" Solution

Getting the current complete username in Windows from command line

15 June, 2011 Roel van Lisdonk 0 Comments Uncategorized 10:51

If you want to quickly determine the complete username for the current user in Windows, open a command prompt: start > cmd and type "whoami" Result

Using Common Table Expressions to query a SQL Server table containing hierarchical data (e.g. a parent having children)

15 June, 2011 Roel van Lisdonk 1 Comment Uncategorized 09:45

If you have a table containing hierarchical data (e.g. a parent having children) and you want to show all the children and grand children for a person you can use a "Common Table Expression" in

Day: June 15, 2011

Soloving the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered" in Microsoft SQL Server 2008 R2

Getting the current complete username in Windows from command line

Using Common Table Expressions to query a SQL Server table containing hierarchical data (e.g. a parent having children)