Prepare to do before copying:
1. Publisher, Subscriber creates a Windows user with the same name and sets the same password as a valid access user for the publication snapshot folder
My computer
Control Panel
Management tools
Computer Management
Users and Groups
Right-click User
New user
Create a user who is logged on to Windows in the group of Administrators
2. At the publisher, create a new shared directory as the repository for the published snapshot files:
My computer
D:\ Create a new dir
SQL Server database management common SQL and T-SQL statements
1. view the database version
Select @ version
2. view the operating system parameters of the machine where the database is located
Exec master .. xp_msver
3. view database startup parameters
Sp_configure
4. view the database startup time
Select convert (var
Label:SQL Server Agent is the core of all real-time databases. Proxies have a lot of non-obvious uses, so the knowledge of the system is useful for developers or DBAs. This series of articles will be popular to introduce its many uses.
In the previous article in this series, you learned how to use SQL Server Agent job Activity Monitor to monitor job activ
error|server| Program
Error : "When connecting to SQL Server 2005, the default setting for SQL Server to disallow remote connections may cause this failure. (provider: Named pipe provider, error:40-cannot open a connection to SQL
The following step-by-step article describes how to configure shared disk Cluster for SQL Server on a red Hat Enterprise Linux system and its associated use (for test-only learning, basic article)I. Creating shared disks and ClusterMicrosoft Official configuration document: Https://docs.microsoft.com/en-us/sql/linux/sql
Tags: style color ar using SP strong file data onSQL Server allows the user to set the database initial and maximum values, which can be configured by auto-grow or auto-shrink. With these configurations, we can prevent application modifications that could be caused by database space problems, or when SQL Server disk space is exhausted. In general, if the database
Tags: style blog http io os using ar strong file"Article Summary"A recent project to get some data that exists on other servers, it is implemented in a way that is pushed by other "servers" to our servers for security reasons. Our server is using SQL Server R2, the other "servers" are using SQL
The pivot and Unpivot relational operators are the new features provided by SQL Server 2005, so when you use pivot and UNPIVOT for databases that are upgraded to SQL Server 2005, the compatibility level of the database must be set to 90 (you can use sp_ Dbcmptlevel stored procedures to set the compatibility level.
Usi
The pivot and Unpivot relational operators are the new features provided by SQL Server 2005, so when you use pivot and UNPIVOT for databases that are upgraded to SQL Server 2005, the compatibility level of the database must be set to 90 (you can use sp_ Dbcmptlevel stored procedures to set the compatibility level.
Usin
It is necessary to note that the SQL Server failover cluster (SQL Server Failover Cluster) We build is an availability cluster, not a load-balanced cluster, which is designed to ensure continuity and availability of services, not to improve service performance. SQL
Tags: Database sqlRecently a friend consulted the SQL Server upgrade issue, in the test environment to upgrade SQL Server R2 to SQL Server SP1, because it is in the test environment, so before the upgrade of the database
Tags: migrating local SQL Server database to Windows Azure SQL database via SSMs toolMigrate local SQL Server database to Windows Azure SQL database via the SSMs toolMicrosoft's product updates are getting faster, almost every yea
From: http://blog.csdn.net/hillspring/article/details/2304900
Typically, developers use T-SQL to create stored procedures, functions, and triggers for SQL Server. Currently, SQL Server 2005 fully supports the. NET Universal Language Runtime (CLR. This means that you can us
Remote connection SQL Server 2008, server-side and client configuration
Key settings:
The first step (SQL2005, SQL2008):
Start--> program-->microsoft SQL Server 2008 (or the)--> Configuration Tool-->sql
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
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
Label:remote connection to SQL Server 2008, server-side and client configuration First step (SQL2005, SQL2008): Start-to-Program-->microsoft SQL Server 2008 (or 2005)-Configuration Tools-->sql
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.