If you repeatedly use a Remote Desktop session and that session needs access to files on the machine you’re connecting from then you’d normally set up a network drive, possibly mapped as follows:
net use z: \\yourmachine\c$ /persistent:Yes
But, depending on how Draconian your network security is then mapping folders on user machines may actually be blocked. Strange one as this ability is mostly essential when working on a remote machine, especially if a developer. Fortunately you can map using the built in sharing of RDP. Same format as earlier just the machine name changes and effectively becomes a constant, so the mapping is now:
net use z: \\tsclient\c /persistent:Yes
And job done, until the next group policy is introduced blocking that…
Need to find a column in a database? The following SQL will return the tables, and columns, that contain a wildcard value
SELECT c.name AS ColumnName,
t.name AS TableName
FROM sys.columns c
JOIN sys.tables t
ON c.object_id = t.object_id
WHERE c.name LIKE '%column_name%'
ORDER BY TableName,
Try this solution, posted as a fix for Windows 7 but worked for me under Windows 10.
Since I installed the “Windows 10 Fall Creators Update”, build 16299, the desktop has stopped auto-starting, to it’s BIOS configured schedule. It’s scheduled for a 5:01am start, but every morning I’ve come into the room, since the update, it’s sitting there switched off.
A couple of Google’s later and here’s the answer, well I hope it is as I haven’t verified it yet, something for tomorrow morning. So the suggestion is to disable Windows “fast startup” mode, details on doing that can be found over at TechAdvisor.co.uk, and a more detailed explaination of why is at HowToGeek.com.
29th October 2017: Seems to have resolved the issue.
Having problems setting, and retaining, the Updater Proxy in the Notepad++ UI?
Then resort to the command line. Open a cmd prompt, with administrator privileges.
At the prompt go to the Notepad++ updater directory, the following works for default installations:
cd C:\Program Files (x86)\Notepad++\updater
From here run this command:
This brings up the same dialog as the UI but this time the values you enter will be saved.
Just some random jottings on tools to repair Windows, release 10 and maybe 7 and 8 as well.
Some of the options for this tool are not available depending on Windows version (Enterprise, Professional or Home) and also release.
- DISM.exe /Online /cleanup-image /scanhealth
- DISM.exe /Online /Cleanup-image /Restorehealth
Tries to repair any file corruption in Windows files.
- sfc /scannow
- sfc /verifyonly
Link to download the first copy of PC Pro from 1994:
Back to the world of COM, 32 Bit OS, OS/2 and Parallel ports
Looking for a column that’s directly referenced by a stored procedure (sproc) then try running this query:
SELECT SProcName = OBJECT_NAME(object_id), Definition
FROM sys.sql_modules WHERE definition LIKE '%SEARCH_CRITERIA%'
ORDER BY SProcName;
This replaces the previous post.
If using MS SQL Server Management Studio 17+ then you need to make sure that the following option is checked:
Tools>Options>Query Results>SQL Server>Results to Grid>Retain CR/LF on copy or save
Otherwise carriage returns are lost. After checking the option you need to restart SSMS, for it to take effect on any queries.