 |
How to test CDO email using VB Script.
|
| Total Hit (1218) |
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 (960) |
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 (812) |
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
|
|
 |
Accessing FTP servers in .NET applications
|
| Total Hit (1046) |
<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 find and sort files based on creation time
|
| Total Hit (1744) |
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 (2476) |
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
 |
|
|
|
Displaying RTF formatted text in SQL 2005 Reporting services
|
| Total Hit (8759) |
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
 |
|
|
|
|
|
|
|
|
|
Reusable function to open form by name
|
| Total Hit (624) |
«code LangId=2»Private Sub showForm(ByVal frmName As String)
Dim frm As Form
frm = AppDomain.CurrentDomain.CreateInstanceAndUnwrap( _
Me.GetType.Assembly.GetName.Name, _
System.String.Concat(Me.GetType.Assembly.GetName.Name, ".", frmName) _
)
frm.Show()
End
....Read More |
| Rating
|
|
|
|
|
|
|
|
SQL Server Reprting Services (SSRS) Report Design Tips and Tricks
|
| Total Hit (1251) |
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is f
....Read More |
| Rating
|
|
|
|
How to create Format File using BCP command
|
| Total Hit (5243) |
When you bulk import into a SQL Server table or bulk export data from a table, you can use a format file to store format information for each field in a data file relative to that table. A format file provides a flexible system for writing data files that requires little or no editing to comply with
....Read More |
Rating
 |
|
|
|
Writing Provider-Independent Data Access Code with ADO.NET 2.0
|
| Total Hit (348) |
When you need to write an application that allows users to select the database provider, the application code itself needs to be completely provider-independent. ADO.NET 2.0 helps you create and deliver database applications even when you don't know what database your clients are using.
....Read More |
| Rating
|
|
|
|
Scanning the network for SQL Server for a range of IP addresses
|
| Total Hit (366) |
In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network for a range of IP addresses to find which boxes have SQL Server instances installed. The OSQL
....Read More |
| Rating
|
|
|
|
The implementation of Flags using bitwise operators
|
| Total Hit (341) |
Bitwise operators give you the ability to store multiple settings in a single primitive data type (e.g. an integer). This is useful when a single item has potentially more than one setting of the same type. For example, a message box could have an Ok button, a Cancel button, a Retry button or any co
....Read More |
| Rating
|
|
|
|
SSIS Script Task Variable Write Example (Using LockOneForWrite)
|
| Total Hit (673) |
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 (458) |
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
|
|
|
|
|
|
|
|
SQL Reporting Services with Dynamic Column Reports
|
| Total Hit (455) |
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 (499) |
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
|
|
|
|
|
|
|
|
Custom Assembly in Reporting Services
|
| Total Hit (465) |
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 (311) |
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 (446) |
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
|
|