Ankit Chauhan

Username Password Auth Flow returning different response than expected

You need to pass in your parameters in the body. The request going over the wire should look like this: POST /services/oauth2/token HTTP/1.1 Host: login.salesforce.com Content-Length: ### Content-Type: application/x-www-form-urlencoded Accept: application/json…

Salesforce

Answered Apr 30, 2021 · 781 Views Read answer →

Blue icon with a question mark - what does it mean?

This SQL server icon ( blue question mark), indicates that white question mark on blue circle icon means Status Unknown, SSMS does not know if the service is running or not, by way of a WMI call. I'm quite certain this icon replaced the blank or white circle icon of prior SSMS versions. After some digging, it looks…

SQL Server

Answered Apr 24, 2021 · 6 Views Read answer →

What ports does SQL Server use on Linux?

- Assuming the defaults here is the best solution for what port does sql server use, there are two ports SQL Server listens on which can be verified with netstat -ln,ms-sql-s TCP 1433 for the server ms-sql-m TCP 1434 for the Dedicated Administrator Connection which by default is enabled for local connections on…

SQL Server

Answered Apr 24, 2021 · 7 Views Read answer →

Are composite primary keys bad practice?

To say that the use of sql server composite primary key is bad practice" is utter nonsense! Composite PRIMARY KEYs are often a very "good thing" and the only way to model natural situations that occur in everyday life! Having said that, there would also be many situations where using a composite PK would be cumbersome…

SQL Server

Answered Apr 24, 2021 · 7 Views Read answer →

How do I delete records in the salesforce recycle bin?

If you want to delete the records permanently from recycle bin before Salesforce deletes it you can use emptyRecylebin() method. //To permanently delete the specified records from the recycle bin. //To permanently delete the specified sObject from the recycle bin. Take a look at the Database.emptyRecycleBin(obj)…

Salesforce

Answered Apr 24, 2021 · 14 Views Read answer →

Facing Webassessor Login & Email Address change issue

I've had to do this. Whilst you can change most details on the Edit Profile page, your e-mail address is something you can't change. You'll need to contact them directly, you can use ktnsupport@kryteriononline.com to ask them to change those details. How do I get all of these to be updated to my personal email address…

Salesforce

Answered Apr 24, 2021 · 15 Views Read answer →

How to fetch profileName and permissions assigned to the all active users based on profile name

Please let me know if the code works to solve profile name error: SELECT count() FROM PermissionSetAssignment p WHERE p.PermissionSet.IsOwnedByProfile = false AND p.Assignee.Profile.Name = 'System Administrator' Please mark this as the best answer if it resolves your query.

Python

Answered Apr 24, 2021 · 112 Views Read answer →

Is Hamachi Safe to use for sharing game servers?

I'm going out on a limb here and going to say you are talking about: http://en.wikipedia.org/wiki/Hamachi_(software) Since its a publicly available VPN, connecting to a Hamachi network is a lot like connecting you your own LAN; except for the fact that EVERYONE on the Hamachi network you are connected to is unknown…

SQL Server

Answered Apr 23, 2021 · 6 Views Read answer →

Does SQL Server Compact Edition 4 finally support Views?

I installed WebMatrix w/ CE 4.0 last night. I can't confirm for sure that sql server compact 4.0 can't do views, but I can tell you that there's no support for creating them in WebMatrix.

Salesforce

Answered Apr 23, 2021 · 7 Views Read answer →

MERGE in SQL Server - MERGE a subset of the target table

The MERGE statement has a complex syntax and an even more complex implementation. But essentially, the idea is to join two tables, filter down to rows that need to be changed (inserted, updated, or deleted), and then perform the requested changes. Given the following sample data: Target: Source: The desired outcome is…

SQL Server

Answered Apr 22, 2021 · 6 Views Read answer →

What are the best practices for committing a transaction in SQL Server where TRY CATCH is used?

Here’s the best way I have found to do this: Note the use of XACT_ABORT to make sure that the errors are caught effectively, the fact that both the BEGIN and COMMIT statements are within the TRY block, and the WHILE for @@Trancount - this should ensure nested transactions are rolled back (not always applicable) The…

SQL Server

Answered Apr 22, 2021 · 6 Views Read answer →

How to create datetime in yyyy-mm-dd-hh.mm.ss.fff format?

Check this below workflow… image542×655 14.2 KB Build DatatableInvoke Code dtSample.AsEnumerable().ToList().ForEach(Sub(row) row(“DatefffZ”)=DateTime.ParseExact(row(“DatefffZ”).ToString,“yyyyMMddHHmmss.fff”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-ddTHH:mm:ss.fffZ”))Invoke Code Edit…

Salesforce

Answered Apr 22, 2021 · 6 Views Read answer →