View SQL table schema or definition

To view table schema definition one option is to right click table name view in design mode, other simple option is to view it through following query:

sp_help 'table_name'

It shows following:

• When table/object is created & its owner
• DDL of table (column name & its type & other definition details)
• Identity, indexes, contraint & foreign key this table/object is reference as

Read More

Temp path is too long while publishing website project

While publishing my asp.net mvc website I got following error:

Issue:

ASPNETCOMPILER(0,0): Error ASPRUNTIME: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. 5>

Solution:

For me following solution works:

• Go to web project folder e.g D:\Projects\SomeProject
• Then go to Properties\PublishProfiles folder.
• Open profile file in some editor i.e. profile_name.pubxml (not the file with *.pubxml.user)
• Add following under <PropertyGroup> tag
• <AspnetCompileMergeIntermediateOutputPath>c:\SomeShortTempPath\</AspnetCompileMergeIntermediateOutputPath> 
• Save file & publish it again, it works like charm
• Happy development

Read More