Check List for SQL Server Connectivity Issue !
SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.
Error :
A...
2012-09-28
1,476 reads
MSSQLFUN
SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?
Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...
2012-09-26
1,384 reads
SQL Server || Change Batch separator
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is...
2012-09-25
2,033 reads
Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Detach & Attach…….Part 2 of 2
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
We have copied...
2012-09-21
990 reads
Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Backup & Restore…….Part 1 of 2
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
The full database...
2012-09-19
914 reads
How to log SQL Server Custom Error in Windows Event Log ?
SQL server gives an option to log custom errors in windows event log. We have 2 options of achieving this.
Option...
2012-09-17
934 reads
Surface Area Configuration tool available in SQL Server 2008 & onwards
Surface area configuration is a security measure that involves stopping or disabling unused components. Surface area configuration helps to improve security by...
2012-09-14
4,490 reads
Blogs
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Forums
Query STore and autotuning
Hello Everyone , I have an instance of SQL Server Manager on Azure with...
Find all records in a table whose values when summed up will equal another value
I have a list of transactions in a table. Each transaction has a unique...
sp_lock memory leak
I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers