SQL Server

An issue that was encountered following a restore of the database (SQL Server 2008) when the project was recently migrated:msg 10314, Level 16, State 11, line 1ththe Microsoft. NET Framework error occurred while attempting to load assembly ID 65536.

--Open Ole Automation proceduressp_configure'Show advanced Options',1;GORECONFIGURE;GOsp_configure'Ole Automation Procedures',1;GORECONFIGURE;GOEXECsp_configure'Ole Automation Procedures';GO--Close Ole Automation proceduressp_configure'Show advanced

Original: Anatomy of SQL Server end article about Internals Viewer source codeAnatomy of SQL Server end article about Internals Viewer source codeYou may have used the Internals viewer software.Widget for viewing SQL Server Internal Data page

SQL Server Profiler-performance tuningPerformance has enough reason to become a hot topic. Today's business is fiercely competitive, and if users think that an application is too slow, they will immediately turn to another vendor. To meet the user's

One, the IBM WebSphere MQ7.0 JDBC Support database has: DB2 Informix Informix_with_date_format Microsoft_sql_server Oracle Sybase_jconnect6_05 In this paper, we use the JDBC for server R2 as an example to build JDBC

Note：This article is specifically targeted at people who are already familiar with SQLCMD mode in SQL Server Management Studio. Although not very novel, readers should understand the basic functionality of the SQLCMD documentation. A basic

We do the management software, the main core is in the data storage management. So database design is our priority. In order to make our management software stable, scalable, excellent performance, traceable troubleshooting, upgradeable deployment,

Ext.: http://blog.csdn.net/liuliuyushun/article/details/4215233SQL Server Instance--------------------------------------------------------------------------------------The so-called "SQL instance" is actually the SQL Server engine, and each instance

Database design Specifications 1. IntroductionDatabase design refers to a given application environment, constructs the optimal database pattern, establishes the database and other application system, enables it to effectively store the data,

Front-facing conditionsUse the Publish subscription feature of SQL Server for read-write separation and create multiple read libraries.Load balancing in this article is for multiple read libraries.Test environmentVMware 10 64-bitWindows Server R2SQL

No need to modify entities and configurations, use concurrency control consistent with SQL Server in MySQL. Modifying the rowversion type is not advisable, and modifying to timestamp is not feasible. SQL Server rowversion generates a string of

I used to want to know what the difference was, but it was forgotten because we seldom used a unique key constraint. It was not until a few days ago that my colleague gave me a script to constrain the uniqueness of a field with a unique key

First step: Open Administrative Tools in Control PanelSecond step: Click "Administrative Tools" and then double click "Data Source (ODBC)"Step three: After opening, click "Add"Fourth step: Select "SQL Server" and click "Finish"Fifth step: Fill in

Today wrote an Excel table import feature, results in Excel table content import to page times wrong: SQL Server blocked the STATEMENT ' openrowset/for component ' Ad Hoc distributed Queries ' OpenDataSource ' access because this component has been

This articleArticleIs the third article in the series. The addresses of the first two articles are as follows: Transaction logs in SQL Server (I)-physical and logical architecture of transaction logs Transaction Log in SQL Server (2)-Role of

After nearly one day of work, I finally configured the installation and configuration of jira3.6.2. The following describes some problems encountered during the installation and configuration process and solutions: Run startup. BAT to start

Introduction Another good feature in SQL Server 2014 is that SSD can be virtualized into a portion of the memory for the SQL server data page buffer. By using SSD to expand the buffer-pool, a large number of random iops can be carried by SSD, thus

Database Administrators familiar with SQL server 2000 know that DTS can import and export data. In fact, we can also use Transact-SQL statements to import and export data. In a Transact-SQL statement, we mainly use the OpenDataSource function and

1. view the database versionSelect @ version2. view the operating system parameters of the machine where the database is locatedExec master .. xp_msver3. view database startup parametersSp_configure4. view the database startup timeSelect convert

Two Methods for batch data import in SQL Server databases: SQL Server During the implementation of software projects, data import has always been a headache for the project staff. In fact, many data import methods are integrated in SQL Server. Some