Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

SQL Server : Take offline database

EXEC sp_dboption N’mydb’, N’offline’, N’true’\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK AFTER 30 SECONDS\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK IMMEDIATE

\r\n

\r\n

Using the alter database statement (SQL Server 2k and beyond) is the preferred method.

\r\n

The rollback after statement will force currently executing statements to rollback after N seconds.

\r\n

The […]

What’s new in Linux 2.6.36?

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. \r\n\r\n

After 80 days of development Linus Torvalds has released Linux version 2.6.36. It got the name “Flesh-Eating Bats […]

How to attach a SQL Server data file MDF without LDF

To attach a MDF without LDF you can follow the steps below:\r\n

\r\n

1. Create a new database with the same name and same database (i.e. mydatabase) MDF and LDF filesÂ

\r\n

(i.e. mydatabase_data.mdf and mydatabase_log.ldf).\r\n

\r\n

2. Stop SQL server and change the name of new MDF (i.e. mydatabase.mdf to mydatabase-new.mdf) andÂ

\r\n

copy […]

Solving ReportViewer Rendering Issue on IIS7

Solving ReportViewer Rendering Issue on IIS7\r\n\r\n\r\n\r\nApplies to:\r\n

\r\n

Internet Information Services 7.0 (IIS7)

\r\n

Microsoft Report Viewer Redistributable 2005

\r\n

\r\nSymptoms:\r\n

\r\n

Unable to render ReportViewer on ASP.NET Web pages while running on IIS7.

\r\n

You have no problem viewing your reports when running on debug mode with your Visual Studio […]

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

Symptoms:\r\nI 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 following […]

How to change SQL Server database collation

\r\n

\r\n

\r\n\r\nIf 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.\r\n\r\nThe Collation change script:\r\n

\r\n

Code:

\r\n

ALTER DATABASE {your database} SET SINGLE_USER WITH […]

How to enable Full text search in SQL Server 2008

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:\r\n

\r\n

Launch SQL Server management studio 2008

\r\n

Connect to SQL Server

\r\n

In Object Explorer, expand the server, expand Databases, and expand the database in which […]

Page 1 of 212