How to Detect and Start a Dialogic PCI Board Under Windows 2000 Platform

How to Detect and Start a Dialogic PCI Board Under Windows 2000 Platform

How to save email animated gifs

Goto this link:

Save Embedded Pictures in Their Original Format - Outlookhelp

2005 visual studio registry fixes from SQL 2005

Chetan Chudasama's Weblog : Search Results For sql server 2005 visual studio registry

Fabulous Poems To Motivate And Inspire You To Achieve Your Dreams!

Fabulous Poems To Motivate And Inspire You To Achieve Your Dreams!: "A Creed To Live By


Don't undermine your worth by comparing
yourself with others.
It is because we are different that each of us is special.
Don't set your goals by what other people
deem important.

Only you know what is best for you.
Don't take for granted the things closest to your heart.
Cling to them as you would your life, for without them
life is meaningless.

Don't let your life slip through your fingers
by living in the past or for the future.
By living your life one day at a time,
you live all the days of your life.

Don't give up when you still have something to give.
Nothing is really over until the moment you stop trying.
Don't be afraid to admit that you are less than perfect.
It is this fragile thread that binds us to each other.
Don't be afraid to encounter risks.

It is by taking chances that we learn how to be brave.
Don't shut love out of your life by saying it's impossible to find.
The quickest way to receive love is to give love.
The fastest way to lose love is to hold it too tightly;
and the best way to keep love is to give it wings.
Don't dismiss your dreams.

To be without dreams is to be without hope;
to be without hope is to be without purpose.
Don't run through life so fast that you forget
not only where you've been, but also where you're going.
Life is not a race, but a journey to be savored
each step of the way.

~ Nancye Sims ~ "

Standard Numeric Format Strings for SQL Reporting Services

Here are the Standard Numeric Format Strings for using in MS SQL Reporting Services.

MS failed to include these with their documentation with the product.

Entering Large Time Values in Excel

Entering Large Time Values: "[h]:mm:ss"

How to Close All Files Opened by Network Clients from the Command Line

How to Close All Files Opened by Network Clients from the Command Line




Command to Close All Open Files
for /f "skip=4 tokens=1" %a in ('net files') do net files %a /close

The command works by passing the file ID elements from the list produced by the net files command to the action argument of the for command, net files file ID /close. When you use the iterative substitution (%a in this case) as part of a batch file, the substitution needs to be %%a. For the batch file version of the command, use the following syntax:

for /f "skip=4 tokens=1" %%a in ('net files') do net files %%a /close

In both cases, this command will appear to return an error because the last line of output from net files is "The Command Completed Successfully" and there is no file ID denoted as "The".

Note: The Server Service must be running in order for this command to work.

Avoiding Divide by Zero within SQL...

SELECT
myval =
case
when [denominator calculation] IN (0, NULL) then 0
else [full calculation]
end
FROM [table]


Original link here

Code sample: How to run a Sql Server DTS Job from VB .Net


Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ExecuteDTS("sqlserver", "nameofDTSJob", , )

End Sub
'Reference Microsoft DTSPackage Object Library
Public Sub ExecuteDTS(ByVal sServer As String, ByVal sPackage As String, _
Optional ByVal sUser As String = vbNullString, _
Optional ByVal sPassword As String = vbNullString)

Dim oPackage As DTS.Package2 'The DTS Package Object

' Initialize DTS Package
oPackage = New DTS.Package2

' Run DTS Package
' LoadFromSQLServer can be replaced with LoadFromRepository or
' LoadFromStorageFile depending on the storage location of the package
oPackage.LoadFromSQLServer(sServer, sUser, sPassword, _
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , , sPackage)
oPackage.Execute()

' Cleanup
oPackage = Nothing
End Sub

End Class



Turn off hidden menus on XP

Hidden menu items are a complete annoyance!! Here's how to turn them back on:

http://www.annoyances.org/exec/show/article03-100

Handling CSV Files in ADO.net, vb.net samples and tutorials

Here is a link to CSV imports:
Handling CSV Files in ADO.net, vb.net samples and tutorials: "da = New System.data.Odbc.OdbcDataAdapter('select * from [' + strFileName + ']', conn)
da.Fill(dt)"

Download details: Lookout v1.2

A good utility to search email attachments

Alex Scoble's IT Notes - A Law Firm IT Manager Blog: How to Manually Uninstall Veritas Backup Exec 9.x

This simple change will keep Windows 2000 from hiding unused start menu items

Tip #65: Stop Personalized Menus

In the Windows 2000 Start Menu, only the most recently used applications are displayed, with the rest being hidden until you hold the mouse over the little double-arrows (much like in Office 2000). To rid your system of this somewhat annoying behavour, click Start | Settings | Task Bar & Start Menu. For Windows 2000, look on the General tab. For Windows XP, click the Start Menu Tab, then Click Customize. Then uncheck the "Use Personalized Menus" box on the General tab, then click OK. Now the entire contents of the Start menu will be displayed.

How to Change the default font in Word

How to Change the default font in Word.



File/Open
Navigate to the c:\documents and settings\user name\application settings\microsoft\templates

Open the normal.dot
Change the style: Format/Styles and formatting
Right click on the Normal setting and change the font.

Save the document and exit.

Phone Format Sql Reporting Services

Here is how to format a phone number in Sql Reporting Services:

call the function below with this in an expression box: =code.CustomFormat( Fields!ContactNumber.Value)

Put this in the Custom Code dialog box:


Public Function CustomFormat(ByVal Value As String) As String

Dim FormatPhone As String
FormatPhone = Trim(Value)
IF FormatPhone <> VBNullString Then

Select Case FormatPhone.Length
Case 7
FormatPhone = FormatPhone.Insert(3, "-" )
Case 10
FormatPhone = FormatPhone.Insert(3, "-" )
FormatPhone = FormatPhone.Insert(7, "-" )
Case 12
FormatPhone = FormatPhone.Insert(3, "-" )
FormatPhone = FormatPhone.Insert(7, "-" )
Case Else
FormatPhone = ""
End Select
End If

Return FormatPhone

End Function


Thanks to the post here: http://www.sqlreportingservices.net/Ask/3647.aspx

SQL Reporting Services Service Pack 2 - Failure modifying security permissions on file C:\Program Files\...\RSTempFiles

There is nothing out there for this error, except this Italian link:

Errore durante l'installazione di Reporting Services SP2 (ma vale anche per l'SP1): "Failure modifying security permissions on file C:\Program Files\...\RSTempFiles"

Thanks to this guy's link, I figured out you need to change the ReportingService logon to a System account.

DropDownList Controls In an ASP.Net DataGrid

DropDownList Controls In an ASP.Net DataGrid: ".NET
DropDownList Controls In an ASP.Net DataGrid"

SQL Error Msg 170, Level 15

Need to set "SET QUOTED_IDENTIFIER ON"
when " are used in a query.

http://lists.ibiblio.org/pipermail/freetds/2004q2/015807.html
a