2012 to 2000 using ODBC 2016-10-18 wo 電腦小知識 USE master GO — Drop Existing LinkedServer [[……]查看全部 Database, Linked Server, MSSQL, Program
transfer logins and passwords between instances of SQL Server 2016-10-18 wo 電腦小知識 –generate script from 2000 to 2005 –ref: http[……]查看全部 backup restore, Database, Example Query, MSSQL, Program
generate restore script 2016-10-18 wo 電腦小知識 DECLARE @name VARCHAR(50) — database name DE[……]查看全部 backup restore, Database, Example Query, MSSQL, Program
copy MDF and generate attach 2016-10-18 wo 電腦小知識 DECLARE @name VARCHAR(50) — database name DE[……]查看全部 backup restore, Database, Example Query, MSSQL, Program
backup all to .bak 2016-10-18 wo 電腦小知識 DECLARE @name VARCHAR(50) — database name DE[……]查看全部 backup restore, Database, Example Query, MSSQL, Program