I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop. I’ve installed SQL Server 2012 and have finally got SQL Server Data Tools to show up, so that I can create SSRS reports in Visual Studio 2010. Although I’ve installed Management tools – many times – on two separate instances … Read more
How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed? 16 Answers 16
After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start / SQL Server 2008 / Configuration Tools menu. What should I do to install this tool? 12 Answers 12
I just installed SQL Server Express 2012 on my home server. I’m trying to connect to it from Visual Studio 2012 from my desktop PC, and repeatedly getting the well-known error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that … Read more
How do I auto increment the primary key in a SQL Server database table? I’ve had a look through the forum but can’t see how to do this. I’ve looked at the properties but can’t see an option. I saw an answer where you go to the Identity specification property and set it to yes … Read more
I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘myTableName’ AND COLUMN_NAME = ‘myColumnName’) How can I check if a column exists in a table of the SQL Server database? 3 32
