DBA KB: Microsoft SQL Server Topic

Learn how to make an easy SQL Server Script that will automatically back up all your databases in a simple way.

Microsoft's free download tool for managing MS SQL 2005 databases.

MS SQL Express 2008 with Management Studio Basic. MS SQL 2008 database management tool only available bundled.

In MS-SQL, to move an object such as a table or view from one schema to another, use alter schema.

In MS SQL 2008, if you get a Saving Changes Not Permitted error, you can easily fix this error in Management Studio. Uncheck the Prevent saving changes that require table re-creation option. 

This tutorial shows how you would create a trigger in Microsoft SQL Server 2005/2008 that will date/timestamp a column named last_updated everytime any data in the row is updated.

This example assumes a primary key that includes 3 fields.

Have you installed SQL Server 2005, set all the right SQL Server settings, and still can't browse the server? If you're running XP Pro service pack 2 or later, you may have forgotten to fix this issue at the FIREWALL! (doh!)

Error: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -2146885628.

The Solution: Opened the "properties" dialog for the service, and on the Log On tab, changed the user from "This Account" to "Local System Account".  Started the service, and bingo.