Richard Imenes

I am a senior database administrator who sometime enjoy writing about the situations, issues and problems that I have experienced, or at least thought about. Both because the SQL Server Community is so good at sharing information and I would like to participate, but I would also try to make an effort so I actually remember some of these things.

Database Object Dependencies

Sometimes you want to find the database object dependency within a database or instance, and luckily this is something Microsoft has thought of in the form of a view called sys.sqlexpressiondependencies. Microsoft also tells us a fair bit about this magnificent view: “(This view) Contains one row for each by-name dependency on a user-defined entity in the current database. This includes dependences between natively compiled, scalar user-defined functions and other SQL Server modules. A depen...
Read post

WMI provider says no.

Lets start with a simple issue that I have struggled with a few times. I try to start SQL Server Configuration Manager and is met with the following puzzling message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e] The Internet list many culprits and most agree that WMI is not to blame this time. Exactly what causes the ...
Read post