Change schema of all tables in database

To change schema of any table/stored procedure you can use this command: ALTER SCHEMA NewSchemaName TRANSFER OldSchemaName.ObjectName But when you want to change schema of all table/sp of a database then its not a good idea to write such lines for all objects. better idea is to generate such script and then run it.. to generate such script for all tables, stored procedures and views, you can use below script.

SELECT 'ALTER SCHEMA NewSchemaName TRANSFER ' + SysSchemas.Name + '.' + DbObjects.Name + ';'
FROM sys.Objects DbObjects
INNER JOIN sys.Schemas SysSchemas ON DbObjects.schema_id = SysSchemas.schema_id
WHERE SysSchemas.Name = 'OldSchemaName'
AND (DbObjects.Type IN ('U', 'P', 'V'))

now just copy the output of this script and run...

Compiled by: Rajesh Rolen

Read More

Prevent addition of default paragraph tag by ckeditor

to prevent addition of default paragraph tag

by ckeditor we have to add below lines in config.js

CKEDITOR.editorConfig = function (config) {
    config.enterMode = CKEDITOR.ENTER_BR;
    config.shiftEnterMode = CKEDITOR.ENTER_BR;

Read More

HTTP could not register URL . Your process does not have access rights to this namespace

HTTP could not register URL http://+:8080/FileTranfer/.

Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details).

 The issue is that the URL is being blocked from being created by Windows.

 Steps to fix:
Run command prompt as an administrator.
 Add the URL to the ACL netsh http add urlacl url=http://+:8080/FileTranfer/ user=mylocaluser

Read More