Keep it Simple and Smart
During the installation of SQL Server if you choose the windows authentication mode and sa login is disabled. With the help of following steps you can change the authentication mode from windows to SQL Server authentication mode. Change the Authentication Mode In SQL Server Management Studio Object Explorer, right-click the
» Read moreDuring the installation of SQL Server you can choose the authentication mode for Database Instance. SQL Server support the two authentication mode as Windows authentication mode: Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication. Even if you choose Windows Authentication mode during SQL Server installation “sa” user
» Read moreDeploying the customized report on the SSRS templates is not a very complex task though it needs a lot of concentration. It is represented in a single form format along with the header and footer sections. When the starting phase is begun; the reports are explored in the enterprise level.
» Read moreStructured query language is applied to manage any kind of data extracted from relational database. But during these specific operations several errors can come up into the field. Amongst those, Error 8942 is much common in unexpected occurrence. Though Sql server is much reliable, effective and faster environmental platform, it
» Read moreIn this post, we will learn with example how to add the column dynamically in where clause. Example: For demo we have table as shown in the snapshot Basically we want to execute following script (i.e. Script: 1) but column name (i.e. FIRST_NAME) added dynamically in where clause. Script: 1
» Read moreError Msg Server: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier could not be bound. Cause of this Error Msg: Case: 1 This error usually occurs when an alias is used when referencing a column in a SELECT statement and the alias used is not defined anywhere
» Read moreWindows firewall is nothing but the software and hardware based network security. It generally controls the transaction traffic mixed up with data packets. Simultaneously it determines whether the upcoming signal is eligible for further routing or not. The threats coming from outside can be prevented with this protective shield. On
» Read moreQuestion: Do we need any permission to create temp table in SQL Server? Or Question: Which permission is required to create temp table in SQL Server? Answer: No permissions are required to create temp tables. Any user can create temp table, as long as they can connect to the SQL
» Read moreThis is very quick way to generate the Insert Statement for all of the data in your table. This is really very useful feature of SQL Server Summary: Right click on the database and go to Tasks -> Generate Scripts Select the tables for that you want to generate the
» Read moreThe SQL Server Import and Export Wizard provides the simplest method of copying data between data sources. In this article given an example to copy the data from SQL Server to Oracle database. Click here to download the full PDF version of this article. After this article,for more detail about
» Read moreVarinder Sandhu is using WP-Gravatar