Script(s)

technology as-is

June 11, 2008
by gchandra
5 Comments

Could not open connection to the host, on port 25: connect failed

Error Msg : Could not open connection to the host, on port 25: connect failed What does this mean ? You web application is not able to reach the SMTP Host using Port 25. Possible Reasons… 1. If Web Server … Continue reading

June 11, 2008
by gchandra
8 Comments

How to Save Column Names with Results : SQL Server 2005

Whether you are copying query output from SQL Server Management Studio or Saving result as .csv file, if you need to save the column name or column header along with result.. here is simple option you have to enable. Goto … Continue reading

June 11, 2008
by gchandra
0 comments

How to Save Query results as .CSV or Excel file using SQLServer 2005 Studio

Here is the simple way to save query results as .csv or .xls ¬†file using SqlServer Management Studio. Execute your query Example : Select * from AdventureWorks.Person.Address Right Click on Left top corner Select “Save Result As” to save as … Continue reading