Home » 2012 » October

Monthly Archives: October 2012

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 2012.

Those who are facing severe issues with their environment, they can plan to test CU4 in test environment & then move to Production after satisfactory results.

To other, I suggest to wait for SP1 final release to deploy on your production environment, to have consolidate build.

Cumulative update package 4 for SQL Server 2012 is available:http://support.microsoft.com/kb/2758687

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)

)

–Insert “Hello World” in diffrent language

INSERT INTO TBL_LANG

VALUES (‘English’,N’Hello World’)

INSERT INTO TBL_LANG

VALUES (‘Hindi’,N’हैलो दुनिया’)

INSERT INTO TBL_LANG

VALUES (‘Chines’,N’你好世界’)

INSERT INTO TBL_LANG

VALUES (‘Urdu’,N’ہیلو دنیا’)

–View Table data

SELECT * FROM TBL_LANG

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 database from Management Studio and SSMS will try to find the FTS catalogs

a. This step will fail and it will prompt you to find the location of FTS catalog. Click “Yes”

b. Choose the FTS Catalog path and Click “OK” (You may have more than 1 catalog file that you need to select one by one)

4. You have done, check database is working fine or not

SQL Server 2012 SP1 CTP4 Is Now Available !


Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.

Microsoft has recently released SQL Server 2012 SP1 CTP4. CTP stands for Community Technology Preview and it is not the final version yet. The SQL Server 2012 SP1 CTP release is available for testing purposes and use on non-production environments.

Please wait for SP1 final release to deploy on your production environment.

The following highlights a few key enhancements in CTP4:

  • Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade
  • Selective XML Index
  • DBCC SHOW_STATISTICS works with SELECT permission
  • New function returns statistics properties
  • SSMS Complete in Express
  • Slipstream Full Installation
  • New Management Object Support Added for Resource Governor DDL

SQL Server 2012 SP1 CTP4: http://go.microsoft.com/fwlink/?LinkID=257796

SQL Server 2012 SP1 CTP4 Express: http://go.microsoft.com/fwlink/?LinkID=257783

SQL Server 2012 SP1 CTP4 Feature Pack: http://go.microsoft.com/fwlink/?LinkID=263965

Detailed list of improvements and fixes : http://msdn.microsoft.com/en-us/library/bb500435

SQL Server 2012 CU3 Is Now Available !


The 3rd cumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update 3 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 2012. This build number of this cumulative update package is 11.0.2332.0

Those who are facing severe issues with their environment, they can plan to test CU3 in test environment & then move to Production after satisfactory results.

To other, I suggest to wait for SP1 final release to deploy on your production environment, to have consolidate build.

Cumulative update package 3 for SQL Server 2012 is available:http://support.microsoft.com/kb/2723749

How to avoid windows REBOOT after any operation required restart ?


Issue :

Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different names & versions, that I have created for different purpose & not required now.

I start uninstallation of SQL server but after one uninstallation, second uninstallation gives errors of “Restart Computer”.

It’s very difficult to restart computer again & again when you are doing several things in parallel.

Resolution :

Here, I go for shortcut. I have changed the registry value of current session manager to avoid reboot.

Go to Registry Location : HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSessionManager & Clear the entry of string PendingFileRenameOperations.

After change, I click on rerun to check status again for uninstallation & it works.

Note :

1) Its recommended to reboot system, whenever required.

2) Please be careful, while doing any changes to registry.

Follow

Get every new post delivered to your Inbox.

Join 248 other followers