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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE
   ► KBSQL ServersMicrosoft SQ...   Print This     

DBA KB: Microsoft SQL Server Topic

Topics

16 Articles Found in the Microsoft SQL Server Topic  (or one of the sub-topics in bold above)

  KB Article    

Mike Prestwood
1. Char vs NChar What is the differences between Char, NChar, VarChar, and NVarChar?
11 years ago

FAQ
Nothing New Since Your Last Visit
19193
Hits

DBA, Databases, & Data

Bryan Valencia
2. 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.

6 years ago
(1 Comments , last by Theessay.S )

Code

KB Post
Nothing New Since Your Last Visit
6604
Hits

DBA, Databases, & Data

Mike Prestwood
3. Edit SQL Views? Are views in Microsoft SQL Server editable?
11 years ago

FAQ
Nothing New Since Your Last Visit
9407
Hits

DBA, Databases, & Data

Adam Lum
4. Embedded SQL Server 2005: Compact Edition SQL Server 2005 as an Embedded Database Choice in your Application
Posted to KB Topic: MS SQL 2005
11 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
6309
Hits

DBA, Databases, & Data

Wes Peterson
5. 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.

5 years ago
(2 Comments , last by mcalsky.m )

Article
Nothing New Since Your Last Visit
5079
Hits

DBA, Databases, & Data

Mike Prestwood
6. How to transfer an MS SQL database to Prestwood The preferred technique for transferring an MS SQL database is to do a complete backup and restore.
Posted to KB Topic: MS SQL 97 / 2000
16 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
7513
Hits

DBA, Databases, & Data

Mike Prestwood
7. Microsoft SQL Server 2005 Management Studio Express

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

Posted to KB Topic: MS SQL 2005
10 years ago, and updated 10 years ago

Download
Nothing New Since Your Last Visit
12349
Hits

DBA, Databases, & Data

Mike Prestwood
8. Microsoft SQL Server 2008 Express with Tools

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

Posted to KB Topic: MS SQL 2008
10 years ago

Download
Nothing New Since Your Last Visit
11010
Hits

DBA, Databases, & Data

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.

10 years ago

Code
Nothing New Since Your Last Visit  
12288
Hits

DBA, Databases, & Data

Joshua Delahunty
10. Moving Databases with SQL Server 2005 SQL Server 2005's available management tools make moving databases from one machine to another a snap. This article describes the steps
Posted to KB Topic: MS SQL 2005
13 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
15215
Hits

DBA, Databases, & Data

Mike Prestwood
11. 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

DBA, Databases, & Data

Stephen Berry
12. MS-SQL Binary Large Objects How do you store BLOBs (Binary Large Objects) in Microsoft SQL Server?
Posted to KB Topic: MS SQL 2005
11 years ago, and updated 11 years ago

FAQ
Nothing New Since Your Last Visit
9396
Hits

DBA, Databases, & Data

Bryan Valencia
13. MSSQL Update Trigger Example

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.

Posted to KB Topic: MS SQL 2005
11 years ago, and updated 10 years ago
(1 Comments , last by mprestwood )

Code
Nothing New Since Your Last Visit
22011
Hits

DBA, Databases, & Data

Wes Peterson
14. SQL Server 2005 - Great Learning Resource Whether you're a total newbie to databases, and need of a good foundation, a seasoned pro that wants a little review, or a developer that wants to help educate his clients, a series of well executed training videos is a great way to go.
Posted to KB Topic: MS SQL 2005
12 years ago

Blog
Nothing New Since Your Last Visit
7287
Hits

DBA, Databases, & Data

Joshua Delahunty
15. 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

DBA, Databases, & Data

Bryan Valencia
16. 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.

9 years ago, and updated 8 years ago
(9 Comments , last by Pervez.J )

Error
Nothing New Since Your Last Visit
40859
Hits

DBA, Databases, & Data

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

New DBA, Databases, & Data Knowledge Base Post...

Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).

Post New...

Tidbit Post: Short Flashcard FAQ Definition Quick Tip Code Snippet
Longer Post: Full Article General Post File Link Error News
Other: Blog Topic
Or, if YOU have a question...
  DBA, Databases, & Data Message Board

Follow PrestwoodBoards on: 


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