<div>
Timely and accurate response.
</div>


<div>
<div class="content wysiwyg-content">
Currently users are unable to see the data types of columns which they have data reader rights to for a particular database. This database is replicated (if this has anything to do with it) and multiple users are experiencing the same issues. I have sysadmin and see it without any issues. We are using SQL server 2012 Enterprise.<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/07_w28/922697/Column-data-types.PNG" target="_blank" title="Columns with data types (38 KB)"><img alt="Columns with data types" class="file-block lazyload" style="max-width: 390px;" data-src="https://filedb.experts-exchange.com/incoming/2015/07_w28/922697/Column-data-types.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/07_w28/922699/Data-properties.PNG" target="_blank" title="properties of a column with its data types (67 KB)"><img alt="properties of a column with its data types" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/07_w28/800_922699/Data-properties.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/07_w28/922700/no-Column-data-types.PNG" target="_blank" title="columns without data types (13 KB)"><img alt="columns without data types" class="file-block lazyload" style="max-width: 364px;" data-src="https://filedb.experts-exchange.com/incoming/2015/07_w28/922700/no-Column-data-types.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/07_w28/922702/no-Data-Properties.PNG" target="_blank" title="properties of a column without data types (92 KB)"><img alt="properties of a column without data types" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/07_w28/800_922702/no-Data-Properties.PNG" /></a>
</div>
</div>


Column-data-types.PNG

properties of a column with its data types

Data-properties.PNG

no-Column-data-types.PNG

properties of a column without data types

no-Data-Properties.PNG

Currently users are unable to see the data types of columns which they have data reader rights to for a particular database. This database is replicated (if this has anything to do with it) and multiple users are experiencing the same issues. I have sysadmin and see it without any issues. We are using SQL server 2012 Enterprise.




Unable to view column data types in SSMS

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.