A blog with focus on technology, internet, mobile phone, IT Security, databases, open source, operating systems, Servers, news and life style

Interesting Sites

Archives

Posts Tagged ‘SQL Server Management Studio’

What’s new in Linux 2.6.36?

What’s new in Linux 2.6.36?

Tweet The new kernel version is notable because it hasn’t grown in size – yet it contains hundreds of advancements which will be obvious to end users, who don’t often notice changes in their Linux distribution’s kernel. After 80 days of development Linus Torvalds has released Linux version 2.6.36. It got the name [Continue]

How to fix creating index (Full-Text catalogs) – Error 229 (Permission denied) in SQL Server?

Tweet Symptoms: I have my development database on a SQL Server 2005 server. I enabled it for full-text catalogs and created a catalog with no issues whatsoever. When I go to create the index, however, I run through the wizard (using SQL Server Management Studio) until the last step. Upon finishing the wizard, I get the [Continue]

How to change SQL Server database collation

Tweet If you tried changing collation to from English to Turkish or other using the script as below but it will fail due to dependencies issues, You have to script them, drop them, change db collation and recreate them from script. The Collation change script: Code: ALTER DATABASE {your database} SET SINGLE_USER WITH ROLLBACK IMMEDIATE [Continue]

How to enable Full text search in SQL Server 2008

How to enable Full text search in SQL Server 2008

Tweet In this article we will describe to create Full text search in SQL Server 2008 through SQL Server management studio. To create a full-text catalog: Launch SQL Server management studio 2008 Connect to SQL Server In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text [Continue]

Microsoft SQL Server 2008 Service Pack 2 released

Microsoft SQL Server 2008 Service Pack 2 released

Microsoft SQL Server 2008 Service Pack 2 (SP2) is released and it's available for download. These packages may be used to upgrade any edition of SQL Server 2008. Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 [Continue]