Home » Articles posted by rohitmssqlfun (Page 50)
Author Archives: rohitmssqlfun
Come Back From vacations…..
Hey Friends I missed you so much in my vacations. I come back from my leaves & hope now we have regular interactions.
SQL Server 2012 CU4 Is Now Available !
The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the SQL Server 2012 hotfixes which have been available since the initial release of SQL Server 2012. This update contains hotfixes for issues that were fixed after the release of SQL Server … Continue reading
Multilanguage Table, How to insert different language text in table ?
Issue : Today, I received one request from my old friend. He wants to insert text in different languages in table. He is looking to create Multilanguage table. Solution : The simplest solution is to insert data in table as NVARCHAR data type, like below. –Create Table CREATE TABLE TBL_LANG ( LNAME VARCHAR(50), LTXT NVARCHAR(100) … Continue reading
IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM
Dear Friends Firstly, I want to say thanks for your support & liking my blogs that make it possible. I like to share this good news that http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM. Website Link – http://MSSQLFUN.COM RSS Feed – http://mssqlfun.com/feed Note : Old links will keep working, no change required. Thanks Rohit Garg
How to move the FullText catalog with SQL Server 2005 ?
4 simple steps to move FullText catalog with SQL Server 2005 :- 1. Detach the database which contains the FullText Catalog. While detaching from Management Studio, there is “check box” called “Keep FullText Catalogs”. Make sure that this is selected. 2. Move the catalog files to the location where you want them. 3. Attach the … Continue reading