SQL Server 2008 R2
Nov
1
admin on November 1st, 2011
I got this error when creating tables from one datase to another SQL Server database today. How to solve it: Change to single-user mode in your database Command to change Single-User mode or Mutilple-User mode in sql server database ALTER DATABASE [Works] SET MULTI_USER WITH NO_WAIT ALTER DATABASE [Works] SET SINGLE_USER WITH NO_WAIT 2. [...]
Save (Not Permitted) Dialog Box SQL Server 2008 R2 The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created. The following actions might require a table to be re-created: Adding a new column to the middle [...]
