Just run this in a SQL query:
SELECT SYSTEM_USER
MSSQL see online user
Leave a reply
Author Archives: admin
Limit SQL Server maximum memory SQL instance
- Start SQL Server Management Studio
- Connect to you SQL server instance
- Start a “New Query”
- And then put this into you SQLQuery1.sql window
sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 4096
reconfigure with override
go
- Then push the execute buttom, this will limit you SQL instance to 4096MB or 4GB. Please beware of, if you have multiple instance each instance you wan’t to limit
Limit SQL Server maximum memory SQL of WSUS
- Start SQL Server Management Studio
- Connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
- Start a “New Query”
- And then put this into you SQLQuery1.sql window
sp_configure ‘show advanced options’,1
reconfigure with override
go
sp_configure ‘max server memory’, 256
reconfigure with override
go
- Then push the execute buttom, this will limit you SQL of WSUS to 256MB, whitch should be enough.
TMG and Internet Explorer 9 – file:///C:/Program%20Files/Microsoft%20Forefront%20Threat%20Management%20Gateway/UI_HTMLs/Generic.htm?guid=
Hello
If you have Internet Explorer 9 and TMG / UAG installed on the same machine you need to apply this patch, else you will get:
file:///C:/Program%20Files/Microsoft%20Forefront%20Threat%20Management%20Gateway/UI_HTMLs/Generic.htm?guid=%7B1FC3773B-C941-450C-BA39-224904EFD093%7D
- * Open “C:\Program Files\Microsoft Forefront Threat Management Gateway\UI_HTMLs\TabsHandler\TabsHandler.htc”
- Search for the 3 lines which contain “paddingTop”, and remark-out each of them by adding “//” in the begining.
Example: Change the line:
m_aPages [niPage].m_tdMain.style.paddingTop = ((m_nBoostUp < 0) ? -m_nBoostUp : 0) ;
into:
// m_aPages [niPage].m_tdMain.style.paddingTop = ((m_nBoostUp < 0) ? -m_nBoostUp : 0) ; - Save the file, and re-open TMG management console.
Windows cannot print due to a problem with the current printer setup
I have this error on my Citrix servers, where one user cannot print to one printers, while others user could.
“Windows cannot print due to a problem with the current printer setup”
The Danish error:
windows kan ikke udskrive pga. problemer med den nuværende printerindstilling
The fix was:
- Log on as the user have the problems
- Delete all printers in: devices and printers.
- Start regedit
- Navigate to: HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Devices
- And delete all entry here, beware of not delete any entry that there still exist in devices and printers
The problems was that some printers are created with:
“\\\\server.domain\printname”=”winspool,Ne-01:”
will others are created with:
“\\\server.domain\printname”=”winspool,Ne35:” without the hyphen, and that seam to be the problems.
Get list of installed programs from dead disk ubuntu debian
If you have a dead installation, some will not boot you can use this commands, to get the list of installed programs.
grep -B 1 \
"^Status: install ok installed$" /media/recovery2/var/lib/dpkg/status | \
awk '/^Package:.*$/{print $2"\t\tinstall"}' | \
sort > package.list
And this command to install it on a new installation:
dpkg --set-selections < package.list apt-get dselect-upgrade
Get all mailboxes that have this domain in there primary email address
GET-MAILBOX * | where { $_.PrimarySMTPAddress.Domain -eq ‘kennethdalbjerg.dk’ }
Roles to be installed before Exchange 2010 SP1
Start powershell and run import-module servermanager
Then run
Add-WindowsFeature NET-Framework,RSAT-ADDS,Web-Server,Web-Basic-Auth,Web-Windows-Auth,Web-Metabase,Web-Net-Ext,Web-Lgcy-Mgmt-Console,WAS-Process-Model,RSAT-Web-Server,Web-ISAPI-Ext,Web-Digest-Auth,Web-Dyn-Compression,NET-HTTP-Activation,RPC-Over-HTTP-Proxy -Restart
Microsoft C5 åbner og lukker med det samme igen
Hvis du har problemer med at C5 2010 bare lukker med det samme nå du åbner det, så skyldtes det sikkert at der i ini filen er en linie med -usupervisor
Slet denne linie
Active Sync – Unexpected Exchange mailbox Server (Exchange 2003)
Unexpected Exchange mailbox Server error: Server: [server01.XXXX.XX] User: [[email protected]] HTTP status code: [503]. Verify that the Exchange mailbox Server is working correctly.
If you got this error, please follow this steps:
- Try disabling the firewall
- Reset Exchange Folder in IIS – http://support.microsoft.com/kb/883380 (Dont remove exchange-oma)
- Remove Exchange-oma and create it again http://support.microsoft.com/kb/817379
- Remove IPV6 from the server