March 1, 2016 by Nitesh

Solution: The certificate chain was issued by an authority that is not trusted

Friends, Recently, I migrated a website hosted on Azure to a shared hosting server and started getting connectivity error for SQL server. The error was – The certificate chain was issued by an authority that is not trusted After some research, I found that the error occurs when we do not have a CA signed…

Continue Reading »

January 14, 2015 by Nitesh

How To INSERT Values Explicitly in Identity Column in SQL

Friends, In this post, we will see how can we insert explicit values in an Identity column in a table in SQL Server. Normally, the data in IDENTITY column should not be entered manually, but there are certain circumstances where you want to insert custom data in the IDENTITY column. If you try entering data…

Continue Reading »

January 1, 2015 by Nitesh

Solution: The server principal is not able to access the database under the current security context in SQL Server

Friends, Yesterday I backed up a SQL database and restored it on a different server. A user was associated with the database on the original server and after I restored it on the new server, the same user was unable to use the database. Trying to use the database gave the error – “The server…

Continue Reading »

October 7, 2014 by Nitesh

SQL Script To List All Columns of a Table in SQL Server

Friends, In my last post, I explained how can you list all tables from a specific table in a database. In this post, we will see different ways of retrieving all columns from a specific table in a database. It is a very simple script to get all columns for a table from a database….

Continue Reading »

October 6, 2014 by Nitesh

SQL Script To List All Tables Present In a Database

Friends, In this small post, we will see 2 different ways of retrieving all the tables from a specific database. It is a very simple script to get all tables from a database. We can do it using 2 ways. They are as below – Using INFORMATION_SCHEMA.TABLES table Using sys.Tables table The below script lists…

Continue Reading »

1 2 3 4

Support us!

If you like this site please help and make click on any of these buttons!

Powered by WordPress Popup