microsoft sql server 2000 standard edition

Optimize SQL Server 2000 settings SQL Server has been well configured to optimize its own performance, which is much better than other relational databases on the market today. However, you still have several settings that need to be modified so that your database can proc

Authentication Mode to solve the permission issue during connection (this setting is done by the publishing/subscription servers) Enterprise Manager -- Right-click an SQL instance -- Properties -- Security -- Authentication -- Select "SQL Server and Windows" -- OK 5. Register with each other on the Publishing Server a

Modifying the Windows account password causes SQL Server 2000 to fail to start. --The symptom is a SQL Server 2000 database that is logged on to Windows XP as an administrator or equivalent user. After you modify this Windows acco

SQL2000 database because of its own vulnerabilities, hackers can easily access the system administrator permissions. SQL runs with system privileges by default, and permissions are super powerful. In order to make the server more secure, it is recommended to set the SQL2000 to run with guests permissions, so that hackers even invade the database, can not obtain system administrator rights, to prevent furt

Server Database operation is now the fundamental development of the project, learning Java should first learn how to connect the database, with the Java connection database is not like the use of Delphi tools such as a few attributes on OK, said simple also simple, said complex, in fact, very complex, and very troublesome, if it is a beginner, There is no guarantee that the connection will be successful for the first time, as an example of

evasive recovery mode, "said one Netizen Yang. I've tried so many times that I can't change the state. ”There's also a Rui to execute the DBCC CHECKDB times wrong: "server:msg 943, level, State 1, Line 1 Database ' His_yb ' cannot is opened because its versio N (539) is later than the current server version (515). For Yang, perhaps he did not do it step-by-step. My firsthand experience is that you can do DBCC CHECKDB after you set the application da

First, create an empty Access database on the local disk (for example, use student. MDB). In this case, the database of SQL Server 2000 already exists. Take sky2098 as an example. One of the tables is student, as shown in: Select the database sky2098, right-click, and select the Export Database option under the "all tasks" list: Click "Next", "Data Source",

When using SQL Server 2000 to automatically generate SQL scripts, there are some special keywords. I didn't care much about them before, and I didn't remember which one to check and which one to use, this is a simple list (for more information, see the SQL

-- In SQL Server 2000, how to back up the database, compress the backup, and copy it to another location -- 1: (Backup)-- 1.1 create a Test DatabaseUse masterGoIf db_id ('dbtest') is not nullDrop database dbtestGoCreate Database dbtestGo-- 1.2 set the backup path and file nameDeclare @ path varchar (200)Set @ Path = 'C:/bak/dbtest' + convert (varchar (10), getdat

// SQL Server"Connection" connectionstring="Data Source=.; I Nitial catalog=db; User Id=sa; Password=sa "providername="System.Data.SqlClient"/>// SQL Server 2005"Connection" connectionstring="Data Source=. \sql2005; Initial catalog=db; User Id=sa; Password=sa "providername="System.Data.SqlClient"/>named instances are d

Phenomenon My machine calls Microsoft's CDO or CDOEX access to Exchange mailboxes has an exception! And ADSI is not working properly. From the outside, there is no sign of error. The following steps are reproduced: Create an application in VB; Quoting CDOEX.DLL; Code writes: Set oMsg = CreateObject("CDO.Message")　 oMsg.DataSource.Open(“http://BackEndServer/public”) You get the same error in the second line: Run-time error '-2147221164 (80040154) ': Unable to write entry to registry Fro

installed.SQL2000 installation SP4 patch full diagram Step 1: Click Setup.bat to install, such as: Step 2: Click "Next", such as: Step 3: Click "Yes", such as: Step 5: Click "Next", such as: Step 6: Select the Windows account information I used to log on to my Computer (Windows authentication) and click Next, such as: Step 7: Tick "Upgrade Microsoft Search and apply SQL

Only SQL Server 2000 Development edition and Enterprise Edition allow insert, update, and delete operations in the partition view. To modify the partition view, the statement must meet the following conditions: 1. The insert statement must provide values for all columns in

SQL Server 2000 provides some XML functions, which are used to convert the XML documents in the component layer of the relational row set through XML, read XML documents, and load data in batches. For example, you can pass an XML document to a stored procedure, connect XML to some tables, return a row set, or even modify data in the database. The extended functio