Arun Kumar Sabat

Thursday, October 20, 2011

Enbale FileStream in Sql Server 2008 from Sql Server Management Studio

Use following command to enable filestream in Sql Server.

Use Master
Go
/*0 = FILESTREAM disabled
1 = FILESTREAM for TSQL enabled
2 = FILESTREAM for TSQL and WIN32 streaming enabled*/
EXEC sp_configure 'filestream access level', 2
Go
RECONFIGURE
Go

Monday, August 29, 2011

Resolved Creating Database Diagram In Sql Server 2008 Express

While creating database diagram in Sql Server 2008, we may get the following error.

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

We need to following steps to resolve this issue.

In SQL Server Management Studio do the following:

1. Right Click on your database, go to properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
4. Goto the Files Page
5. Enter "sa" in the owner textbox.
6. press OK

Steps 2 and 3 are optional. With out these steps also I was able to create DB diagram in Sql Server 2008.

Saturday, June 25, 2011

A stupid bug in IE, that killed our 10 hours.

A stupid bug in IE that killed our 10hours. I told our, that is 5 developers each 2 hours we spent to resolve a issue.

A stylesheet class, because of which IE 8, was automatically redirecting to compatibility mode.

The class is

#BKWords { margin-top: 8px; max-height: 75px; overflow:scroll; }

Above css will not work in IE 8 and will redirect/reload to compatibility mode.

This is an issue in IE8. If you give the style as max-height and overflow scroll, IE8 will redirect automatically to compatibility view. For this we have to give overflow as auto.

Reference:
http://stackoverflow.com/questions/7707/ie8-overflowauto-with-max-height

AnkhSVN add-on a nice Subversion Support for Visual Studio

As all we know SVN is a nice and free source safe tool.

Similarly I was searching a free add in to Integrate SVN and Visual Studio.

AnkhSVN is a nice add on for subversion integration for Visual Studio. Best part is its free. I have seen VisualSVN, but that is licensed. We can visit the following URL and download AnkhSVN.

http://ankhsvn.open.collab.net/