1.master database only allows fullness and cannot back up the transaction log, otherwise the following error will appear (using Maintenance Plan backup): SQLMAINT.EXE Process Exit Code: 1 (failed) MSG 22029, SEV 16: Sqlmaint.exe failed. [SQLState 42000] Backup can not be Performed on Database 'Master'. This Sub Task is Ignored.
2. In the same maintenance plan, if a database's Recover mode is Simple, it will cause the following error 3 (Schedule 1). The Last Step To Run WAS STEP in the Job Was Invoked by SIMPLE. 1 (Step 1). [SQLSTATE 42000] (Error 22029). Solution: Set all Database's Recover mode of all Databases of Maintenance Plan to Full or Bulk-logged will not pass Recover mode Database is divided into different maintenance plan to take different strategies. Insert Query's results into a new table Select * Into db1..newtable from db2..oldtable
Insert Query's results into an existing table insert Into db1..table select * from DB2..OHTABLE
Change the DBOUSER DBNAMESP_CHANGEDBOWNER 'login' change Object 'Object', 'login'
How to Sort SqlServer Sorting Select * from TablenameOrder by CustomernameCollate Chinese_Prc_Stroke_ci_as
