By R Teachout on 7/8/2008 3:02 PM
Web Deployment Team released the Beta 1 version of the deployment tool! If you're not familiar with the tool already, it is here to help you keep sites or servers in sync with IIS6 or IIS7, as well as migrate from IIS6 to IIS7 Read More » |
By R Teachout on 7/3/2008 8:49 AM
Hate the vbs scripts that output results, and when you run them from wscript, you have to click 'OK' a few hundred times? Ensure it is running from cscript with this little bit of code. Read More » |
By R Teachout on 7/3/2008 1:50 AM
Just a quick way to find the number of rows in all of your tables. Read More » |
By R Teachout on 7/3/2008 1:43 AM
Recommended steps to migrate a database from SQL 2000 to SQL 2005 Read More » |
By R Teachout on 7/3/2008 1:30 AM
SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE()))) Read More » |
By R Teachout on 7/3/2008 1:23 AM
Ever wonder how to put a mssql table into RAM after it has been read? Read More » |
By R Teachout on 7/2/2008 3:04 AM
For years I have used a script that I had to manually add the ADO user to, and then run it on a database, take the results, and then execute them. I finally got fed up with this, so I wrote a script I could use to automatically just run after I added a Stored Procedure, Function or User to a database, and have it just fix everything.
SLICK! Read More » |
By R Teachout on 6/27/2008 10:06 PM
How to Find Orphaned Users on a database
use database; exec sp_change_users_login 'Report'Read More » |
By R Teachout on 6/27/2008 9:59 PM
Ever need to immediately disconnect users on a database, such as when running a Database Restore? Here's a quick trick. Read More » |
By R Teachout on 6/27/2008 7:14 PM
Need to transfer your users from SQL2000 to SQL2005? Here's howRead More » |
By R Teachout on 6/27/2008 5:56 PM
Useful with a combination of some other scripts I have in blog entries. I found this online, so I can't take credit for this, but I swear I at least had started the same type of script before I googled..Read More » |
By R Teachout on 6/27/2008 4:54 PM
Useful when transferring all databases from one SQL server to another.Read More » |
By R Teachout on 6/27/2008 4:46 PM
Useful when transferring all databases from one SQL server to another.Read More » |
By R Teachout on 6/24/2008 10:22 PM
(Switch between running 32-bit applications and 64-bit applications in IIS on a 64-bit version of Windows)
Also: switch between the 32-bit version of Microsoft ASP.NET 1.1 and both the 32-bit version and the 64-bit version of ASP.NET 2.0 on a 64-bit version of Microsoft Windows. Read More » |
By R Teachout on 6/24/2008 9:04 PM
Have you ever faced the problem of assigning more than 8000 characters to varchar data type or more than 4000 characters to nvarchar data type?Read More » |
By R Teachout on 6/24/2008 8:01 PM
This is actually a simple method to do it, but it is extremely effective.Read More » |
By R Teachout on 6/24/2008 7:47 PM
So, no, you do not know the 'sa' password, but…you do know that the 'sa' password will only be needed for an upgrade or something, not for ongoing connectivity, so you proffer a solution, "I will change the 'sa' password for you for long enough to complete the upgrade, and then I will need to change it back again. This is because I do not know what processes may be trying to use 'sa'".Read More » |
By R Teachout on 6/24/2008 7:46 PM
Ever have a need to disable your triggers to do some maintenance or update work?
Here's a way!Read More » |
By R Teachout on 6/16/2008 10:02 PM
Yep.. you did it.. You upgraded to SP3 for Windows XP, and now you can't configure your computer to automatically login. Here's the easiest way to fix this.Read More » |
By R Teachout on 6/6/2008 3:47 PM
This is a simple command, just many don't know about it. Here's a simple quick way to schedule a dns zone to be updated at a later time/dateRead More » |
By R Teachout on 6/6/2008 2:15 PM
I've been working this a bunch, but I have a number of sites on the same server, some running 1.1 and some 2.0, but all new sites were automatically flagged as 1.1.. and I'd prefer 2.0, so I had a development box setup to figure this out.. Now I know how can I change the default asp.net version in IIS6 on the "Web Sites Folder" ONLY without affecting the existing sites running 1.1!Read More » |
By R Teachout on 5/21/2008 7:48 PM
incredible useful little script does is generate a series of insert or update statements for the rows in a tableRead More » |
By R Teachout on 4/14/2008 1:11 PM
MSSQL Scripts to do this.. (Set Identity Insert)Read More » |
By R Teachout on 4/3/2008 3:52 PM
Just run this query, which will build a list of commands you can put into a batch file, and execute!Read More » |
By R Teachout on 3/31/2008 4:44 PM
Just a SQL Script Hack to make it easier to do a restore.
Or just a quick way to add the same username on MANY MANY (ALL) databases at once.Read More » |