SQL Server

Use database name go -- orphaned accounts created with sp_change_users_login repair-- List Orphaned users of the current database exec sp_change_users_login ' report '-- You can automatically add a login with the same name that corresponds to the

I. PrefaceHave not learned to take notes of their own habit, so in order to strengthen their knowledge in-depth understanding, decided to learn the notes written down, I hope to learn from you Daniel! Please treatise the wrong place! Thanks here!On

1, official website url:http://logging.apache.org/log4net/2. configuration file Reference url:http://logging.apache.org/log4net/release/config-examples.html3. Add the following code to the Web. config3.1: Join in the configsections 　　 configsections>

I. Configuring distribution1. Configure the Distributor, note: To configure the publication and subscription, connect to SQL Server must be logged in with the name2. Configure distribution3. Select the distribution server4. Select the snapshot

In a database with a large number of transactions, tables and indexes are fragmented over time. Therefore, to improve performance, you should periodically check the fragmentation of tables and indexes, and defragment them with a lot of fragmentation.

Address: http://blog.csdn.net/jiaohougenyang/article/details/44937801background : The project started with a SQL Server database, and the business requirements are now to tune the database to MySQL. Online collection of some tutorials, organized a

Database: Hierarchical type, net type, relational type.Sqlserver,oracle,db2,access,visual Foxpro,mysqlSeveral elements of data logging:1. Server type--database engine2. Server name--native. or (local), remote computer name or IP3.

common field type selection1. Varchar/nvarchar data types are recommended for character types2. Money data type is recommended for monetary value3. Scientific counting recommended numeric data type4. Self-growth logo recommended to use the bigint

/*------------------------------------------------------------------------------------Server-level-server role----------- -------------------------------------------------------------------------*/--View fixed server roles (8, no additions or

-- --Query all tables SELECT * from WHERE TYPE='U'----Queries all field names and their comments based on the table name SELECT a.name,b.value from syscolumns A left JOIN SYS. Extended_properties B on a.id=b.major_id and a.colid=b.minor_id

Transferred from: http://www.cnblogs.com/zerocc/p/3425431.htmlYesterday in the test some of the permissions early this morning found that SQL SERVER landed, error: User Login failed: Msg 18456, Level 14, State 1, Server XXX, line 1th. User ' XXX '

Brief introduction to the underlying statement:1. Description: Create DATABASECREATE DATABASE Database-name2. Description: Delete DatabaseDrop Database dbname3. Description: Back up SQL Server---to create a device that backs up dataUse masterEXEC sp_

Recently do data transfer, due to misoperation, in the system table master tables created n multiple tables is really impossible to deleteFind the following ways to share---Specify the tables in the database to be deleted use mastergodeclare @sql

You can use the pivot operator in Ms-sqlserver 2005 to implement row and column conversions. , but you must use the case if then else end statement in the previous versionBelow is an example of a Student score table:ID Name Account Score1  Zhang San

Sometimes we want to import all the data from one table of a database to another database or to a database on another computer, and for SQL Server there is a wayHere I take SQL Server R2, the database is the Northwind database, for example,Objective:

Using SQL Server to verify the user name and password, the user name and password entered from the page match the database user name and password, correct log in, error alerts. Form action="Index. jsp "method="POST"> !--Large div Frame start-

exec sp_droplinkedsrvlogin ' test ', nullexec sp_dropserver ' test 'EXEC sp_addlinkedserver@server = ' Test ',@srvproduct = ' ',@provider = ' SQLOLEDB ',@datasrc = ' 127.0.0.1 'EXEC sp_addlinkedsrvlogin' Test ',--the server alias being accessed (if

SQL Server replicates tables from one database to another/* Data operations between different server databases */--Create a linked serverexec sp_addlinkedserver ' itsv ', ' ', ' SQLOLEDB ', ' Remote server name or IP address 'exec

Function connmmsql (ip,user,pwd,database,strsql) Dim Conn,re,arr (2) Set conn = CreateObject ("ADODB". Connection ") Conn. Connectionstring= "Provider=SQLOLEDB.1; Password= "+pwd+"; Persist Security info=true; User id= "+user+", Initial catalog=

1. Create a new C # Console Application2. go to Server Explorer, right-click Add Connection at Data connection (PIC1), enter the server name and database name (sometimes the server name does not appear in the dropdown box, you can go to SQL Server