I was migrating some databases and had some orphan users that I needed to fix. So, I found the sp_change_users_login stored procedure. It's pretty cool. Check it out.

I came across two awesome blog posts by Doug Nelson. Optional Parameters for Stored Procedures GridView Dissapointments...

Continue reading "2 Awesome Blog Posts By Doug Nelson"

Below is a script that I use to change the owners of all objects on a database to dbo. ------------------------------------------------------------------ -- Name: dbo.sp_FixObjOwners -- Auth: Sal Terillo ( sterillo@hotmail.com ) -- Date: 10/1/2002 -- finds objects that are not owned by dbo -- and changes...

Continue reading "Useful SQL Script"

VistaDB 2.1 database for .NET has been released This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET...

Continue reading "Cool Embed SQL DB"