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 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 the instance name is correct and that SQL Server … Continue reading
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 is sharing a problem with Sp_Helptext. He is considering it as a Bug. Try to rename any procedure in your database by right click. Then modify it. SSMS will show changed name. But when … Continue reading
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 a keyword or command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code. Customizing Changing the Batch separator in SSMS Steps to customize the batch separator in SSMS: Launch SSMS Go … Continue reading
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 the database from SQL Server 2005 having MDF, LDF & full-text catalog that is required for upgrading & importing a SQL Server 2005 full-text catalog into SQL Server 2012. Database files from SQL Server … Continue reading
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 backup will include the full-text catalog is required for upgrading & importing a SQL Server 2005 full-text catalog. Backup from SQL Server 2005 When the database is restored on SQL Server 2012, a new … Continue reading