When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
I deinstalled VMM 2012 from one server. But its agents remained on my Hyper-V core installation servers. How to uninstall them if no Add/Remove programs exist, or you dont have original agent.msi package? On Core OS (2008 or 2012) run regedit Go to HKLM\Software\Microsoft\Windows\Current Version\Uninstall Expand Uninstall, then search in subfolders for string in DisplayName =”System …
I recently installed for testing, an SCOM 2012 agent on one machine. But I could not see that computer in Pending Management section. After searching through settings, I found out that you have to set Review new manual agent installation in pending management view in Settings->Securitiy in SCOM Console.
Today I had some problem of connecting to some of Windows 7 machines. The error I recieved was: The RPC server is unavailable. After searching some articles on the net, I found out that I need to enable RemoteAdmin firewall rule, and add DCOM TCP port 135 to Inbound rules. call netsh firewall set service …
I needed to get the list of my reports and what data source and dataset they use. use ReportServer; WITH XMLNAMESPACES ( DEFAULT ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’, ‘http://schemas.microsoft.com/SQLServer/reporting/reportdesigner’ AS rd ) SELECT distinct ReportName = name ,DataSetName = x.value(‘(@Name)[1]’, ‘VARCHAR(250)’) ,DataSourceName = x.value(‘(Query/DataSourceName)[1]’,’VARCHAR(250)’) ,CommandText = x.value(‘(Query/CommandText)[1]’,’VARCHAR(250)’) FROM ( SELECT C.Name,CONVERT(XML,CONVERT(VARBINARY(MAX),C.Content)) AS reportXML FROM ReportServer.dbo.Catalog C WHERE C.Content is …
Yesterday I installed CD Burner XP. After that I couldn’t mount ISO images anymore. The solution to this problem is in file association. Right click on ISO file, select properties; Choose button change on Opens with: From the list, choose Windows Explorer Close properties window, and then try the right click menu …
When you create a Linked Server on SQL Server, some users may get this error: EXECUTE denied on object ‘xp_prop_oledb_provider’, database ‘mssqlsystemresource’, schema ‘sys’. So, the only thing you need (if you have set up your permissions correctly on Linked Server) is to run the following code: GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN; …
Ok, since I have Windows 8 couple of months, I would like to share some things with you. First of all, it took me some time to find out where shut down, restart or log off is… Log off (sign out) or switch user On Start screen / Metro screen, right click on user: Shut …
I had my SSRS running smoothly, but there was one thing bothering me. That was email sender friendly name. In RS Configuration Manager you can setup e-mail settings, and enter senders e-mail address. But every time I got an email with report, the sent from stated sql@sqlreports.com. But I need an friendly name. So, I …