R

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.

richardimenes.com

Database Object Dependencies

July 2, 2024•770 words

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...

WMI provider says no.

May 20, 2024•294 words

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 ...