DBA, Databases, & Data New and Updated KB Posts

Need to grant EXECUTE permission to a low-permission user for all the Stored Procedures in your database?

The code in this article will do the trick for you.

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

The installation of the SourceGear Vault client control appears to trash SQL Server Management Studio and Visual Studio.

Here's the fix that worked for me.

In this article, you will be shown a few generic methods to optimize your SQL queries.  This information is not database-specific (other than in a few places) and should apply to any SQL based database.

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.

Think globally, act locally.  How many times have you needed to determine the geographic distance between two places?  This tutorial will show you how to accomplish just that.

All data and functions exist in a SQL Server Database, and can be used in VB.NET, C#.NET, Paradox, Delphi, or any other language that can call a database function.

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. 

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

Error: nmefwmi.exe has stopped working

Solution: This error is caused by a defect in 11g limited to Windows Vista. The nmefwimi.exe is an Oracle 11g service used by dbconsole (OaracleDBConsoleorcl). You can stop this service to stop this error then set it's Startup Type to Manual to prevent it from returning. Doing so will not affect your database. When you need to use dbconsole, start the service manually.

Also, check with Oracle for an update that fixes this issue.

Need to grant EXECUTE permission to a low-permission user for all the Stored Procedures in your database?

The code in this article will do the trick for you.

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

The installation of the SourceGear Vault client control appears to trash SQL Server Management Studio and Visual Studio.

Here's the fix that worked for me.

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.

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!)

Overview of DDE.

some tips for data migration, especially with bitfield, or "logical" field types.

The ORA-00900 error displays automatically when erp is running properly but may be caused by a constraint violation.

In this article, you will be shown a few generic methods to optimize your SQL queries.  This information is not database-specific (other than in a few places) and should apply to any SQL based database.