Find MSSQL Server Errorlog Location with Logparser

We are running much SQL Servers with different located ErrorLogs. Sometimes its useful to find quick the Location from the Logs. I did a Command that gives me the Errorlog location to the Command prompt, so I can copy them on my Client and open it in my lovely Editor …

more ...


SQLH2 Query

We’r using SQLH2

We’re using SQLH2 from Microsoft to bring sql server related information together on one data store. It’s not a perfect solution when 64-bit is in use, because sqlh2 cannot gather information’s from SQL Server x64. In our case its ok to exclude 64-bit …

more ...


Enterprise Manager: Value not found in the ConfigValues collection

Nach einem Disaster Recovery mit rebildm.exe erscheint beim öffnen der Server Eigenschaften die Meldung:

Value not found in the ConfigValues collection

Error 21776: [SQL-DMO]The name ‘max server memory (MB)’ was not found in the ConfigValues collection. If the name is a qualified name, use [] to separate various parts …

more ...