Microsoft SQL Server Administration

Hi, When looking at the features of SQL Server 2008 Standard, it seems that it doesn't support Indexed Views anymore? - Features 2005: [link] - Features 2008: [link] ...

We are trying to uninstall a database on a SQL Server 2005 box, and I keep getting a 'Pending Reboot Requiment' message which prevents me from going any further. Some posts suggested I clean out the PendingFileRenameOperations values key from HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager and ...

We use Idera's SQL DM to monitor our production servers.  I has a tool to monitor long running queries and pulls data every six minutes.  The server in question uses SQL 2000 SP4, all the others are SP3A and do ...