Archive for October, 2009
October 8, 2009 at 19:17 · Tags: know how, sql server
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
October 1, 2009 at 16:32 · Tags: asp.net, know how, localization, resource files
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.
October 1, 2009 at 16:22 · Tags: announcement, program
“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:
- Visual Studio Professional
- Expression Studio 2 or 3 (1 user)
- Expression Web 2 or 3 (up to 2 users)
- Windows Web Server 2008 or R2 (when available)
- SQL Server 2008 Web Edition
For production use:
- Windows Web Server 2008 R2 (when available)
- 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
