I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

November Edition
Subscribe now! It's Free!
Enter your email:

   ► KB ►► Role-Based T...DBA & Data   Print This    All Groups  

DBA, Databases, & Data New and Updated KB Posts

Page Contents


Recently Created

(DBA, Databases, & Data Group)

  KB Article    

Assignment help
1. Assignment help https://www.ozassignments.com
Posted to KB Topic: DBA & Data
8 months ago
(1 Comments , last by Pervez.J )

Link
Nothing New Since Your Last Visit
257
Hits

Wes Peterson
2. Granting Execute Permissions for Stored Procedures

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.

Posted to KB Topic: Microsoft SQL Server
5 years ago
(2 Comments , last by mcalsky.m )

Article
Nothing New Since Your Last Visit
5079
Hits

Bryan Valencia
3. Easy SQL Server Backup Script

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

Posted to KB Topic: Microsoft SQL Server
6 years ago
(1 Comments , last by Theessay.S )

Code

KB Post
Nothing New Since Your Last Visit
6604
Hits

Wes Peterson
4. SQL Server Nasty Crash - Vault?

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.

Posted to KB Topic: SQL Servers
8 years ago
(1 Comments , last by Evangeline.S )

KB Post
Nothing New Since Your Last Visit
5420
Hits

Bryan Valencia
5. General SQL Optimization Tips

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.

Posted to KB Topic: SQL Servers
9 years ago

KB Post
Nothing New Since Your Last Visit
7566
Hits

Bryan Valencia
6. Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. ... service-specific error code -2146885628

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.

Posted to KB Topic: Microsoft SQL Server
9 years ago, and updated 8 years ago
(9 Comments , last by Pervez.J )

Error
Nothing New Since Your Last Visit
40854
Hits

Bryan Valencia
7. Geolocation: Step by Step

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.

Posted to KB Topic: SQL Servers
9 years ago, and updated 9 years ago
(3 Comments , last by mprestwood )

Article
Nothing New Since Your Last Visit
16286
Hits

Mike Prestwood
8. MS SQL 2008 Saving Changes Not Permitted

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. 

Posted to KB Topic: MS SQL 2008
10 years ago

Error
Nothing New Since Your Last Visit
9910
Hits

Mike Prestwood
9. Move Table to Another Schema

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

Posted to KB Topic: Microsoft SQL Server
10 years ago

Code
Nothing New Since Your Last Visit  
12288
Hits

Mike Prestwood
10. nmefwmi.exe

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.

Posted to KB Topic: Oracle 11g
10 years ago, and updated 10 years ago
(1 Comments , last by jjeffman )

Error
Nothing New Since Your Last Visit
20709
Hits




Recently Updated

(DBA, Databases, & Data Group)

  KB Article    

Assignment help
1. Assignment help https://www.ozassignments.com
Posted to KB Topic: DBA & Data
8 months ago
(1 Comments , last by Pervez.J )

Link
Nothing New Since Your Last Visit
257
Hits

Wes Peterson
2. Granting Execute Permissions for Stored Procedures

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.

Posted to KB Topic: Microsoft SQL Server
5 years ago
(2 Comments , last by mcalsky.m )

Article
Nothing New Since Your Last Visit
5079
Hits

Bryan Valencia
3. Easy SQL Server Backup Script

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

Posted to KB Topic: Microsoft SQL Server
6 years ago
(1 Comments , last by Theessay.S )

Code

KB Post
Nothing New Since Your Last Visit
6604
Hits

Wes Peterson
4. SQL Server Nasty Crash - Vault?

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.

Posted to KB Topic: SQL Servers
8 years ago
(1 Comments , last by Evangeline.S )

KB Post
Nothing New Since Your Last Visit
5420
Hits

Bryan Valencia
5. Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. ... service-specific error code -2146885628

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.

Posted to KB Topic: Microsoft SQL Server
9 years ago, and updated 8 years ago
(9 Comments , last by Pervez.J )

Error
Nothing New Since Your Last Visit
40854
Hits

Joshua Delahunty
6. What do to when a fresh SQL Server 2005 install can't be accessed from the network

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

Posted to KB Topic: MS SQL 97 / 2000
13 years ago, and updated 9 years ago

KB Post
Nothing New Since Your Last Visit
5700
Hits

Mike Prestwood
7. DDE: Dynamic Data Exchange Introduction

Overview of DDE.

Posted to KB Topic: Desktop Databases
16 years ago, and updated 9 years ago

KB Post
Nothing New Since Your Last Visit
8537
Hits

Joshua Delahunty
8. Data Migration, Paradox to SQL Server

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

Posted to KB Topic: DBA & Data
13 years ago, and updated 9 years ago

KB Post
Nothing New Since Your Last Visit
14577
Hits

pande.dhiraj
9. ORA-00900: invalid SQL statement

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

Posted to KB Topic: DBA & Data
12 years ago, and updated 9 years ago

Error
Nothing New Since Your Last Visit
14883
Hits

Bryan Valencia
10. General SQL Optimization Tips

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.

Posted to KB Topic: SQL Servers
9 years ago

KB Post
Nothing New Since Your Last Visit
7566
Hits
Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech