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....

Another way to export SQL Server table data to a Text file
Why we are not able to Index content in a PDF file using Microsoft’s Indexing Service?
Not able to change Server Log-on Mode in SQL Server
How to remove yellow background from web form fields?
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

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)
<January 2009>
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

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

# Friday, January 02, 2009
Another way to export SQL Server table data to a Text file
No doubt that a DTS or SSIS package can be used to export SQL Server table data to a text file. The below article is to demonstrate another way to export SQL Server table data to a text file using xp_cmdshell extended stored procedure (This is with reference to SQL Server 2005 and above).
Read more ...
Command Line | Databases | SQL Server
Friday, January 02, 2009 2:22:02 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Friday, January 02, 2009
Why we are not able to Index content in a PDF file using Microsoft’s Indexing Service?
We have created a Indexing Catalog in Microsoft’s Indexing Service and have included the folders to be indexed. We did a merge and the restarted the Indexing Service to enable the catalog. A server side script written in ASP and/or ASP.Net is written to perform search and display the results. We are able to see results with file extensions HTML, HTM, ASP, ASPX, DOC, XLS, and PPT. There are many PDF files in the website and we are not able to see any results from PDF files.
Read more ...
IIS | Indexing Service
Friday, January 02, 2009 12:29:08 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Tuesday, December 30, 2008
Not able to change Server Log-on Mode in SQL Server
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?
Read more ...
Databases | SQL Server
Tuesday, December 30, 2008 6:11:12 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# Sunday, December 21, 2008
How to remove yellow background from web form fields?
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?
Read more ...
Internet Explorer
Sunday, December 21, 2008 2:27:28 PM (India Standard Time, UTC+05:30)
#  |  Akash Heranjal  |  Disclaimer  |  Comments [0]  |  Trackback
# 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
 
ss_blog_claim=c020e08c7a23c693b3a7d2b925279828