Man Made Code




















Statistics

Total Posts: 34
This Year: 0
This Month: 0
This Week: 0
Comments: 174


RSS 2.0   SocialTwist Tell-a-Friend


Admin

Sign In

Navigation

Home
imorfus (Complete Intranet Solution)
The Alchemist - India
Mix Match Parade
Developers Logic
Speaking Dodo
Programmer's Logic
i-Vista Digital Solutions Pvt Ltd

Recent Posts


On this page....

Converting Row Data as Comma Separated String
How to clear Internet Explorer Browser History from Command Line?
How to select random rows from an SQL Table?
Row Size limitation in SQL 2000 and 2005
How to eliminate duplicate records from a database table?
CDOSYS Weird Problem – The email body contains ! symbol in-between the content
SQL Server Permissions - Fixing Orphaned Users
IIS 6 - Enabling Web Service Extensions
IIS 6 - Application Pool
IIS 6 - AspMaxRequestEntityAllowed in Metabase.XML

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)
<December 2008>
SunMonTueWedThuFriSat
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

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

 Geek Speak
 Gyan Guru

Acknowledgments

DasBlog Theme Design by: Tom Watts
E-mail: Send mail to the author(s)
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

# Saturday, December 20, 2008
Converting Row Data as Comma Separated String
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.
Read more ...
Databases | SQL Server
Saturday, December 20, 2008 10:46:47 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Friday, December 19, 2008
How to clear Internet Explorer Browser History from Command Line?
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.
Read more ...
Command Line | Internet Explorer
Friday, December 19, 2008 10:48:05 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Friday, December 19, 2008
How to select random rows from an SQL Table?
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…
Read more ...
Databases | SQL Server
Friday, December 19, 2008 10:45:52 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Wednesday, December 17, 2008
Row Size limitation in SQL 2000 and 2005
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).”
Read more ...
Databases | SQL Server
Wednesday, December 17, 2008 10:44:49 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Monday, December 15, 2008
How to eliminate duplicate records from a database table?
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...
Read more ...
Databases | SQL Server
Monday, December 15, 2008 10:43:34 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Saturday, December 13, 2008
CDOSYS Weird Problem – The email body contains ! symbol in-between the content
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.
Read more ...
CDOSYS | IIS
Saturday, December 13, 2008 10:39:03 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Wednesday, December 10, 2008
SQL Server Permissions - Fixing Orphaned Users
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.
Read more ...
Databases | SQL Server
Wednesday, December 10, 2008 10:41:28 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [2]  |  Trackback
# Thursday, December 04, 2008
IIS 6 - Enabling Web Service Extensions
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.
Read more ...
Classic ASP | IIS
Friday, December 05, 2008 1:58:11 AM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Wednesday, December 03, 2008
IIS 6 - Application Pool
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.
Read more ...
Classic ASP | IIS
Thursday, December 04, 2008 1:39:59 AM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Monday, December 01, 2008
IIS 6 - AspMaxRequestEntityAllowed in Metabase.XML
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.
Read more ...
Classic ASP | IIS
Tuesday, December 02, 2008 1:30:07 AM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
 
ss_blog_claim=c020e08c7a23c693b3a7d2b925279828