Home » SQL Server » Page 2

SQL Server

SQL Server Error : 10060 Severity: 0. An error has occurred while es

SQL Server Error : 10060 Details

SQL Server Error: 10060 Severity: 0 Event Logged or not: No Description: An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 – A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060) Severity 0 Description: Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of … Read the rest

SQL Server Error : 4155, Severity: 15. The SELECT list for the nested INSERT st

SQL Server Error : 4155 Details

SQL Server Error: 4155 Severity: 15 Event Logged or not: No Description: The SELECT list for the nested INSERT statement can only contain one item. Severity 15 Description: Indicates syntax errors in the Transact-SQL command.

Solution:

Make sure that SELECT list for the nested INSERT statement can only contain one item.

one statement for each insert statement is allowed.

SQL Server Error Code and solution summary

SQL Server Error: 4155 Severity: 15 Event Logged or not: No Description: The SELECT list for the nested INSERT statement can only contain one item.

 

Make sure that SELECT list for the nested INSERT statement can only contain one item.

one statement … Read the rest

SQL Server Error : 229, Severity: 14. The %ls permission was denied on the obj

SQL Server Error : 229 Details

SQL Server Error: 229 Severity: 14 Event Logged or not: No Description: The %ls permission was denied on the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’. Severity 14 Description: Indicates security-related errors, such as permission denied.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

 

Error 229 in Microsoft SQL … Read the rest

SQL Server Error : 208, Severity: 16. Invalid object name ‘%.*ls’.

SQL Server Error : 208 Details

SQL Server Error: 208 Severity: 16 Event Logged or not: No Description: Invalid object name ‘%.*ls’. Severity 16 Description: Indicates general errors that can be corrected by the user.

Details of Error:

When a new user attempts to explore a database, they typically use SQL Server Management Studio. When they attempt to access any object using any valid T-SQL command, they frequently receive the following error.
SQL SERVER – Database Context Error – Error 208 – Invalid Object Name dbcontext1
What most confuses users is that the object is clearly visible in the SSMS Object Explorer, but when they try to access it using valid T-SQL, they usually get an error. I’ve seen DBAs … Read the rest

SQL Server Error : 262, Severity: 16. %ls permission denied in database ‘%.*ls

SQL Server Error : 262 Details

SQL Server Error: 262 Severity: 16 Event Logged or not: No Description: %ls permission denied in database ‘%.*ls’. Severity 16 Description: Indicates general errors that can be corrected by the user.

Cause:

Sql Server error 262 is common error faced by SQ Server users when they are trying to create new database in SQL Server Management Studio. This error also appear during login on SSMS. A message is returned that states that the account does not have “sysadmin” role to SQL Server.

Another reason is that, as of SQL 2008, the local Administrators group is no longer added by default during SQL Server installation. Even adding the current user as a local administrator requires … Read the rest

SQL Server Error : 53, Severity: 0. An error has occurred while establishing

SQL Server Error : 53 Details

SQL Server Error: 53 Severity: 0 Event Logged or not: No Description: An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (.Net SqlClient Data Provider). Severity 0 Description: Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of 0 through 9.

Errors encountered

named pipes provider could not open a connection to sql server 53 microsoft sql server Read the rest

SQL Server Error : 245, Severity: 16. Conversion failed when converting the %l

SQL Server Error : 245 Details

SQL Server Error: 245 Severity: 16 Event Logged or not: No Description: Conversion failed when converting the %ls value ‘%.*ls’ to data type %ls. Severity 16 Description: Indicates general errors that can be corrected by the user.

SQL SERVER – Error: Msg 245 – Conversion failed when converting the varchar value ‘AllisWell’ to data type int

Solution for Resolving SQL Server Error 245

It’s critical that all return values be of the same data type when converting the data type. We’d wind up with conversion issues if we didn’t do this.

Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'SQlAuthority' to data type int.

The column to … Read the rest

SQL Server Error : 124, Severity: 15. CREATE PROCEDURE contains no statements.

SQL Server Error : 124 Details

SQL Server Error: 124 Severity: 15 Event Logged or not: No Description: CREATE PROCEDURE contains no statements. Severity 15 Description: Indicates syntax errors in the Transact-SQL command.

Solution:

CREATE PROCEDURE contains no statements inside it will give this error.

Make sure atleast one statement in CREATE PROCEDURE  otherwise it gives CREATE PROCEDURE contains no statements

SQL Server Error Code and solution summary

SQL Server Error: 124 Severity: 15 Event Logged or not: No Description: CREATE PROCEDURE contains no statements

Make sure atleast one statement in CREATE PROCEDURE  otherwise it gives CREATE PROCEDURE contains no statements… Read the rest