If you try to drop a user that owns a schema, you will receive the following error message: The database principal owns a schema in the database, and cannot be dropped. In order to drop the user, you need to find the schemas they are assigned, then transfer the ownership to another user or role [...]
Archive of posts tagged SQL Server 2005
Insert Carriage Return Line Feed to String
Here is a clean and efficient way to embed carriage returns into a string. I prefer this way instead of concatenating the entire CHAR(13)+CHAR(10) to the end of every string. This replace function also comes in handy in most instances where you need to append strings. declare @Note varchar (200) SET @Note = ‘Line One.[crlf];Line [...]
