 |
How to test CDO email using VB Script.
|
| Total Hit (1046) |
Sometimes we need to check CDO on the server with minimum amount of time.
Following script will send an email using CDO object library. If you dont have CDO then it will throw an error.
- Create an empty file in notepad.
- Copy/Paste the following script
- Save file as CDOMailTest.vbs
- Do
....Read More |
Rating
 |
|
|
|
 |
How to configure E-Mail Subscription with SQL Reporting Services.
|
| Total Hit (769) |
When you install reporting services it will ask you for SMTP settings. If you skip those settings then probabbly when you create new subscription you will only see "file share" option.
In order to enable "Email Subscription" you need to do couple of steps.
1. open the RSReportServer.config fil
....Read More |
Rating
 |
|
|
|
SQL 2000 Install Generates PENDING FILE OPERATIONS Error
|
| Total Hit (683) |
When trying to install SQL Server 2000 on an NT machine sometimes you may receive the following error.
<font color=red><b>"A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."</b></font>
SQL Setup is
....Read More |
| Rating
|
|
 |
How to find and sort files based on creation time
|
| Total Hit (1233) |
The following code will sort file list based on CreationTime
«code LangId=2»Option Explicit On
Option Strict On
Imports System.Collections
Imports System.IO
Module Module1
Private Class CreateTimeComparer
Implements IComparer
Public Function Compare(ByVal x
....Read More |
| Rating
|
|
 |
How to auto refresh page
|
| Total Hit (2014) |
Here is the script to refresh page automatically at certain interval
«code LangId=4»
<html>
<HEAD>
<script type="text/javascript">
<!-- Begin
/*
Because this is a true refresh, you might want to put a
notice on the page that it refreshes every "X" minutes */
function reFresh()
....Read More |
Rating
 |
|
 |
IIS Resource Kit
|
| Total Hit (603) |
<b>Internet Information Services (IIS) 6.0 Resource Kit Tools</b>
The IIS 6.0 Resource Kit Tools can help you administer, secure, and manage IIS
<a href='http://www.microsoft.com/downloads/details.aspx?familyid=56fc92ee-a71a-4c73-b628-ade629c89499&displaylang=en'>http://www.microsoft.com/downl
....Read More |
| Rating
|
|
|
|
Accessing FTP servers in .NET applications
|
| Total Hit (818) |
<p>[From: "Accessing FTP servers in .NET applications",<br>
<URL:<a href="http://dotnet.mvps.org/dotnet/faqs/?id=ftp&lang=en">http://dotnet.mvps.org/dotnet/faqs/?id=ftp&lang=en</a>>]<br>
Accessing FTP servers in .NET applications<br>
Samples:<br>
<br>
How to access a File Tr
....Read More |
| Rating
|
|
|
|
How to compress files and data in VB.net
|
| Total Hit (859) |
<b>"Compressing files and data",</b><br>
<a href="http://dotnet.mvps.org/dotnet/faqs/?id=compression&lang=en">
http://dotnet.mvps.org/dotnet/faqs/?id=compression&lang=en</a><br>
<br>
Compressing files and data<br>
CAB format:<br>
Microsoft Cabinet Software Development Kit<br>
<a
....Read More |
| Rating
|
|
|
|
How to find start/end date of Previous Quarter
|
| Total Hit (861) |
«code LangId=6»declare @PrevQtrDate datetime
declare @PrevQtrStartDate datetime,@PrevQtrEndDate datetime
declare @ReportDate datetime
set @ReportDate=getdate()
set @PrevQtrDate=dateadd(q,-1,@ReportDate)
Print @PrevQtrDate
set @PrevQtrStartDate=cast(month(@PrevQtrDate) as varchar(10)) + '
....Read More |
| Rating
|
|
|
|
Displaying RTF formatted text in SQL 2005 Reporting services
|
| Total Hit (5957) |
I haven't tried this but it may be helpful to someone who is trying to display RTF formatted text on their report. Crystal Report Support RTF/HTML format but RS 2005 doesnt support. May be MS will add in the next release.
Just follow these steps:
Compile the code below it into a class
Firs
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
SQL Reporting Services with Dynamic Column Reports
|
| Total Hit (422) |
Hi all, this is the second time I am getting a task for dynamically creating reporting columns. In the first instance, I had done it by first binding the data to a DataGrid (by setting the auto-generated columns feature to true and then exporting to Excel). In the second case, the task was to genera
....Read More |
| Rating
|
|
|
|
|
|
|
|
GotDotNet User Sample: FTP Client in .NET
|
| Total Hit (472) |
This is a simple FTP protocol client component class written in C# using .NET sockets. It implements core functionality of the FTP protocol, so you can connect, change working directory, download and upload files. Masks will be added later.
|
| Rating
|
|
|
|
SSIS Script Task Variable Write Example (Using LockOneForWrite)
|
| Total Hit (548) |
I had some difficulty finding a succinct code example for how to change the value of a variable in a SQL Server 2005 SSIS Script task, so I thought I would add one here now that I think I've figured it out. (Is anyone besides me disappointed by the lack of examples in the Books Online and Help?)
....Read More |
| Rating
|
|
|
|
Bulk Edit GridView (ASP.net 2.0)
|
| Total Hit (417) |
GridView is a tremendously useful control in ASP.NET 2.0. Despite being much improved from the DataGrid of the ASP.NET 1.x era, GridView still lacks some features which always seem to be requested. This is a multipart post on how to customize GridView to add some of this missing functionality. I'
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Custom Assembly in Reporting Services
|
| Total Hit (438) |
SQL Server 2000 Reporting Services is a server-based reporting solution that can deliver interactive Web–based reports. This article describes a problem that occurs when you access a custom assembly in your Reporting Services report that does not have sufficient permissions on the resources in your
....Read More |
| Rating
|
|
|
|
Querying the SQL Server System Catalog FAQ
|
| Total Hit (284) |
Data Types
How do I find the data types of the columns of a specified table?
How do I find the LOB data types of a specified table?
How do I find the columns that depend on a specified data type?
How do I find the computed columns that depend on a specified CLR user-defined type or alias d
....Read More |
| Rating
|
|
|
|
Top Questions about the DataGrid Web Server Control
|
| Total Hit (423) |
Windows Forms versus Web Forms DataGrid Controls
Controlling Column Width, Height, and Alignment
Customizing Column Layout in Display and Edit Mode
Formatting Dates, Currency, and Other Data
Showing and Hiding Columns Dynamically
Adding Columns Dynamically
Adding New Records to a Data Source U
....Read More |
| Rating
|
|
|
|