Archive for October, 2009

Microsoft SQL Server Error 5030

Oct 8th

Posted by Coskun SUNALI in General

1 comment

So, if you are trying to change the collation of a database and getting error 5030, this is much likely because you cannot change the collation of a database when it is in Multi_User mode. In this case, you should try to run the following query.

-- the following line sets the database to "Single User" mode
ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-- the following line sets the new collation
ALTER DATABASE DBNAME COLLATE COLLATIONNAME
-- the following line sets the database back to "Multi User" mode
ALTER DATABASE DBNAME SET MULTI_USER

DBNAME: Database name
COLLATIONNAME: New collation’s name. E.g.: Latin1_General_CI_AI

,

The resource object with key … was not found

Oct 1st

Posted by Coskun SUNALI in General

No comments

If you ever face problems with your resources and somehow the ASP.NET application/website refuses to load them, consider checking if your website path is readable by the process owner user of the website application pool.

, , ,

Microsoft WebsiteSpark

Oct 1st

Posted by Coskun SUNALI in General

No comments

“A program that offers visibility, support and software for professional Web Developers and Designers”

Have you heard of Microsoft WebsiteSpark yet? WebsiteSpark is a global program by Microsoft to support Web Developers and Designers. If your company has 10 or fewer employees, you are eligible to enroll to the program and you will get the following opportunities, services and software for free for next 3 years!

For design, development, testing and demonstration of new websites:

  1. Visual Studio Professional
  2. Expression Studio 2 or 3 (1 user)
  3. Expression Web 2 or 3 (up to 2 users)
  4. Windows Web Server 2008 or R2 (when available)
  5. SQL Server 2008 Web Edition

For production use:

  1. Windows Web Server 2008 R2 (when available)
  2. SQL Server 2008 Web Edition

Fee: A USD $100 Program Offering Fee is due when the Web development and design company exits the Program. As part of Microsoft’s commitment to small Web development and design service companies’ long term success, there are no upfront costs for companies to join WebsiteSpark.

Only for USD $100, you get all these. Enjoy!

http://www.microsoft.com/web/websitespark/default.aspx

,