Thank you Nakul, It's my mistake. Now i got it. In SQL Server 2012, Under Keyboard Menu, there are 2 sub menus. I have not seen these sub menus. But in SQL Server 2008, we have only Keyboard menu....

Hi Nakul, How to set the same settings in SQL Server 2012. UI is little bit confusing....

Hi Jacob, Thanks for your reply. In my procedure, I am already passing 32767 to "@query_result_width" parameter. So this may not be the issue....

Hi Friends,I have an issue in sending excel attachment thorugh database email (msdb.dbo.sp_send_dbmail), where a column text is more than 256 characters. The text is being truncated in excel (if more than 256) characters)Please help me to solve this iss...

Extending the Windows user experience of file searches to SQL server is a bit of a challenge because the asterisk [*] is a wild-card character in Windows whereas SQL Server uses percentage [%]. The percentage [%] is valid in a file name which adds to th...

Today i studied an interesting thing related to GO statment See in the following queries executed .***The batch preceding GO will execute the specified number of times***. create table test( id int not null identity (1, 1) primary key) g...

Today i studied an interesting thing related to GO statment See in the following queries executed .***The batch preceding GO will execute the specified number of times***. create table test( id int not null identity (1, 1) primary key) g...

Hi Nakul, Thank you for your valuable information. We don't know the exact reason. First they asked us to work on SQL Server 2012 and now downgrade to SQL 2008 R2. But the project is in development status only and we have completed nearly 7 modul...

Hi Nakul, Can we restore Sql server 2012 backup on Sql server 2008 R2 ? If not, What is the solution for this ?, Client want to demigrate from Sql server 2012 to Sql server 2008 R2....

Thank you Nakul....