Author Archives

Cannot show requested dialog. (SqlMgmt) Property Owner is not available…

I hit the following issue this morning when I tried viewing the properties of a SQL Server database using SSMS: Microsoft SQL Server Management Studio Cannot show requested dialog. ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) Property Owner is not available for Database ‘[databasename]‘. This property may not exist for this object, or may not

Read More…

Which SQL Server instance is consuming all my CPU/memory?

For anyone running Windows 2008 (or above), you can simply add the “Command Line” column to the Task Manager view. From there, the instance name will follow the “-s” startup option, for example: C:\…\Binn\sqlservr.exe” –sPREPROD If you’re on Windows 2000/2003 then it’s not quite as straight forward. You can either get the Process ID from

Read More…

Moving the system databases in SQL Server 2000

The following post provides step by step instructions for moving each of the SQL Server 2000 system databases, one by one, from one location to another, on the same server.  These system databases being: master model msdb tempdb In this case, I need to move all of these system databases from E:\MSSQL\MSSQL\Data to D:\MSSQL\Data For the model and

Read More…