Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package.
.Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier.
Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people,
system and devices through software".I'm Choulla Naresh..!
You can get the list of all users in a database using this query:
SELECT name AS Username FROM sys.database_principals WHERE type IN ('S', 'U') -- 'S' for SQL user, 'U' for Windows user AND name NOT LIKE '##%'; -- Exclude system users
This lists all users in the current database.
Use the following query to find currently running queries:
SELECT r.session_id, r.start_time, s.text AS query_text, r.status, r.command, r.total_elapsed_time FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s;
This returns details about all currently running queries, including the session ID, query text, and execution status.
You can check the status of running transactions using this query:
SELECT session_id, transaction_id, database_id, transaction_begin_time, transaction_state, transaction_status
FROM sys.dm_tran_active_transactions;
You can use the following query to list all tables in the current database:
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG = 'YourDatabaseName';
This query returns the names of all base tables in the specified database.
You can check the size of a database using the following query:
EXEC sp_spaceused;
Or, for a specific database:
USE YourDatabaseName;
EXEC sp_spaceused;
SELECT
es.session_id AS SPID,
es.login_name,
es.status,
es.host_name,
es.program_name,
es.database_id,
DB_NAME(es.database_id) AS database_name,
ec.client_net_address,
er.wait_type,
er.wait_time,
er.blocking_session_id
FROM sys.dm_exec_sessions es
LEFT JOIN sys.dm_exec_connections ec ON es.session_id = ec.session_id
LEFT JOIN sys.dm_exec_requests er ON es.session_id = er.session_id
WHERE es.database_id = DB_ID('YourDatabaseName');
------------------------------------------------------------------------------------
kill SSID
If you are getting this error breakpoint in view then there is some error in view or some property name is wrong. Then check and fix all lines. After correction it will work.
Common Causes:
Configuration Errors: Issues in your WCF configuration (e.g., app.config or web.config) could trigger this exception. Check that your configuration files are correctly set up, especially sections related to diagnostics and tracing.
Missing or Corrupt DLLs: If a required DLL (e.g., System.ServiceModel.dll) is missing or corrupt, the type initializer might fail. Ensure that all necessary assemblies are present and correctly referenced in your project.
Permissions Issues: The TraceUtility class may attempt to access system resources, such as event logs or trace files. If the application lacks the necessary permissions, it could cause this exception. Ensure your application has the appropriate permissions to access these resources.
folders named X64 and X86 Copy "SQLite.Interop.dll" to both folders after creating them inside the release or debug folders.
[Deprecation] Listener added for a 'DOMSubtreeModified' mutation event. Support for this event type has been removed, and this event will no longer be fired. See https://chromestatus.com/feature/5083947249172480 for more information.
old code
$('.lg-map-text').bind("DOMSubtreeModified", function () {
if ($('.lg-map-text').text() != "") {
var getHtml = $('.lg-map-text');
var state = getHtml["0"].children[1].value;
if (state != undefined) {
GetDescription(state);
$('html, body').animate({
scrollTop: $('.whitesec').offset().top
}, 800
);
}
}
});
new changes
// Function to be called when the mutation is observed
function onMutation(mutationsList, observer) {
// Iterate through all mutations
for (let mutation of mutationsList) {
// Check if the mutation is a change to the text content
if (mutation.type === 'childList' || mutation.type === 'subtree') {
// Check if the element has text content
if ($('.lg-map-text').text() != "") {
var getHtml = $('.lg-map-text');
var state = getHtml[0].children[1].value;
if (state != undefined) {
GetDescription(state);
$('html, body').animate({
scrollTop: $('.whitesec').offset().top
}, 800);
}
}
}
}
}
// Select the target node
var targetNode = document.querySelector('.lg-map-text');
// Create a new MutationObserver instance and pass the callback function
var observer = new MutationObserver(onMutation);
// Options for the observer (which mutations to observe)
var config = { childList: true, subtree: true };
// Start observing the target node for configured mutations
observer.observe(targetNode, config);