find all sql server instances on network

That's all. The stored procedure calls mup_geta (I erased the project-related names) You can view objects dependent on mup_geta through the functions provided by sqlserver graphics manager. The result is a bit confusing. I didn't list mup_getb (I used SQL Server 2005) The solution is as follows:Method 1:Choose Database Management> right-click Database

Deletes all indexes of the specified table, including primary key indexes, unique indexes, and normal indexes, for SQL Server 2005,Instructions for use:1. Execute the script first to create the stored procedure in the database2, call the method, take the gold partner database as an exampleUse VELCROMFM--database name, replace with specific itemGoDECLARE @tableNam

DECLARE @i int, @id int, @dbname varchar (255), @sql varchar (255) Set @i = 6 Set @id = (select count (*) from Master: sysdatabases) drop table #tcreate table #t ( dbname varchar (255), tablename varchar (255), ColumnName varchar (255)) while (@i 　　SQL Server Single Library:SELECT Sysobjects.name as TableName, syscolumns.name as columnname from sys

Label:Today let me back up all the databases on the Internet, jerked a look, hundreds of, the pit dad, had to find on the internet is not easy, did not think that there is really a note down, after use, haha ...Use master declare @DbName varchar DECLARE @BackSql varchar (+) declare mycursor cursor for SELECT [name] from sysdatabases where [name] "not" (' Master ', ' model ', ' msdb ', ' tempdb ') order BY [

Click Manage/SQL server proxy/jobCreate a job:On the General tab, enter "name" in "regular backup database", "enable", select "check", and "target local server ","Category" select "database service ",On the "Steps" tab, create a step. Step name: backup database; Type: Transact-SQL script (TSQL ); Database: the database

Tags: des blog http io ar os sp div onOriginal: Deletes all indexes of the specified table, including primary key index, unique index, and normal index, for SQL Server 2005,--Delete all indexes in the specified table--usage: DECLARE @tableName varchar--set @tableName = ' table name '-The table name, replacing--exec Sp_

Label:To terminate with a stored procedure:Create a terminating database for all successive stored procedures under Query Analyzer, by calling the stored procedure to close all connection operations that use the database.--Create a stored procedure that terminates all processes under the database, with the parameter database nameUse masterGoCreate proc Killspbydb

? method is to use the DISTINCT keywordSELECT DISTINCT vend_id from Products -- Analysis: SELECT DISTINCT vend_id tells the DBMS to return only (unique) vend_id rows. If you use the DISTINCT keyword, you must precede the column name directly. 　　Note The DISTINCT keyword is used for all columns, except that the two columns are exactly the same, and all rows are retrieved2.6 Limiting resultsThe SELECT s

When I helped the team to connect to the database and check the database, I tried it on my own machine and found that my database was indifferent; Right-click my database server and choose ------> properties -----> error: Then I found it online and it seems that I couldn't solve it. Later, I tried to solve it with my own unremitting efforts: You can copy xplog70.dll from the binn folder under the directory of the normal ms

1. Empty all table data in SQL Server database(1) Write the stored procedure script:CREATE PROCEDURESp_deletealldata asEXECsp_msforeachtable' ALTER TABLE? NOCHECK CONSTRAINT All 'EXECsp_msforeachtable' ALTER TABLE? DISABLE TRIGGER All 'EXECsp_msforeachtable' DELETE from? 'EX

SQL Server queries all database names, table names, and field names. For more information, see. SQL Server queries all database names, table names, and field names. For more information, see. 1. Get

In the query analyzer, perform the following three steps in sequence, where databasename is your database file name 1. Clear logs: dump transaction databasename WITH NO_LOG 2. truncate transaction logs: backup log databasename WITH NO_LOG 3. shrink the database: dbcc shrinkdatabase (databasename) --/////////////////////////////////////// /////////////////////////// SQL Server Log clearing methodOne method:

Database environment: SQL SERVER 2005 An existing product sales Real-time table, table data as follows: The field name is the product name, the field type is the sales type, 1 is sold, 2 is the return, the field num is the quantity, and the field CTime is the operating time. Requirements: Count the sales (sale, return) of all goods within 24 hours on one li

Solution: It is not possible to directly attach or attach data. It is certainly no problem to use script + to export data. Steps for transferring sql2005 to SQL2000 1. Generate database scripts for version 2000 Manger studio in sql2005-- Open "Object resource manager" (if not, press F8) to connect to your instance-- Right-click the database to go to 2000-- Task-- Generate scripts-- In the "select database" in the "script wizard", make sure that the selected database is to be transferred to

This is because the additional database is in the Sql2005 format, and the Sql2000 appending is used. This is because the additional database is in the Sql2005 format, and the Sql2000 appending is used. Solution: It is not possible to directly attach or attach data. It is certainly no problem to use script + to export data. Steps for transferring Sql2005 to Sql2000 1. Generate database scripts for version 2000 Manger studio in Sql2005 -- Open "Object resource manager" (if not, pr

(or 127.0.0.1) on the TCP port add 1433, and then click Apply5, modify the "IPALL" all the ports to "1433" (or this interface, pull down the scroll bar)6. Restart the service7, through the above 1-6 steps to set up a good port, reopen SQL Server Management Studio, the server name input: (local) or 127.0.0.1, you can l

Tags: article immediate access Owner Personal filter exe div tinOriginal: Remove and add publications in SQL Server replication without initializing all items--If you "Prohibit schema changes" in advance, the new columns will not automatically add a large release, you should use Sp_articlecolumn to add the column exec sp_changepublication @publication = N ' publi

Just loaded SSMS 17.1 preparation experience, pop up:A search, the general approach is to install VS2015 stand-alone shell, delete a registry key what, useless, first this shell I was loaded, and then there is no that registry key. I try to overload the shell and reload the SSMS17, it is useless.Then try to "fix" the VS2015 independent shell after the problem is resolved. Specific operation: Find "Microsoft Visual Studio Shell (standalone)" In t

SQLServer no selectPr_Nameas [Stored Procedure], [Parameter] stuff (select, + [Parameter] from (selectPr. nameasPr_Name, parameter. name ++ Type. name + (+ convert (varchar (32), parameter. max_length) +) asParam SQL Server queries all stored procedure information, triggers, and indexes without the select Pr_Name as [Stored Procedure], [Parameter] = stuff (select

has both "SQL Native client 10.0 configuration (32-bit)" and "SQL Native Client 10.0 Configuration", the test finds that the alias of the "SQL Native Client 10.0 configuration (32-bit)" setting is provided to: find S The QL server Publisher uses an error message similar to