SQL Server
Recently i was working on one of my SQL Server database project and i got this error message "The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)" I spent good couple of hours to dig the problem and finally find the solution. The reason for error is [...]
Continue reading about SQL Server Error database principal owns schema cannot be dropped
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 [...]
You need to make both sides of a where condition, the same. I.E. … where JSG_Transactions.dbo.JSG_students.student_id COLLATE SQL_Latin1_General_CP1_CI_AS = convert(varchar(12),src.stu_code) COLLATE SQL_Latin1_General_CP1_CI_AS This forces them to be the same, and will do the comparison without winging.
Continue reading about Resolving SQL_Latin1_General_CP1_CI_AS errors
