StatisticsTotal Posts: 34
This Year: 0
This Month: 0
This Week: 0
Comments: 174
Admin
Sign In
Navigation
Recent Posts
On this page....
Archives
Full Archives By Category
2007 Calendar View
| November, 2009 (1) |
| August, 2009 (1) |
| July, 2009 (1) |
| June, 2009 (1) |
| May, 2009 (2) |
| April, 2009 (1) |
| March, 2009 (2) |
| February, 2009 (5) |
| January, 2009 (6) |
| December, 2008 (12) |
| November, 2008 (2) |
| | Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|
| 29 | 30 | 31 | 1 | 2 | 3 | 4 | | 5 | 6 | 7 | 8 | 9 | 10 | 11 | | 12 | 13 | 14 | 15 | 16 | 17 | 18 | | 19 | 20 | 21 | 22 | 23 | 24 | 25 | | 26 | 27 | 28 | 29 | 30 | 1 | 2 | | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Categories
CDOSYS (1) Classic ASP (10) Command Line (2) Databases (16) Excel (1) HTML (1) IIS (10) Indexing Service (1) Internet Explorer (7) Media Streaming (1) MS.Net (2) SQA (7) SQL Server (16) Windows OS (2)
Blogroll - Fav Blogs
Acknowledgments
DasBlog Theme Design by: Tom Watts
E-mail: 
Theme Image by: dreamLogic
Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
|
Technology Blog
 Tuesday, December 30, 2008
The SQL Server was installed with “Windows Only” log-on mode. We have logged-in as admin and try to change the log-on mode using server registration property to Mixed Mode (SQL Server and Windows). When we apply the setting and revisit the registration property, the change is not applied. How do we change the logon mode to Mixed mode?
Sunday, December 21, 2008
Some of us may be wondering as why few fields in the web form have a yellow background. Amazingly your colleague’s computer shows all web form fields normal (the way it should look). Well it’s clear that the web form HTML and CSS is proper, the question left is what is causing it to happen?
Saturday, December 20, 2008
One of my office mate Ranjan did some research on internet and found a simple and quick solution to have row data as comma separated string.
Friday, December 19, 2008
Is it possible to clear Internet Explorer Browser History from Command Line? The answer is yes, very much. You can opt to write a batch file with the set of commands discussed below. To check and use these commands, open the command prompt and copy/paste the command; and press enter to execute it.
Friday, December 19, 2008
IN SQL Server, it is easy to select one random record or a sequence of random records from a database table. For example if you have requirement to pick a single quiz winner randomly from the database table or you are making an online test application and need to pick X number of questions randomly from the database table; you can certainly use the below SQL queries…
Wednesday, December 17, 2008
IN SQL Server 2000 and 2005, while creating a table it is possible to create as many number of columns with VARCHAR data type of size 8000. If you are using Query analyzer, you may notice a warning message reading… “Table has been created but its maximum row size (NumberofBytes) exceeds the maximum number of bytes per row (8060).”
Monday, December 15, 2008
This is a general problem faced by a maintenance team. While importing/exporting data to/from/between databases, the PK is removed accidentally and the table now has lots of duplicate records. The big question for the support staff is how to clean the database? It's simple...
Saturday, December 13, 2008
The code is simple and straight. The code builds HTML email and uses CDOSYS object to send the email to recipients. Logic is simple, build an HTML mailer string in a VBScript variable myMailBody. Assign the variable myMailBody to the HTML Body of the email using CDOSYS object and send the mailer to recipients. But the problem starts here… When the recipient views the mailer, S/He can see an ! symbol in-between the mailer content.
Wednesday, December 10, 2008
The database backup is taken from the development environment and the BAK file is restored on the production server. On restoring the database from the BAK file, the database users with DB Owner rights are also restored along with the database. But checking the security >> user list in SQL server does not display these users. The SQL server does not allow deleting the users from the database manually as they own objects in the DB. SQL Server does not allow creating the DB user and assign DB Owner rights for the user to the restored DB.
Thursday, December 04, 2008
To help minimize the attack surface of the server, IIS 6.0 is not installed on Windows Server 2003 by default. When you first install IIS 6.0, it is locked down — which means that only request handling for static Web pages is enabled, and only the World Wide Web Publishing Service (WWW service) is installed. None of the features that sit on top of IIS are turned on, including ASP, ASP.NET, CGI scripting, FrontPage® 2002 Server Extensions from Microsoft, and WebDAV publishing.
Wednesday, December 03, 2008
Application Pool is a new feature introduced in IIS 6. An Application Pool can contain one or more applications and allows us to configure a level of isolation between different Web applications. If you want to isolate all the Web applications running in the same computer, you can do this by creating a separate application pool for every Web application and placing them in their corresponding application pool. Because each application pool runs in its own worker process, errors in one application pool will not affect the applications running in other application pools.
Monday, December 01, 2008
The AspMaxRequestEntityAllowed property specifies the maximum number of bytes allowed in the entity body of an ASP request. If a Content-Length header is present and specifies an amount of data greater than the value of AspMaxRequestEntityAllowed, IIS returns a 403 error response. This property is related in function to MaxRequestEntityAllowed, but is specific to ASP request. The default value of this property in IIS6 is 200 KB.
|