query through this statement:
SELECT * FROM Sysfiles
DBCC shrinkfile (1) 4. To minimize the log file (if it is SQL 7.0, this step can only be done in Query Analyzer)
Detach Database:
Enterprise Manager--server--database--right key--detach database
Delete log files on my Computer
Additional databases:
Enterprise Manager--server--database--right Key--add
Tags: blog http io ar using strong on file dataThe database is installed and the connection string is required for use in the program. How to write it? Take SQL Server R2 as an example.1, after installing SQL Server R2, similar to Oracle's Plsql tool. SQL
Label:As a database administrator of SQL Server, one of the most frequently encountered problems is to see which version of SQL Server you belong to, whether the latest fix pack is installed, and whether the most recent security patches are installed. Prior to this, we could get the relevant information through the fol
See if the following is helpful to you.
This is the most complex. There are many causes of errors and there are many aspects to check.
Generally, there are several possibilities:
1. incorrect spelling of the SQL server name or IP address
2. The server network configuration is incorrect.
3. The client network configuration is incorrect.
To solve this problem
time 2014-10-02 00:00:00 sql Server Team Blog Originalhttp://blogs.technet.com/b/dataplatforminsider/archive/2014/10/01/ Sql-server-2008-r2-sp3-and-sql-server-2008-sp4-are-now-available.aspx ThemesSQL
How to solve the problem that has passed the evaluation period of SQL Server, SQL Server
However, when you open the system you have previously typed, an error is always reported and cannot be performed. After checking, it turns out that the database has a problem and cannot be connected to the database. When
number. You can use this statement to query:
Select * from sysfiles
Dbcc shrinkfile (1) 4. To maximize log file size (for SQL 7.0, this step can only be performed in the query analyzer)
Separate database:
Enterprise Manager -- server -- database -- Right-click -- detach Database
Delete LOG files in my computer
Additional database:
Enterprise Manager -- server
Function Comparison of SQL Server database versions, SQL Server
Background
At the Data Amp Conference held today, Microsoft stressed to developers how Data affects their applications and services, along with several small news announcements. This free online seminar not only demonstrates the future of machine learning,
Install the tool when the VS2008 installed vs comes with the SQL tools, waiting for me to install SQL Server R2 when the "earlier version of Microsoft Visual Studio 2008" problem, found on the Internet solution is as follows :------for 32-bit systems (I am a bit of a 64-bit system this is all right.) Installing SQL
Configure the SQL Server database recovery mode (two methods), SQL Server
The following describes how to configure the SQL Server database recovery mode.
Set recovery mode with T-SQLYou can useAlter database"Add"Set recovery"State
How SQL SERVER 2000 obtains the current system time with SQL statements
is to use GETDATE ();
getdate in SQL ()
A very powerful date format function in SQL Server
Select CONVERT (varchar), GETDATE (), 0): 2008 10:57am Sele
Tags: style blog http color os ar using SP strongBO Master recently installed SQL Server2005 on Win8.1, unexpectedly often to error (for this blogger to reinstall the system)It was later found that two files needed to be replaced on the Win8.1, which solved the problem successfully.Http://www.ithome.com/html/win8/57118.htmAs normal, installing Microsoft's SQL Server
server|sqlserver| Error | data | database
Unable to open the user default database , logon failed, which is one of the problems that SQL Server users are familiar with. When using Enterprise Manager, Query Analyzer, various kinds of tools and application software, as long as the connection to the SQL
SQL Server trigger and SQL Server trigger
Brief Introduction:
A trigger is a special stored procedure, which is automatically executed only when a specific event occurs. Stored Procedures and triggers are a collection of SQL statements and flow control statements. stored pro
SQL Server trigger and SQL Server triggerA trigger is a special type of stored procedure, which is different from the stored procedure we introduced earlier. A trigger is triggered by an event and automatically called for execution. The stored procedure can be called by the name of the stored procedure.
Ø what is a tri
This series of articles I saw in the sqlskill.com's PAUL blog, many misunderstandings are more typical and representative, the original from the T-SQL Tuesday #11: Misconceptions about... EVERYTHING !!, After translation and arrangement by our team, it is published on AgileSharp. Hope to help you.
Misunderstanding #26: there is a real "transaction nesting" in SQL Serve
Before we had to export the data from one table to a script, we would be able to export the data script by looking for a script to export the data on the web and then run it. A new feature is now added to Management Studio in SQL Server 2008, which supports exporting data from a table as a script, in addition to the definition of a table. Export process:
In Object Explorer in SSMS2008 (
Tags: style blog http io color OS SP for strongTo synchronize data from Oracle in real time to MS SQL Server, you need to read and write data directly to SQL Server in Oracle, and you can install the Oracle database for SQL Servers component on the Oracle about how to instal
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.