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
Category: Microsoft
Windows 10 start menu search problem
Hi, when Windows 10 came out, I bravely installed it on my business notebook. It works great, except Start menu search. Everything I searched returned blank. So I got couple of days to check what was going on. I tried repairing Windows with SFC, I tried turning off Cortana, tamper with registry.. but nothing worked. …
Uninistall of SC agents from Core OS
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 …
SCOM – Setting Pending management after manual agent installation
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.
Windows: RPC server unavailable
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 …
SRSS – Get list of Reports and Its Data sources and Datasets
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 …
Enable / Re-enable mount of ISO image in Windows 8
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 …
SQL – Linked Server xp_prop_oledb_provider error
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; …
Windows 8 Tips & Tricks
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 …
SQL Server Reporting Service (SSRS) – Use email friendly name
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 …