How to Learn SQL Server Editon


Open a New Query and select msdb database and execute the command following ;

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


 

Comments

Post a Comment

Popular posts from this blog

How to setup your Cisco Access Point to use WPA with Microsoft SBS 2003

802.11b (and 802.11a and 802.11g) are great. You loose the tether to your desktop. The problem is, how do you secure your network so that your users can still use your network without having to jump through hoops. WEP used to be the answer. WEP is insecure and dead. Cisco have an excellent security suite, but if you're a small company then the cost of investing in the additional components may be prohibitive. If this is your case then WPA (Wi-Fi Protected Access) is the solution for you. It has two modes it can be used in, pre-shared key mode and dynamic key mode.
Read more

View log files in Ubuntu Linux

View log files in Ubuntu Linux Q. Can you explain me log files in Ubuntu Linux and how do I view logs? A. All logs are stored in /var/log directory under Ubuntu (and other Linux distro). Linux Log files and usage => /var/log/messages : General log messages => /var/log/boot : System boot log => /var/log/debug : Debugging log messages => /var/log/auth.log : User login and authentication logs => /var/log/daemon.log : Running services such as squid, ntpd and others log message to this file => /var/log/dmesg : Linux kernel ring buffer log => /var/log/dpkg.log : All binary package log includes package installation and other information => /var/log/faillog : User failed login log file => /var/log/kern.log : Kernel log file => /var/log/lpr.log : Printer log file => /var/log/mail.* : All mail server message log files => /var/log/mysql.* : MySQL server log file => /var/log/user.log : All userlevel logs => /var/log/xorg.0.log : X.org log file => /var/l...
Read more

How to Remove Entries from the Remote Desktop Connection Computer Box

My Documents: find the Default.rdp file and delete it. You will need to have your settings adjusted to display hidden files (Tools>Folder Options>View Tab>check Show hidden files and folders) Registry: Start>Run>Regedit>OK HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default Then find the entry that you want to remove and delete it. If you connect to the same PC all the time then you can also add this in as the default option to avoid having to use the dropdown each time.
Read more