Just a day ago I received a question from a reader who just installed SQL Server 2008. After the installation user did not find any sample database along with installation. The user wants to install the sample database which he is very much used to. Let us learn about Sample Database AdventureWorks.
SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server
If you are receiving the following error related to connection to SQL Server, this blog is for you.Â
SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000
If you are still using SQL Server 2000 (you should have upgraded to SQL Server 2005 by now), there is Security Upgrade for Service Pack 4 and MSDE. Download SQL Server 2000 Security Upgrade Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – 2008 – Released To Manufacturing Available
Microsoft has Released To Manufacturing available for SQL Server 2008. Released To Manufacturing (RTM) means that code of SQL Server 2008 has been approved by MS team and it is being send to manufacture. It will be while before it is available on distribute media on store shelves. Currently it…
Read More
SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
One of the JR. Developer asked me a day ago, does SQL Server has similar operation like MINUS clause in Oracle. Absolutely, EXCEPT clause in SQL Server is exactly similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are…
Read MoreSQL SERVER – Query to Find Column From All Tables of Database
One question came up just a day ago while I was writing SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN. How many tables in database AdventureWorks have column name like ‘EmployeeID’? It was quite an interesting question and I thought if there…
Read MoreSQL SERVER – 2005 – Get Field Name and Type of Database Table
In today’s article we will see question of one of reader Mohan and answer from expert Imran Mohammed. Imran thank you for answering question of Mohan. Question of Mohan: hi all, how can i get field name and type etc. in MS-SQL server 2005. is there any query available??? Answer…
Read More