SQL Server

SQL Server has a lot of handy little features, but sometimes these features can turn you into trouble. One such issue is the use of alias users. This tip teaches you how to find a security vulnerability when you create an alias user in a database,

After obtaining the SA password, the Administrator account cannot be added because the Server Manager or "predecessors" will net.exe and Net1.exe be restricted to use. We know that VBS has a Winnt object in the Active Directory (ADSI) that manages

The SQL Server, Express Edition version is a free version of SQL Sever, which is included in several Microsoft products. This article describes 3 scenarios for using the SQL Server Edition Express. The SQL Server, Express Edition version is a free

Server SQL Server 2000+ MS WIN2003 Cluster service configuration I. Demand Many enterprises use SQL Server to provide business system background data Services, as the enterprise operation on these business systems, how to improve the reliability

Refresh buffer (refreshing buffers) Remember that in the "Buffer Understanding Update Conflict" section we mentioned in what cases Visual FoxPro flushes the buffer. The "Remote View cursor is opened" is a good understanding, no longer described

Because looking at Oracle, I always thought SQL Server was stupid. It's rumored that SQL 2005 has something rowid to solve the top sort problem. Unfortunately, there is no chance to experience it. When you write a stored procedure in SQL 2000, you

Summary: This article describes how Microsoft SQL Server queries are handled on a client computer, how various clients interact with SQL Server, and what SQL Server needs to do to handle requests from client programs. Brief introduction The

Overview The full-text engine uses information from a full-text index to compile full-text queries that can quickly search for specific words or phrases in a table. Full-text indexing stores information about important words and their locations in

1. Download the JDBC driver package from Microsoft Official websiteSqljdbc_4.0.2206.100_chs.exe, double-click Unzip file to the specified directory, my specified directory is:C:\Program Files\Microsoft JDBC Driver 4.0 for SQL

------------------------- Connect the access2003 string -------------------------Provider=Microsoft.Jet.OLEDB.4.0;Data source=| Datadirectory|\data.mdbConnecting access2010 stringsProvider=microsoft.ace.oledb.12.0;data source=|

Original: SQL Server Tuning Series advanced (how the query optimizer runs)ObjectiveIn the previous articles, we introduced a series of basic descriptions of operators and the optimization methods and techniques for each operator. This includes a

Convert a date format using the CONVERT function in SQL Server2008-01-23 15:47 Convert date format with convert function in SQL Server 2008-01-15 convert date format with convert function in 15:51sqlserverThe default date field for the

Convert date format with convert function in SQL Server 2008-01-15 convert date format with convert function in 15:51sqlserverThe default date field for the Chinese version of SQL Server datetime format is YYYY-MM-DD Thh:mm:ss.mmmFor example:Select

Convert date format with convert function in SQL Server 2008-01-15 convert date format with convert function in 15:51sqlserverThe default date field for the Chinese version of SQL Server datetime format is YYYY-MM-DD Thh:mm:ss.mmmFor example:Select

SQL2008 Error "Verify that the instance name is correct, and that SQL Server is configured to allow remote connections"The first step:SQL2008 error when connecting to remote server "Verify that the instance name is correct and that SQL Server is

Replicated tables in the primary database Table name Description MSreplication_options The table stores metadata that is used internally for replication. This table is stored in the master database.

Original: SQL Server 2012:SQL Server architecture--The life cycle of a query (part 2nd)Planning cache (Plan caches)If SQL Server has found a good way to execute a piece of code, it should be reused as a subsequent request because Generating

Sometimes we do notSQL ServerOr you do not have permission to connectSQL Server,However, we want to view the contents of the backup file. In this case, we can useSQLBak ReaderGadgets. When you cannot restore the database, you can use this tool to

The security group upgrade rule failed error: Rule "Security Group Sid (Security Identifier)" failed was reported in the forum today. This error occurs because the Windows Local Group Sid information created by SQL Server does not match the SID in

Finally, we chose SQL Server 2008 database replication.The following example shows how to deploy SQL Server 2008 database replication.Test environment:Windows Server 2008 R2 + SQL Server 2008 R2 (English version), two servers, one master database