By R Teachout on 4/27/2007 2:39 PM
Closes the current error log file and cycles the error log extension numbers just like a server restart. The new error log contains version and copyright information and a line indicating that the new log has been created.
MSSQL.1\MSSQL\LOG\ERRORLOGRead More » |
By R Teachout on 4/27/2007 2:36 AM
Shared servers usually have many databases belonging to different customers, and MS SQL Server Management Studio (SSMS) will display all those databases when used by a valid login to connect to SQL Server 2005. If you seek to change that default behavior, you can do so with a SQL Server 2005 configuration change.Read More » |
By R Teachout on 4/11/2007 8:17 AM
This command line tool enables an administrator to display the MAC address for one or more network adapters on a system.Read More » |
By R Teachout on 4/8/2007 6:43 PM
Javascript Zoom when Mouse Scrollwheel is used over an image...Read More » |
By R Teachout on 3/31/2007 9:32 PM
This allows you to set the permissions on all of the stored procedures (except the built-in ones) on a database.. great after a SQL RecoveryRead More » |
By R Teachout on 3/17/2007 2:09 PM
Simple 4 line script excellent for scheduled tasks to open a webpage to run some automated process (such as admin processing)Read More » |
By R Teachout on 3/5/2007 1:19 AM
Pricing for SQL Server 2005 - Retail Pricing, for Reference... this puts the monthly price of MSSQL SPLA into perspective.Read More » |
By R Teachout on 1/31/2007 1:54 AM
a tool for SQL Server 7.0/2000/2005 database administrators and developers
to generate data scripts in a valid T-SQL format which can be executed in Query Analyzer. Read More » |
By R Teachout on 1/26/2007 2:10 PM
Just to keep this aroundRead More » |
By R Teachout on 1/17/2007 2:15 PM
Great script I found online.Read More » |
By R Teachout on 1/7/2007 11:31 PM
The best Linux Web administration project!!!Read More » |
By R Teachout on 12/28/2006 1:07 PM
EXEC sp_dboption 'db_name, 'single user', 'FALSE'Read More » |
By R Teachout on 12/23/2006 2:18 PM
use dbname
execute sp_changedbowner [user]Read More » |
By R Teachout on 12/22/2006 5:10 AM
Reporting the amount of physical hard disk space used by each virtual machine.Read More » |
By R Teachout on 12/22/2006 4:59 AM
Here's a trick which solves this error:
The virtual machine could not be added. The virtual machine configuration
could not be added. A configuration with this name already exists.
When it won't display, but it DOES exist, just in a new location from where it WAS running from.Read More » |
By R Teachout on 12/11/2006 12:00 PM
Copy / synchronize directories / foldersRead More » |
By R Teachout on 12/7/2006 1:36 PM
http://aspalliance.com/1038_IISCnfgvbs__IIS_Settings_Replication
This article examines the usage of IISCnfg.vbs file (And being able to MERGE from one IIS metabase settings to another IIS metabase), with no downtime - so syncing two IIS servers settings work better.
Good link to keep around!Read More » |
By R Teachout on 12/6/2006 3:25 AM
I plan on doing this sometime soon... Read More » |
By R Teachout on 12/6/2006 2:20 AM
Have you ever needed to shrink or split a Windows Partition. If so, you'll find that there is no magical tool included with windows. Nor is there any free / open source tool that I am aware of in the Windows world. Now I'm not bashing Windows here. I spend most of my time in the Windows world. I'm just saying that I've never come across a tool for this purpose. Read More » |
By R Teachout on 12/6/2006 2:17 AM
Windows XP will not allow you to pin a shortcut to the start menu that points to a network drive. For this reason it can be necessary to write a batch file to launch a program. The issue is that a shortcut pointed to a .bat file also contains no “Pin to Start Menu” option. While it can be dragged onto the start menu, this leaves no option for scripting these shortcuts. The simple solution is to convert the .bat file to an .exe file and lucky for us Windows XP includes a tool that can do it…Read More » |
By R Teachout on 12/6/2006 2:15 AM
You gotta read this link!Read More » |
By R Teachout on 12/6/2006 1:59 AM
I've been wondering how to do this for a long time...Read More » |
By R Teachout on 12/5/2006 1:05 PM
Script to Change Properties of ALL users in an OU in Active Directory to flag the following (for when you have an admin who forgets, and in 42 days you get a lot of phone calls!!!
-User Cannot Change Password (check that box)
-User Password Doesn't expire (check that box)
(same as running dsmod user "CN=,OU=,DC=,DC=" -pwdneverexpires yes -canchpwd no)Read More » |
By R Teachout on 12/4/2006 7:50 AM
Couple of LinksRead More » |
By R Teachout on 12/4/2006 7:49 AM
AppDeploy.com's Package Knowledgebase is extremely useful when making scripts for automated software/package installation
http://www.appdeploy.com/packages Read More » |