Archive for February, 2012
Resolving MSB3247 – Found conflicts between different versions of the same dependent assembly
February 24th, 2012 | 
Author: Change the “MSBuild project build output verbosity” to “Detailed” or above. To do this, follow these steps:
1.) Bring up the Tools/Options dialog (Tools->Options…).
2.) In the left-hand tree, select the Projects/Solutions node, and then select Build and Run.
*** Note: if this node doesn’t show up, make sure that the checkbox at the bottom of the dialog (“Show all settings”) is checked.
3) In the tools/options page that appears, set the MSBuild project build output verbosity level to “Detailed” (assuming you’re on VS2010; “Normal” will suffice in VS2008 or older).
4) Build the project and look in the output window.
WordPress block trackback
All those annoying sites trackback all kind of spam …
You want to stop that?
Easy,
Turn off trackback and ping back from Admin
Settings -> Discussion ->
uncheck : Allow link notifications from other blogs (pingbacks and trackbacks.) .
After this, to prevent the ping/trackback for existing posts, run this sql command:
or … the hard way, edit all posts and disable pingback
MSSQL Change Table Column name
to change a column name in MSSQL, run this query:
SQL Table Ownership Change
To change sql table owner from a name to dbo, use this sql:
SELECT @crtOwner= 'currentOwner_ToChange', @newOwner = 'dbo'
, @SQL = '
IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
WHERE
QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
AND TABLE_SCHEMA = ''' + @crtOwner+ '''
)
EXECUTE sp_changeobjectowner ''?'', ''' + @newOwner + ''''
EXECUTE sp_MSforeachtable @SQL
For stored procs, execute this stored proc to get the sqls required for changing the owner.
Then copy the resulted sqls and run them in a new query.
SELECT @crtOwner= 'currentOwner_ToChange', @newOwner = 'dbo'
SELECT 'EXECUTE sp_changeobjectowner '''+QUOTENAME(a.SPECIFIC_SCHEMA)+
'.'+QUOTENAME(a.ROUTINE_NAME)+
''','''+@newOwner+''''
FROM
INFORMATION_SCHEMA.ROUTINES a
WHERE
a.ROUTINE_TYPE = 'PROCEDURE'
AND a.SPECIFIC_SCHEMA = @crtOwner
AND
OBJECTPROPERTY(OBJECT_ID(QUOTENAME(a.SPECIFIC_SCHEMA)+'.'+QUOTENAME(a.ROUTINE_NAME)), 'IsMSShipped') = 0
for views:
SELECT
@crtOwner = 'currentOwner_ToChange', @newOwner = 'dbo'
SELECT 'EXECUTE sp_changeobjectowner '''+QUOTENAME(a.TABLE_SCHEMA)+'.'+QUOTENAME(a.TABLE_NAME)+''','''+@newOwner+''''
FROM
INFORMATION_SCHEMA.VIEWS a
WHERE
a.TABLE_SCHEMA = @crtOwner
AND
OBJECTPROPERTY(OBJECT_ID(QUOTENAME(a.TABLE_SCHEMA)+'.'+QUOTENAME(a.TABLE_NAME)), 'IsMSShipped') = 0