MSSQL Scriptlets

MSSQL - Find the number of rows in all of your tables.

rich@teachout.com — Thu, 03 Jul 2008 06:50:00 GMT

Just a quick way to find the number of rows in all of your tables.

MSSQL: Convert Database from SQL 2000 to SQL 2005 - best practices

rich@teachout.com — Thu, 03 Jul 2008 06:43:00 GMT

Recommended steps to migrate a database from SQL 2000 to SQL 2005

MSSQL: Get the last day of the current month

rich@teachout.com — Thu, 03 Jul 2008 06:30:00 GMT

SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))

MSSQL: Easily Load table into RAM (like you can easily do in Mysql)

rich@teachout.com — Thu, 03 Jul 2008 06:23:00 GMT

Ever wonder how to put a mssql table into RAM after it has been read?

Grant Exec to ALL Stored Procedures and Functions for ALL db_datareader users on a database..

rich@teachout.com — Wed, 02 Jul 2008 08:04:00 GMT

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!

MSSQL: Find Orphaned Users on a database

rich@teachout.com — Sat, 28 Jun 2008 03:06:00 GMT

How to Find Orphaned Users on a database use database; exec sp_change_users_login 'Report'

MSSQL: How to immediately disconnect any users on a database (single user mode)

rich@teachout.com — Sat, 28 Jun 2008 02:59:00 GMT

Ever need to immediately disconnect users on a database, such as when running a Database Restore? Here's a quick trick.

MSSQL: Transfer Users from SQL2000 Server to SQl2005 server

rich@teachout.com — Sat, 28 Jun 2008 00:14:00 GMT

Need to transfer your users from SQL2000 to SQL2005? Here's how

MSSQL: Mass Database Export for a Migration

rich@teachout.com — Fri, 27 Jun 2008 22:56:00 GMT

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..

MSSQL: SQL2005 Script a mass database restore

rich@teachout.com — Fri, 27 Jun 2008 21:54:00 GMT

Useful when transferring all databases from one SQL server to another.