SQL Server

1. Start or stop the SQL Agent service in Query Analyzer Start Use master Go xp_cmdshell ' net start SQLServerAgent ' Stop it Use masterGoxp_cmdshell ' net stop SQLServerAgent ' Change the startup of a service from manual to automatic startexec xp_

SQL Server table-valued function and scalar-valued function define the way and call difference SQL stored procedures often need to call some functions to make the process more reasonable, you can also make functions more reusable, but when writing

1. generate a for 2005 version of the database script Manger Studio, 2008--Open "Object Explorer" (no words pressed F8), connect to your instance--right key to go to 2005 of the Library-Mission--Generating scripts--In the "Select Database" of the

This paper mainly deals with the application examples of DDL triggers and login triggers. MicrosoftSQL Server provides two primary mechanisms for enforcing business rules and data integrity: constraints and triggers. Triggers are special types of

Here's a description of what ports are used in SQL Server 2008: First, the most commonly used is the 1433 port. This is the port of the database engine, and if we want to connect to the database engine remotely, then we need to open the port. This

How SQL SERVER 2000 obtains the current system time with SQL statementsis to use GETDATE (); getdate in SQL () January 08, 2008 Tuesday 14:59A very powerful date format function in SQL Server Copy Code code as follows: Select CONVERT

The official name of MSSQL is from SQL Server MS Company. The graphics operation interface is better, the performance is also OK. Cannot be interchanged on MSSQL and Oracle. Supports OLE DB connections. asp, MSSAQL only for window MySQL is mysql

First, Introduction One of the major changes in Microsoft SQL Server 2005 is the inclusion of XML data types. This data type is the first class type, just like INT or VARCHAR, and SQL Server 2005 allows you to query and process this data type

The server now seems to be very popular with XML, and all sorts of things are starting to support XML. The mobile suit that is good at doing things naturally is to take the lead in everything. Browsers, Office, SQL, MDAC, and XML mixed with one

/* Note: If the value returned by the query path is NULL, the default installation path is C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\data */ --Query User library data file default path: DECLARE @DefaultData VARCHAR (100)

Feel Internals Viewer This name is very good, inside view. This gadget is the one I saw in the garden before the article was reproduced Article Address:SQL Server2008 storage structure heap table, row overflow Http://www.cnblogs.com/trams/archive/

When a system fails, it can be used to recover data to resolve database failures as long as there is a data log. As a SQL Server database administrator, it is important to understand the role of data log files and how to use them to troubleshoot

Most MFC developers are familiar with Open Database Connectivity (ODBC) database classes-they appear as early as 3.5. In MFC 4.2, there are some important improvements to these classes. As a C + + developer, you may not be familiar with DAO because

1. It is recommended to make a backup of the database upgrade to the production environment, safekeeping.2. To upgrade from SQL Server R2 to SQL Server SP1, you need to install the SP1 or SP2 patch pack for SQL Server R2, where you run the

When IDENTITY_INSERT is set to OFF, you cannot insert an explicit value into the identity column in table ' #TT '.I was in SQL Server to write the stored procedure encountered this error, then thought: how the temporary table has a primary key, I

Brief introductionThe essence of deadlock is a stalemate, which is caused by the contention of multiple subjects for resources. Understanding deadlocks first requires an understanding of the relevant concepts involved in deadlocks.Some basic

Accident background:suddenly the database is corrupted for no apparent reason, and differential or transaction log backups 3 point will be automatically done, then how to 2 Point to 2 Point + data recovery between the ? this needs to be restored by

The previous connection was normal, not even on these two days. ( no patience to look at the end of the solution directly)The error message is as follows:1. Attempt to read or write protected memory. This usually indicates that other memory is

Differences between text and varchar (max) data types in SQL ServerIt was only known that text and image were data types that could be retired by SQL Server, but it was not clear why the difference between text and varchar (max) and nvarchar (max)

SQL Server database downgrade from high version to low version instance details, SQL Server details How to downgrade an SQL Server database from a higher version to a lower version Currently, SQLServer2000 is widely used. Many companies want to use