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 » |
By R Teachout on 3/7/2008 12:03 AM
SELinux is a set of extra security restrictions on top of the normal Linux security tools. It gives the systems administrator a finer grain of control than what the kernel typically provides. But SELinux can sometimes get in your way. For example, I have had typical services, such as Apache, appear to start up correctly, but remain inaccessible from the outside world because I forgot to allow the apache user rights to open that port or maybe my distro forgot about it. Before you turn off SELinux make sure you know why you are turning it off and the security concerns you might be opening yourself up to. Read More » |
By R Teachout on 3/6/2008 5:48 PM
Linux tool to set the duplex settings on your network card.Read More » |
By R Teachout on 3/6/2008 5:19 PM
Ever had a remote SSH connection where you were doing an upgrade (say to asterisk or pbxinaflash, etc) and you lost your internet connection, which killed your ssh session, and stopped your compile, leaving your system in a horribly unusable state? NEVER AGAIN! That is what I use screen for!Read More » |
By R Teachout on 3/2/2008 1:52 PM
If you haven't already tried freepbx, you should!!Read More » |
By R Teachout on 2/26/2008 7:00 PM
Where: Historic Charleston, SC
When: February 27-29th, 2008 (and evening reception February 26th) Read More » |
By R Teachout on 1/18/2008 12:41 PM
SELECT dbid FROM master.dbo.sysdatabases WHERE name = 'database_name'Read More » |
By R Teachout on 1/15/2008 1:03 PM
Need to make a clone of a database structure, but have too many procedures/functions/tables to do it all manually?
I believe this is a good answer to that problem:Read More » |