Saturday, September 13, 2008

End of Media encountered while backing up to non-removable media

I was getting this error on SBS 2003, Small Business Server 2003 when backing up to a removeable USB drive:

End of Media encountered while backing up to non-removable media.
The operation was ended.


The drive had plenty of space.

The problem was that the external drive was formatted as FAT, and all the backup files went to 4GB and then it quit, since that is the limit for FAT. The drive had to be converted to NTFS. You can use this command to convert it to NTFS:

convert e: /fs:ntfs /v

Tuesday, April 01, 2008

Keep getting "Not Enough Space On The Disk" when trying to save files to a server share? - Small Business Server

Keep getting "Not Enough Space On The Disk" when trying to save files to a server share? - Small Business Server

Getting this error message?

Unable to create the file ..... "there is not enough space on the disk"

Unfortunately, Windows Server does not give the correct error message to the user when their disk quota has been exceeded. It tells them that there is not enough space on the disk, rather than telling them that their disk quota has been exceeded.

Quotas on the partition/volume where the user shared folders are. By default it is 1 Gb per user, over the entire drive, not counting exchange,sql or sharepoint.

1. Log on to your system with an administrator account, for example,owner or administrator.

2. Click Start, and then click My Computer.

3. Right-click on the drive, and then click Properties.

4. Click the Quota tab.

5. Either increase the amount of disk space available to users bychanging the Limit disk space to option or disable the Disk Quotas featureby clicking to clear the Enable Quota management check box.

Wednesday, October 03, 2007

Wednesday, September 12, 2007

How to Set Up a Logon Script Only for Terminal Server Users

The built-in event logging for Terminal Services is lacking if you want to easily know who logged in and when. This is how you can create a log file of everyone that connects to your Terminal Server.

You can use a logon script to dump out the connecting user with the following script in the \windows\system32 directory.

Create a batch file with this line:
echo %username% %clientname% %date% %time% >> C:\TermServLog\logon.log
And enter the name of the batch file into the registry entry as follows:

Run Regedt32.exe and go to the following value: HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\CurrentVersion
\Winlogon\Appsetup

After the last entry in the Appsetup value, place a comma and a space and then enter the name and extension of the logon script you placed in the %SystemRoot%\System32 folder. For example, if the value of Appsetup is: Usrlogon.cmd, Rmvlinks.exeAfter adding an entry for Termlogon.cmd, the value would look like: Usrlogon.cmd, Rmvlinks.exe, Termlogon.cmdTermlogon.cmd will now run every time a user logs into the Terminal Server.

How to Set Up a Logon Script Only for Terminal Server Users

Tuesday, September 11, 2007

Terminal Services client keyboard shortcuts

Microsoft Windows XP - Using Terminal server shortcut keysUsing Remote Desktop Connection

Using Terminal Server shortcut keys

If you choose not to apply Windows key combinations to your Remote Desktop sessions, you can use these Terminal Server shortcut keys to perform many of the same functions. For more information about applying Windows key combinations, see To configure Windows shortcut keys in a session

Shortcut keyDescription

ALT+PAGE UP

Switches between programs from left to right.

ALT+PAGE DOWN

Switches between programs from right to left.

ALT+INSERT

Cycles through the programs in the order they were started.

ALT+HOME

Displays the Start menu.

CTRL+ALT+BREAK

Switches the client between a window and full screen.

CTRL+ALT+END

Brings up the Windows Security dialog box.

ALT+DELETE

Displays the Windows menu.

CTRL+ALT+Minus (-) symbol on the numeric keypad

Places a snapshot of the active window, within the client, on the Terminal server clipboard (provides the same functionality as pressing PrintScrn on a local computer.)

CTRL+ALT+Plus (+) symbol on the numeric keypad

Places a snapshot of the entire client window area on the Terminal server clipboard (provides the same functionality as pressing ALT+PrintScrn on a local computer.)

Note

On an NEC98, these shortcut keys are different in two cases:

CTRL+ALT+BREAK is replaced by F12.

CTRL+ALT+END is replaced by F15.

CTRL+ALT+BREAK and CTRL+ALT+END are available in all Remote Desktop Connection sessions, even when you have chosen to apply Windows key combinations on the remote computer.

Friday, September 07, 2007

Clearing the browser cache for various browsers

http://www.qgm.com/support/cache.html

Microsoft Internet Explorer


From the text menu at the top of your Internet Explorer browser window, click on VIEW
From the drop down list that appears, select and click on INTERNET OPTIONS. (If this option isn't present, click on FILE on the text menu and look for it there).

In the Options dialogue box which should appear, click on the tab at the top labeled ADVANCED.

In the area entitled "Temporary Internet Files" click on the button labeled SETTINGS.

Below the phrase "Check for newer versions of stored pages:" click the radio button labeled "Every visit to the page"

Then click on the button labeled "Empty Folder" to remove older versions already in your cache - click YES in response to the verification query.

Click OK at the bottom of the Settings dialogue box.

Click OK at the bottom of the Options dialogue box.

Revisit the page in question.

If the current page is still not displayed, hit RELOAD while holding down the SHIFT key.

After doing the above, you should be able to see the latest version of the page every time you come back.

Monday, June 18, 2007

Script SQL Server 2005 diagrams to a file

Script SQL Server 2005 diagrams to a file

Here is how to export sql server 2005 diagrams to another database:

Wednesday, April 25, 2007

ATX power supply connector pinout and signals @ pinouts.ru

Here is the pinout for an ATX power supply:


http://pinouts.ru/Power/atxpower_pinout.shtml






















Pin
Name

Color
Description
13.3V Orange+3.3 VDC
23.3V Orange+3.3 VDC
3COM BlackGround
45V Red+5 VDC
5COM BlackGround
65V Red+5 VDC
7COM BlackGround
8PWR_OK GrayPower Ok (is a status signal generated by the power supply to notify the computer that the DC operating voltages are within the ranges required for proper computer operation)
95VSB Purple+5 VDC Standby Voltage (max 10mA)
1012V Yellow+12 VDC
113.3V Orange+3.3 VDC
12-12V Blue-12 VDC
13COM BlackGround
14/PS_ON GreenPower Supply On (active low). Short this pin to GND to switch power supply ON, disconnect from GND to switch OFF.
15COM BlackGround
16COM BlackGround
17COM BlackGround
18-5V White-5 VDC
195V Red+5 VDC
205V Red+5 VDC

/PSON activated by pressing and releasing the power button while the power supply is in standby mode. Activating /PSON connects the power supply’s /PSON input to ground, thereby switching the power supply to full-on condition.

How to automatically turn on computer after power loss

Here is how to automatically turn on computer after power loss:


http://www.expresshosting.net/howto/atx-powersupply-modification-auto-turnon.html

Friday, March 23, 2007

How To Setup SQL Server Reporting Services for email delivery

Here is how to get SQL Server Reporting Services email to work:

You simply need to edit the RSreportserver.config file and enter your mail host name.

In the section; you need to alter the following two lines in the reportserver.config:

mail.yourname.com
ReportServer@yourname.com

For further information, see Microsoft's long winded version here:
Configuring a Report Server for E-Mail Delivery

Wednesday, March 07, 2007

Changing the web.config while web server is running

When an ASP.NET application launches a watch is put on the web.config file. ASP.NET will detect if the web.config changes while the application is running.

When ASP.NET detects a change it will spin up a new version of the application with the new settings in effect.

Any in process information, such as data kept in Session, Application, and Cache will be lost (assuming session state is InProc and not using a state server or database).

http://www.odetocode.com/Articles/345.aspx

Monday, January 08, 2007

Windows Vista Beta: How to dual-boot Windows XP and Windows Vista - Lifehacker

If you need to get out of Vista, and get back to XP, try this:

Windows Vista Beta: How to dual-boot Windows XP and Windows Vista - Lifehacker:

"type FIXBOOT followed by FIXMBR "

I was unable to modify the boot order and defaults from within XP. Vista uses a new system. So, if you wish to remove Vista, be very careful. Don't just blunder in from XP and remove the partition... The technique that I used was to boot off the XP CD and enter a recovery console. Then, after logging is as administrator, type FIXBOOT followed by FIXMBR and exit to reboot. It goes without saying that you should be sure that you have a backup before doing this. You do, don't you? This will get you back to your original XP boot process.

Thursday, September 14, 2006

How to access control in FormView

How to access control in FormView: "TextBox DataTitle = (TextBox)DataSourceItemView.FindControl('DataTitle');"




=================
protected void FormView1_ItemCreated(object sender, EventArgs e)
{
if (FormView1.CurrentMode == FormViewMode.Insert)
{
TextBox txtName =
FormView1.Row.FindControl("CategoryNameTextBox") as TextBox;

txtName.Text = "New Name...";
}

}
==================

Thursday, August 10, 2006

Richard Dudley : The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

Richard Dudley : The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] ): "The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] ) "

I think this is mainly a connection problem. Be sure to stop the Visual Studio Web server in the tool tray.

Wednesday, August 09, 2006

Error: Failed to generate a user instance of SQL Server... | differentpla.net

Error: Failed to generate a user instance of SQL Server... differentpla.net: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."

Thursday, July 27, 2006

Clear the List of URLs That Appear in the Internet Explorer Address Bar

How Can I Clear the List of URLs That Appear in the Internet Explorer Address Bar?
Q
Hey, Scripting Guy! How can I clear the list of URLs that appear in the Internet Explorer address bar?
-- GA
A
Hey, GA. You know, if you’ve ever pondered the question, “What is it that makes the Scripting Guys different from other Microsoft employees?” well, we can save you some time and trouble by just giving you the answer: the Scripting Guys are dumber than other Microsoft employees. For example, it turns out that the list of URLs that appear in the Internet Explorer address bar drop-down list are stored in the registry; to be more specific, they are stored in this registry key:HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\TypedURLs


Hey, Scripting Guy!

Tuesday, July 18, 2006

BET: Excel - Functions User Defined - REVERSE

BET: Excel - Functions User Defined - REVERSE: "Returns the contents of a cell with all the characters reversed."

Chris Hays's Reporting Services Sleazy Hacks Weblog

Here is how to create a green bar alternating line color in Microsoft Reporting Services:


Chris Hays's Reporting Services Sleazy Hacks Weblog

Wednesday, July 12, 2006

Free - Reporting on Hierarchical Recursive data using MS Reporting Services - ColdFusion Development - CFzone.NET

Here is how to do a reporting services in C#:

Free - Reporting on Hierarchical Recursive data using MS Reporting Services - ColdFusion Development - CFzone.NET


private void Form1_Load(object sender, EventArgs e)
{
//declare connection string
string cnString = @"Data Source=(local);Initial Catalog=northwind;" + "User Id=northwind;Password=northwind";
//use following if you use standard security
//string cnString = @"Data Source=(local);Initial
//Catalog=northwind; Integrated Security=SSPI";
//declare Connection, command and other related objects
SqlConnection conReport = new SqlConnection(cnString);
SqlCommand cmdReport = new SqlCommand();
SqlDataReader drReport;
DataSet dsReport = new dsEmployee();
try
{
//open connection
conReport.Open();
//prepare connection object to get the data through reader and
// populate into dataset
cmdReport.CommandType = CommandType.Text;
cmdReport.Connection = conReport;
cmdReport.CommandText = "Select FirstName + ' ' + Lastname AS
EmployeeName, EmployeeID, ReportsTo From Employees";
//read data from command object
drReport = cmdReport.ExecuteReader();
//new cool thing with ADO.NET... load data directly from reader
// to dataset
dsReport.Tables[0].Load(drReport);
//close reader and connection
drReport.Close();
conReport.Close();
//provide local report information to viewer
reportViewer.LocalReport.ReportEmbeddedResource =
"RecursiveData.rptRecursiveData.rdlc";
//prepare report data source
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsEmployee_dtEmployee";
rds.Value = dsReport.Tables[0];
reportViewer.LocalReport.DataSources.Add(rds);
//load report viewer
reportViewer.RefreshReport();
}
catch (Exception ex)
{
//display generic error message back to user
MessageBox.Show(ex.Message);
}
finally
{
//check if connection is still open then attempt to close it
if (conReport.State == ConnectionState.Open)
{
conReport.Close();
}
}
}

Thursday, July 06, 2006

The Bumpy Blog : IsNumeric in C#, WHY NOT?

Here is how to do a "IsNumeric in C#":


using System.Text.RegularExpressions;

static bool IsNumeric(string inputString)
{ return Regex.IsMatch(inputString, "^[0-9]+$"); }



I found it here:
The Bumpy Blog : IsNumeric in C#, WHY NOT?: "static bool IsNumeric(string inputString)
{
return Regex.IsMatch(inputString, '^[0-9]+$');
}"

Wednesday, June 07, 2006

Is a Temporary Table Really Necessary?

Is a Temporary Table Really Necessary?

Shows how to do looping in SQL.

WHILE @lngLoopCount <> 0BEGIN
SET @strTabName = (SELECT strTableName FROM #tTables WHERE numID = @lngLoopCount)
EXEC sp_spaceused @strTabName
SET @lngLoopCount = @lngLoopCount - 1END

Tuesday, June 06, 2006

Unskilled and Unaware of It: How Difficulties in Recognizing One's Own

Unskilled and Unaware of It: How Difficulties in Recognizing One's Own
Incompetence Lead to Inflated Self-Assessments

http://www.apa.org/journals/features/psp7761121.pdf

Monday, March 13, 2006

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 ~ "

Thursday, January 19, 2006

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.

Thursday, January 12, 2006

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.

Thursday, November 17, 2005

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

Thursday, November 03, 2005

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

Wednesday, October 26, 2005

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

Thursday, October 06, 2005

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.

Thursday, September 22, 2005

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

Friday, September 02, 2005

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.

Thursday, August 25, 2005

Wednesday, August 24, 2005

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

Monday, August 22, 2005

Spooler error event id: 7031

Problem: The printer spooler on Windows 2000 server is stopping itself, creating error: Spooler error event id: 7031

Resolution: There were some strange printers showing up in the registry entry below. I deleted them and it fixed the problem.

http://www.windowsbbs.com/showthread.php?t=37799



You may want to check the following registry key for any printers that should not be installed.
HKLM\System\CurrentControlSet\Control\Print\Printe rs
(I have no idea why a space character is appearing in the word "Printers"!)

I had a very similar issue (except this was on a Citrix Metaframe server) and it turns out that there was a print device listed there which was autocreated from a client printer and never purged. I think there was something invalid in that registry entry because as soon as I deleted it, the spooler service worked fine.

Good Luck.
-Dman33

Friday, June 03, 2005

How to: Sql reporting services create subtotals for a matrix

Welcome to the MSDN Library: "Sorting
You can sort data within a matrix by any expression. To view instructions about sorting, click the following topic:
How to add sorting to a matrix (Report Designer)


Adding Subtotals

To add a subtotal to a matrix, add a subtotal to an individual group within the matrix. Groups do not have subtotals by default. To add a subtotal to a group, right-click the group column or row header and then click Subtotal. This will open a new header for the subtotal. Reporting Services will calculate the subtotal based on the aggregate in the data cell for the group.
For information about aggregate functions, see Aggregate Functions.
Displaying Data on Either Side of Row Headers
You are not limited to displaying row headers on the side of the matrix. You can move the row headers inward, so that columns of data appear before the row headers. To do this, modify the GroupsBeforeRowHeaders property for the matrix. You can access this property through the Properties window or the General tab of the Matrix Properties dialog box. The value for this property is an integer; a value of 2 will display two groups of matrix data before displaying the column containing the row headers."

Thursday, May 26, 2005

Remote Desktop Connection error: "you do not have access to log on to this session"

Remote Administration of Terminal Services by Non-Administrators Accounts

1. Click Start, point to Programs, point to Administrative Tools, and then click Terminal Services Configuration.
2. in the tree in the left pane, click Connections.
3. Click the RDP-TCP connection in the right pane, and then click Properties on the Action menu.
4. Click the Permissions tab.

NOTE: Only Administrator and System accounts appear.
5. Click Add. Search for the groups or users that are appropriate for your Terminal Services management (such as the Server Operators group). Click Add to place them in the bottom pane. Click OK.

NOTE: The Server Operators group appears in the RDP-TCP properties; the permissions in the bottom pane are not enough to manage the server because only Guest Access is selected by default.
6. Click to select the User Access check box for basic tasks or both the User Access and Full Control check boxes to fully manage the server, and then click Apply.
7. Click OK.
8. Test by logging on the accounts in the Server Operators group.

Friday, May 20, 2005

Apostate Caf� VB format() function - formatting symbols

Apostate Caf� VB format() function: "r"

SQL Server Reporting services Phone Format function

Phone Format: "'Returns formatted Phone Number
Public Function CustomFormat(ByVal Value As String) As String
Dim FormatPhone As String
FormatPhone = Value
Select Case Value.Length
Case 7
FormatPhone = Value.Substring(0, 3) & '-' & Value.Substring(3, 4)
Case 10
FormatPhone = '(' & (Value.Substring(0, 3) & ') ' & Value.Substring(3, 3) & '-' & Value.Substring(6, 4))
Case 12
FormatPhone = ('(' & Value.Substring(0, 3) & ') ' & Value.Substring(4, 3) & '-' & Value.Substring(8, 4))
End Select
Return FormatPhone
End Function"

Custom Numeric Format Strings - Phone number format

Custom Numeric Format Strings: "myDouble.ToString( '(###) ### - ####' )"

Monday, April 11, 2005

Good example of vbscript window.open syntax

Web Page Programming: ActiveX and VBScript: "you rarely have to mention the Window object directly. For example, the statements Window.name and name are equivalent. This section examines some common "

Good example of vbscript window.open syntax

Wednesday, March 23, 2005

Page Hijack Exploit: 302, redirects and Google

Page Hijack Exploit: 302, redirects and Google: "racked this and related problems with the search engines literally for years. If there was something that you could easily do to fix it as a webmaster, I would have published it a long time ago. That said; the points listed below will most likely make your pages harder to hijack. I will and can not promise immunity, though, and I specifically don't want to spread false hopes by promising that these will help you once a hijack has already taken place. On the other hand, once hijacked you will lose nothing by trying them.
Always redirect your 'non-www' domain (example.com) to the www version (www.example.com) - or the other way round (I personally prefer non-www domains, but that's just because it appeals to my personal sense of convenience). The direction is not important. It is important that you do it with a 301 redirect and not a 302, as the 302 is the one leading to duplicate pages. If you use the Apache web server, the way to do this is to insert the following in your root '.htaccess' file:"

Tuesday, March 08, 2005

sqlclient.sqlexception incorrect syntax parameter near ?

the sqlclient does not accept '?' as a parameter, you must use '@' instead.

Wednesday, March 02, 2005

ABC News: Getting Sick on an Ocean Cruise

ABC News: Getting Sick on an Ocean Cruise: "Margolin, a leading microbiologist and viral expert at the University of New Hampshire who consults for the government, told ABC News he thinks such stains are not uncommon on cruise ships or in hotels and motels. 'I think what's new is that we have new ways of detecting it so that we now know that it really exists,' he said. "

Monday, February 28, 2005

Server Application Unavailable

Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.


I had to uninstall VS 2005 Beta before it would work again.

Monday, February 21, 2005

Microsoft Office Assistance: ASCII character chart

Microsoft Office Assistance: ASCII character chart

Remove unwanted line breaks from data

Remove unwanted line breaks from data: "Sub CarriageBegone()
Dim rng As Range
For Each rng In Selection
rng.Replace vbLf, ', '
rng.Replace vbCr, ', '
Next rng
Set rng = Nothing
End Sub "

Tuesday, February 01, 2005


farm Posted by Hello

VNC disable tray icon

ImageShack� - Hosting: "Thanks to ImageShack for [URL=http://www.imageshack.us]Free Image Hosting[/URL]"

Change default Word font

Change the Normal template (Normal.dot)

The Normal template (Normal template: A global template that you can use for any type of document. You can modify this template to change the default document formatting or content.) opens whenever you start Word, and it includes default styles, AutoText, macros, toolbars, and other customizations that determine the basic look of your document.

On the File menu, click Open, and then navigate to

C:\Documents and Settings\user name\Application Data\Microsoft\Templates.
If no templates are listed in the Open dialog box, click the arrow next to the Files of type box, and then click Document Templates.

Double-click the Normal.dot file to open it. To be certain that you're working in the default template, check to see that Normal.dot appears in the Word title bar.
Make any changes you want, using the menus and dialog boxes just as you would to change default settings for a document, but remember that any changes you make to Normal.dot will be applied to documents that you create in the future.
When you have finished, on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), click Save .
Note If Normal.dot is renamed, damaged, or moved, Word automatically creates a new version (which uses the original default settings) the next time that you start Word. The new version will not include any customizations you made to the version that you renamed or moved.

Thursday, January 20, 2005

Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats

http://www.databasejournal.com/features/mssql/article.php/2197931


Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats: "PRINT '1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>' +
CONVERT(CHAR(19),GETDATE())
PRINT '2) HERE IS MM-DD-YY FORMAT ==>' +
CONVERT(CHAR(8),GETDATE(),10)
PRINT '3) HERE IS MM-DD-YYYY FORMAT ==>' +
CONVERT(CHAR(10),GETDATE(),110)
PRINT '4) HERE IS DD MON YYYY FORMAT ==>' +
CONVERT(CHAR(11),GETDATE(),106)
PRINT '5) HERE IS DD MON YY FORMAT ==>' +
CONVERT(CHAR(9),GETDATE(),6)
PRINT '6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>' +
CONVERT(CHAR(24),GETDATE(),113)

Here is the output from the above script:
1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>Feb 5 2003 5:54AM
2) HERE IS MM-DD-YY FORMAT ==>02-05-03
3) HERE IS MM-DD-YYYY FORMAT ==>02-05-2003
4) HERE IS DD MON YYYY FORMAT ==>05 Feb 2003
5) HERE IS DD MON YY FORMAT ==>05 Feb 03
6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>05 Feb 2003 05:54:39:567"

Searching date, time data in SQL Server 2000 :

Searching date, time data in SQL Server 2000 : Narayana Vyas Kondreddi's home page

Tuesday, January 18, 2005

4GuysFromRolla.com - Data Shaping

4GuysFromRolla.com - Data Shaping

OOP in .NET: the How and Why

OOP in .NET: the How and Why: "when they are not appropriate. The fact is that there are few if any situations where you could not use OOP to good advantage. After all, any code that you could use outside of an object can also be placed within a class. It does take a bit of time to adjust to the OOP mindset so that you start thinking in terms of classes and objects as soon as you start planning a program. As you plan, think of the program's functionality in terms of both data storage and actions, and you'll start to see some of the data units and tasks that are naturals for encapsulation in a class. "

Comcast to raise broadband speed | CNET News.com

Comcast to raise broadband speed | CNET News.com: "Comcast to raise broadband speed"

ABC News: Krispy Kreme Board Ousts Top Executive

ABC News: Krispy Kreme Board Ousts Top Executive

Disaster Looms for Megacities, UN Official Says...

http://news.yahoo.com/news?tmpl=story&cid=571&u=/nm/20050118/hl_nm/disasters_cities_dc_1&printer=1