sql server admin

following is an example of a query that queries an EXCEL spreadsheet by using the OLE DB provider for Jet.Select *from opendatasource (' microsoft.jet.oledb.4.0 ', ' Data source= ' C:financeaccount.xls '; User id=admin; password=; Extended properties=excel 5.0 ') ... xactionsAs the project requires, the development process encounters the problem of accessing data across database servers.A search on the network, the data is indeed a lot, but to solve

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

SQL Server Functions and stored procedures, SQL Server Stored Procedures The SQL Server function is a structure that encapsulates one or more SQL statements.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

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

When you install SQL Server 2008 or SQL Server Tools, Microsoft SQL Server Native Client 10.0 is installed. SQL Server Native Client 10.0 wi

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

server| statement /******* Export to Excel EXEC Master.. xp_cmdshell ' bcp SettleDB.dbo.shanghu out c:\temp1.xls-c-q-s ' gnetdata/gnetdata '-u ' sa '-P ' "' /*********** Import Excel SELECT * From OpenDataSource (' microsoft.jet.oledb.4.0 ', ' Data source= ' C:\Test.xls '; User id=admin; password=; Extended properties=excel 5.0 ') ... xactions SELECT Cast (CAST (account number as numeric (10,2)) as nvar

Unable to open the connection to SQL Server, SQL Server After several days of login to the restructured version of the data room charging system, the login form was finally knocked out, and the code debugging was almost done, and the problem was in the database. The 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

-- Import EXCEL to remote SQL server through local SQL Server -- 1. Directly import the remote databaseInsertOpenDataSource ('Sqlodb ','Data source = shipmisserver/sqlserver2005; user id = sa; Password = sa123 $'). Lsshipmis_4500.dbo.t_workinfo_template(Workinfo_template_id, componentreference, itemname, itemcontent, p

Each individual instance of SQL Server has a Windows process: sqlservr.exe, multiple instances can be installed under one windows, and multiple instances will have multiple sqlservr.exe processes.A SQL instance corresponds to a service in the background, and if multiple applications are placed in an instance, a problem with a program developed by an application,

The following error occurs when connecting to the SQL Server 2000 database: Network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed. Verify that the Instance name is correct and

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

directory in order to open Microsoft SQL Server-->sql Server group--> double hit Open your server--> admin--> Database Maintenance Plan--> open to see the plan you set , you can modify or delete an operation V. Transfer of data