solarwinds sql server

1. View the version of the databaseSELECT @ @versionSeveral common types of SQL Server patched version numbers:8.00.194 Microsoft SQL Server 20008.00.384 Microsoft SQL Server SP18.00.532 Microsoft

? SQL Server replication requires an actual server name to connect to the server, please specify the actual server name ? 2014-06-12 12:01:10 recently in the study advanced replication technology for SQL

SQL server determines whether a database, table, column, or view exists. SQL server 1. Determine whether the database exists If exists (select * from sys. databases where name = 'database name ')Drop database [database name] 2. Check whether the table exists. If exists (select * from sysobjects where id = object_id (N

Tags: modify password Windows Server server securitySQL Server R2 modify the sa password by logging in with SQL Server AuthenticationHere's how to fix itAfter logging in with Windows authentication,First select Server (right-click

1. view the database versionSelect @ version Common SQL server patch versions: 8.00.194 Microsoft SQL Server 20008.00.384 Microsoft SQL Server 2000 sp18.00.532 Microsoft SQL

-- Brief Introduction to SQL Server Security (users, roles, permissions)/*Users are divided into Server login and database users.Roles are divided:Server role (inherent, cannot be deleted or customized );Database roles (inherent, cannot be deleted or custom roles can be added );View online for more help*/ -- Practical application description --

SQL Server data table field custom Custom Data Format method, SQL Server This document describes how to customize the Custom Data Format of SQL Server data table fields. We will share this with you for your reference. The details

SQL Server database optimization practice (III), SQL Server Preface: This chapter describes how to compress logs and tables. Shrink log files -- Exploitation Exec sp_spaceused Statement to view the database size -- Right-click Database Properties -- View options -- Set the recovery mode to simple -- Right-click D

SQL Server splits and inserts a specific string. SQL Server This example describes how SQL Server Splits a specific string and inserts it. We will share this with you for your reference. The details are as follows: -- Cyclically

Label:If you set a column to identity when you create a new table, you can not display the specified value when inserting the data, and SQL Server automatically populates the value of that column. Create Table TblPerson1 ( IntIdentity(1,1Primarykey not Null , Nvarchar (null ) At this point, the following code can be used to insert data into the table. Although the Tblperson table has two columns, o

Microsoft SQL server, Error 2, SQL server When I started learning about databases in my sophomore year, I installed the database at the beginning. As a result, the first lab class of the database taught us how to install the database on our own machine. We also needed lab reports and, the teacher told me to uninstall

SQL Server synchronous replication troubleshooting method, SQL Server 1. the row cannot be found on the subscription server when the command copied by the application is run. Solution: Use System stored proceduresSp_browsereplcmds(Return the result set of the readable ve

server| Backup | data One: Back up the remote database, copy the backup files to the local, and then restore the database locally.Two: Copy the data files of the remote database with the log files to the local (the remote database service must be stopped before the copy can be copied), and then attach the database operation locally.Three: (Need to know the remote database login name and password) Open Enterprise Manager, on the

Tags: Service status Related Information script database state information Snapshot representationIn SQL Server replication (Replication), it is possible that the need for a new table or some tables to an existing replication (publish subscription) may occur due to changes in business requirements, which should be normal and common. However, in the existing replication (publish subscription) to add new tabl

necessary to identify a large number of space-occupying objects, such as: tables or indexes, and then by archiving historical data, the space is released first.2. The master data file (primary files) cannot be emptied. There are auxiliary data files that can be completely emptied.3. If you want to empty a filegroup, delete the objects (tables or indexes) assigned to the filegroup, or move them to another filegroup, DBCC Shrinkfile will not do the work for you.After the deleted data and objects