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
...
Friday, June 30, 2017
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...
