How to get the ID of a database in SQL

To get the id of a database just execute the following built-in function:

  
--
-- This query will return the id of the specific database
--
  
SELECT db_id('my_database_name')

JQuery - Get the value of a drop down list

Use this code if you need to get the value of a selected drop down list:

//
// Include a reference to the Jquery library




 Blue
 Yellow
 White

JQuery Change the form's action url

To change the action form url use the next code:

The junk E-mail filter is not available for your account....

If you get the next error when when clicking "Block Sender" on an email:

The Junk E-mail Filter is not available for your Microsoft Exchange Server e-mail account because you are working online. To enable the Junk E-mail Filter for this account, switch to Cached Exchange Mode.

What you need to do is recreate the outlook profile:

• Go to control panel and open the Mail

• Click on show profiles
• Click on Add
• Type a name from the new profile then click the OK button

• Open Outlook using your new profile, now you should be able to send senders to the blocked list

-- The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID {24FF4FDC-1D9F-4195-8C79-0DA39248FF48}

If you see the next error on your logs periodically, the Network Access Protection Agents is not running and a program is trying to use it:

 The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
{24FF4FDC-1D9F-4195-8C79-0DA39248FF48}
 and APPID
{B292921D-AF50-400C-9B75-0C57A7F29BA1}
 to the user NT AUTHORITY\SYSTEM SID (S-1-5-18) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

 If you look in the registry for the key:
HKEY_CLASSES\CLSIC\{24FF4FDC-1D9F-4195-8C79-0DA39248FF48}

The class creating the error in this case is Quarantine Private SHA Binding which which is a Kaspersky Anti-virus product.

The id of this APP:
{B292921D-AF50-400C-9B75-0C57A7F29BA1}
corresponds to the DCOM NAP Agent Service, which in turn is part of the Network Access Protection Agent service.You can see this in the Component Services

The DCOM error is being generated because the application’s SHA encryption module is trying to register with the NAP Agent but the  NAP service is not running.

To solve this problem, just enable the Network Protection Agent service.

JQuery - Get the value of a text box with JQuery

Use this if you need to extract the value of a text box

//
// Include a reference to the Jquery library

JQuery - How to veify JQuery was loadded on the web page

Use this code to verify JQuery was loadded property to your web page.

 

//
// See if the jQuery was loadded
if (jQuery) {  
    alert("jQuery is loaded");
} 
else {
    alert("jQuery is not loaded");
}
//
//