SQL Server

MSSQL failed to restore the database. The prompt is as follows: Restore to and server failed. (Microsoft. sqlserver. SMO) Other information: handle exceptions → An exception occurs when you execute a Transact-SQL statement or batch processing.

From: http://www.sqljunkies.com/Tutorial/C5A500EB-B8BE-42C0-B23B-258A342CAAAB.scuk In the articles titled using COM objects in SQL Server and extending SQL Server with COM objects, we sawBasics of how to access and use COM objects from SQL Server.

Abstract: SQL Server has many built-in system stored procedures, but most of them are not commonly used. In practice, I summarized some common examples and introduced some examples. This topic introduces:L sp_attach_dbL sp_attach_single_file_dbL

1. Daily automatic backup Open the Enterprise Manager, choose "manage"> "Database Maintenance Plan", right-click the window on the right, select "New Maintenance Plan", and start the "database maintenance plan wizard "; click "Next" to select the

1. It is best to have only one transaction for a stored procedure; multiple transactions consume both resources and are prone to errors; 2. When creating a transaction and ending a transaction, you 'd better have the following judgment:Code Code

Select CONVERT (varchar (100), GETDATE (), 0): 05 16 2006 AM Select CONVERT (varchar (100), GETDATE (), 1): 05/16/06 Select CONVERT (varchar (100), GETDATE (), 2): 06.05.16 Select CONVERT (varchar (100), GETDATE (), 3): 16/05/06 Select CONVERT

Template for http://blog.joycode.com/ghj/archive/2009/02/16/115466.aspx SQL Server When writing SQL scripts, there are a lot of common features. At this time, templates can bring us great convenience. The following uses the new stored procedure as

As I needed to train my colleagues on database indexing knowledge, I collected and sorted out this series of blogs. This is a summary of index knowledge. After summing up, I found that many vague concepts were much clearer in the past. Both

Reference to: http://msdn2.microsoft.com/zh-cn/library/ms178588 (VS.80). aspxRegularly clear expired session dataBecause the sample session state storage provider does not support Session_OnEnd events, it does not automatically clear expired session

Check for blocking: 1. SYS. dm_tran_locks (sp_lock or syslockinfo must be used in sqlserver2000)Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SELECT Request_session_id AS spid, Resource_type

Original table structure Serial number Gender Department Salary 1 Male Department 800 2 Female Department B 900 3 Male Department 400 4 Female

SQL merge rows As follows: ID Name 1 Tom 1 John 2 Carrier 2 Wendy 1 Rick The following results must be displayed: ID Name 1

The ranking function is newly added to SQL Server2005. There are four ranking functions in SQL Server2005: 1. row_number 2. rank 3. dense_rank 4. ntileThe following describes the functions and usage of these four ranking functions. Before the

Recently, when I was working on a database, I found that the disk space is often insufficient due to the large size of tempdb. To solve this problem, we use a solution to move tempdb to a new location. The procedure is as follows;1. Check the

Click Manage/SQL server proxy/jobCreate a job:On the General tab, enter "name" in "regular backup database", "enable", select "check", and "target local server ","Category" select "database service ",On the "Steps" tab, create a step. Step name:

This method mainly describes how to remove data from the SQL Server database without using Dataset. Compared with the former, this method reduces the amount of code required for retrieval from the database.1. Contact code: 1: using

Use an SQL statement to add or delete a modified Field1. Add a fieldAlter table docdsp add dspcode char (200)2. delete a fieldAlter table table_NAME drop column column_NAME3. Modify the field typeAlter table table_name alter column column_name

Table value functions The difference between a Table value function and a scalar value function is that the Table value function returns a Table Type equivalent to a virtual Table stored in memory. Syntax of the Table value function: Create function

Q: I occasionally find that the SQL Server built-in query optimizer is inefficient and the query plan is not optimized. How can I adjust the query plan? A:You can use the SQL Server optimization prompt to overwrite the query optimizer. Optimization

Document directory Standard How to specify the location of the SDF file Standard Specifying the maximum database size Specifying the maximum buffer size Encryption enabled Exclusive access Read only access Exclusive but shared for reading