Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.
2019-06-18
Come see Brad McGehee, Grant Fritchey, Steve Jones, and more SQL Server speakers at the SQL Server Connections conference in Las Vegas this spring. Get away from the cold on Mar 26, 2011 and learn about the new version of SQL Server.
2012-02-09 (first published: 2012-01-25)
4,069 reads
On Mar 26-29 in Las Vegas, the DevConnections conference is hosting a launch of SQL Server 2012. Come to the conference and learn more at the SQLServerCentral track.
2012-03-08 (first published: 2012-01-18)
4,386 reads
This script will be useful to quickly check incase of any blocking or log wait occurs
2011-12-30 (first published: 2011-12-05)
1,512 reads
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Hi everyone I am looking at the size of my db on disk (ie...
Comments posted to this topic are about the item Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers