sql server audit table changes

Microsoft SQL Server database administrator, think fast! Without using any documents, write a query that extracts the list of indexes from the SQL Server 2000 system tables, then enumerates the fields in each index, and determines whether the field is sorted in ascending or descending order. You have two minutes. Fast!

) ' Exec sp_executesql @Str, N ' @WokNo Varchar () output ', @WokNo output Select @WokNo, @i--a line to display the employee number Set @i = @i + 1 principle If a local temporary table is created by a stored procedure or by an application that is executed concurrently by multiple users, SQL Server must be able to differentiate between tables

SQL server allows you to quickly query information about a table among multiple databases. This example describes how SQL server can quickly query information of a table among multiple databases. We will share this with you for yo

parallel View Separate the table data from the library without data loss Metadata needs to be updated periodically, and new databases are maintained periodically Synonyms Separate the table data from the library without data loss Not available on linked servers, and to maintain new databases on a regular basis Bcp Private backup of the o

First of all, I need to emphasize that this article aims to reveal the principle of recovering the deletion records of heap tables. What I have considered does not apply to every situation of everyone. I hope you will forgive me ~ Many friends think that in simple mode, the heap table cannot retrieve a record because there is no log record. In fact, it can be recovered in a sense, because when a heap table

, @job_ Owner, @job_id 2.2 can use distributed queries to avoid this problem, as the author mentions in inside SQL Server 2005 (1) First to open the server option AD HOC distributed queries exec sp_configure ' show advanced options ',1 reconfigure go exec sp_configure ' Ad Hoc D istributed Queries ',1 reconfigure go (2) Connect to native via OPENROWSET, run sto

The logical design of databases is a wide range of issues. This article focuses on the primary key design issues and corresponding solutions when designing tables on ms SQL Server during application development. Primary Key design status quo and problems The primary key design of database tables is generally based on business needs and business logic to form a primary key. For example, to record the sales s

SQL Server multi-Table query optimization solution highlights, sqlserver The multi-Table query optimization solution of SQL Server is what we will introduce in this article. We provide the optimization solution and specific optimi

Method-: Using bcp command bcp utility The bcp utility microsoft®sql the data in a user-specified format between the server™2000 instance and the data file. Grammar bcp {[[database_name.][owner].]{table_name | view_name} | "query"} 　　{in | out | queryout | format} data_file 　　[-m max_errors] [-f format_file] [-e err_file] 　　[-F first_row] [-L last_row] [-b batch_size] 　　[-n] [-c] [-w] [-N] [-V (60 | 65

Label:We all know that when the amount of database data is large, data can be horizontally extended, such as sub-Library, partition, sub-table (also called partition) and so on. One scenario for a sub-table is to use the partitioned view implementation. Partitioned views allow data in large tables to be split into smaller member tables. partitions data between individual member tables based on the range of

then we can break down each point of the key.Partitioning is to split a table data into sub-collections, that is, to split a data file into multiple data files, but the storage of these files can rely on a filegroup or multiple filegroups, because more than one filegroup can increase the database access concurrency, but also can be different partitions configured to different disks to improve efficiency , the recommended partition is created with the

' isusertable ') = 1) drop table [dbo]. [Table name]--method Two: if exists (SELECT * from sysobjects where id = object_id (n ' table name ') and OBJECTPROPERTY (ID, n ' isusertable ') = 1) Drop Table [dbo]. [Table name]--method Three: if (Exists (Select * from SysObjects W

, Chinese name)Select @sql = @sql + Case when Number = 1 Then '); --Drop Table'+Table name+'; CREATE TABLE'+Table name+' ( ' Else "' End + ( Case when Number = 1 Then ' ['+Englis