|
How to manually add a database (SQL 2005/2008)
|
|
This article will explain how to manually create a database and user for SQL server 2005/2008.
|
|
Full-Text Search in SQL Server 2005 Express Edition
|
|
This article explains how to perform Full Text searches using SQL Server 2005 Express Edition with Advanced Services.
|
|
How to manually attach databases in Management Studio
|
|
This article details the process for manually attaching databases files in SQL Server Management Studio.
|
|
How do I schedule Automatic Database Backups?
|
|
This article will walk you through how to schedule your SQL server to automatically generate backup copies of your databases on a nightly basis.
|
|
Where can I find more information on SQL Server 2008?
|
|
This article will point you in the right direction for learning more about SQL Server 2008.
|
|
Connect to SQL Server 2005 using Managment Studio 2008
|
|
This article shows how to get around the security error you receive initially upon connecting to a SQL Server 2005 using Management Studio 2008.
|
|
How to run an SQL query
|
|
How to run an SQL query using SQL Server Management Studio
|
|
SQL Authentication Types
|
|
This article covers the differences between SQL Server Authentication and Windows Authentication when connecting to a database through SQL Management Studio.
|
|
SQL Server 2005 Enterprise Edition System Requirements
|
|
The following article details the system requirements, both hardware and software, for SQL Server Enterprise Edition.
|
|
SQL Server 2005 Standard Edition System Requirements
|
|
The following article details the system requirements, both hardware and software, for SQL Server Standard Edition.
|
|
SQL Server 2005 Workgroup Edition System Requirements
|
|
The following article details the system requirements, both hardware and software, for SQL Server Workgroup Edition.
|
|
SQL Server 2005 Express Edition System Requirements
|
|
The following article details the system requirements, both hardware and software, for SQL Server Express Edition.
|
|
How to Backup a database using Management Studio
|
|
This article will walk you through How to Create a Backup file (.bak) of your Database, through SQL Server Management Studio Express.
|
|
Resetting the SA password for SQL Server
|
|
How to reset the password for the System Administrator, or 'sa' user account, within SQL Server Management Studio
|
|
Creating an SQL Server Database in Helm 4
|
|
How to create an SQL Server 2005 database and user in version 4 of the Helm Control Panel
|
|
Using Integrated SQL Server Security in your web site
|
|
This article describes how to use integrated SQL server authentication in your connection string. This does not apply to databases hosted on the shared database servers.
|
|
Server Intellect SQL Server Backup Policy
|
|
Frequently asked questions regarding Server Intellect's Database backup Policy.
|
|
Accessing a Shared Database with Web Site Admin Tool
|
|
How to access a shared database using Visual Studio's Web Site Administration Tool.
|
|
Change the collation of your database
|
|
Changing the collation of your database.
|
|
How to determine SQL Server version/service pack
|
|
This article contains queries for SQL 2000 and 2005 that will display the current version and service pack of SQL Server.
|
|
What is a sample SQL Server Connection String?
|
|
FAQ: What is a sample SQL Server Connection String?
|
|
Can I use Query Analyzer to manage my database?
|
|
Can I use Query Analyzer to manage my database?
|
|
Add ASP.NET 2.0 Membership Roles to remote SQL
|
|
How-to add ASP.NET 2.0 Membership Roles to remote SQL database
|
|
Connect to SQL Server with Enterprise Manager
|
|
How do I connect to SQL Server with Enterprise Manager?
|
|
How do I add a shared SQL database?
|
|
Step by step instructions for adding an SQL database to a VPS or Dedicated Server Account
|
|
How do I install SQL Server Express?
|
|
How do I install SQL Server Express on my VPS/Dedicated Server?
|
|
Restore Database using Management Studio Express
|
|
How to restore a database using SQL Server Management Studio Express.
|
|
Connect to a Database using Studio Express
|
|
How to connect to a database using SQL Server Management Studio Express.
|
Knowledge Base
