Ankesh Kumar

Is SQL Server Mirroring dependent on SQL Server Agent running?

To solve database mirroring in sql server you can consider mirroring is not dependent on SQL Server Agent running. Communication between primary and secondary happens using TCP IP ports. In database mirroring, principal and mirror server communicate through TCP connection and write data change directly to remote…

Salesforce

Answered Apr 23, 2021 · 1.1K Views Read answer →

What ports does SQL Server need to communicate with a web server?

I would suggest following the guidelines provided by Microsoft here as they will definitely help you resolve What port does SQL server use: TCP/IP port numbers required to communicate to SQL overall a firewall By default, when an application requests a socket from the system for an outbound call, a port number between…

Salesforce

Answered Apr 23, 2021 · 1.4K Views Read answer →

How can do sql server schema compare of two databases?

If you cannot use one of the many tools out there because of connectivity problems and want an "offline" compare, you can use SSMS to generate scripts for all database objects by right clicking on the database and using the "Tasks/Generate Scripts" function, and make sure you select to create one file per object. When…

SQL Server

Answered Apr 23, 2021 · 1.2K Views Read answer →

What is the difference between AppArmor vs Selinux?

When comparing AppArmor vs SELinux, both security systems provide tools to isolate applications from each other. And in turn, isolate an attacker from the rest of the system when an application is compromised. SELinux rule sets are highly complex but with this complexity, you have more control over how processes are…

SQL Server

Answered Apr 22, 2021 · 1.7K Views Read answer →

How to create Clustered and non clustered index in Oracle?

Does Clustered index exist in Oracle database? since I read in some blogs Yes there is. It is called "index organized table" (IOT) - which in my opinion is the better name as it makes it absolutely clear that the index and the table are the same physical thing (which is the reason why we can have only one clustered…

SQL Server

Answered Apr 22, 2021 · 2.0K Views Read answer →

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

Temporary Tables are a great feature that lets you store and process intermediate results by using the same selection, update, and join capabilities that you can use with typical SQL Server tables. The temporary tables could be very useful in some cases to keep temporary data. To create temp table sql server, you can…

SQL Server

Answered Apr 22, 2021 · 0 Views Read answer →

Why INSERT AFTER trigger failing with multiple rows?

An AFTER INSERT Trigger means that MySQL will fire this trigger after the INSERT operation is executed. You get the error due you're trying to insert more than one row, keep in mind that trigger can be called once for multiple inserts. ALTER TRIGGER [dbo].[Trig_Tb_Users_Created] ON [dbo].[Tb_Users] AFTER INSERT AS…

SQL Server

Answered Apr 22, 2021 · 2.2K Views Read answer →

How can I solve SQL Server EXECUTE AS trouble?

This is explained in Extending Database Impersonation by UsingSQL Server EXECUTE AS. The SQL Server EXECUTE AS context is trusted only in the current database and allowing it to spill over to other databases is an escalation of the privilege attack vector. There are two solutions, both described in the article linked…

SQL Server

Answered Apr 22, 2021 · 1.4K Views Read answer →

Update Field On Click of OutputLink in Visualforce?

I took the liberty of rewriting your component to solve apex:outputlink It seemed like you were trying to update the value of the contacts field by 1 when the link was clicked, and were starting out by setting the value directly to one. However, to run an action for components that don't support the action attribute,…

Salesforce

Answered Apr 22, 2021 · 1.2K Views Read answer →

“.addEventListener is not a function” why does this error occur?

The problem is with your code is that your script is executed prior to the HTML element being available. Because of the, that var comment is an empty array. So you should move your script after the html element is available. Also, getElementsByClassName returns html collection, so if you need to add event Listener to…

Salesforce

Answered Apr 16, 2021 · 1.7K Views Read answer →

How decrypt MD5

By its very nature you cannot decrypt MD5. It's a one-way hash algorithm. There are some sites that claim to decrypt certain phrases but all they do is store known phrases to return them. The MD5 cryptographic algorithm is not reversible i.e. We cannot decrypt a hash value created by the MD5 to get the input back to…

Data Science

Answered Apr 16, 2021 · 1.4K Views Read answer →

HTML required Attribute not working in Visualforce?

If html required not working then Instead of using : None Use the following: I hope this helps, thanks.

Salesforce

Answered Apr 14, 2021 · 1.3K Views Read answer →