Wednesday, March 26, 2014

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

Saturday, March 22, 2014

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

Thursday, March 13, 2014

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
Powered By Blogger · Designed By Seo Blogger Templates