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 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 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 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 » |
By R Teachout on 1/7/2008 6:27 PM
EXEC sp_MSforeachtable "exec sp_spaceused '?'"Read More » |
By R Teachout on 12/31/2007 11:03 AM
Use this SQL server script from the SQL query window to rename an existing database. The script below will place the database in single user mode then rename the device and put then new device name back into multi user mode for use.Read More » |
By R Teachout on 12/12/2007 6:10 PM
Run a query against sysprocesses to figure out what is going on on a SQL ServerRead More » |
By R Teachout on 9/23/2007 3:31 PM
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)Read More » |
By R Teachout on 9/23/2007 3:20 PM
Search error log for "Return value 3" and trace to find out what you're missing, then install that, then go with it.Read More » |
By R Teachout on 6/13/2007 10:24 PM
Here's a quick how-to (for those technically inclined) on:
How to Get the Current Activity for a Single Database (SQL2000) when running as a DBO not as a sysadminRead More » |
By R Teachout on 6/3/2007 10:07 PM
Great for queries where you need > date < date results..Read More » |
By R Teachout on 5/14/2007 8:16 PM
This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or technical support provider for troubleshooting purposes. Read More » |
By R Teachout on 5/4/2007 10:08 AM
To Load from a Text File into MSSQLRead More » |
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 » |