Also verify the current collation, if column is nvarchar.

But first verify duplicates

-- List duplicates for column

select A.<column_name>

from <table_name> as A

left outer join <table_name> as B

...

Object schema is sometimes good to know.

select "Schema" = object_schema_name(so.object_id), * from sys.objects as so

where so.modify_date > dateadd(month, -2, getdate()) and so.object_id > 0

order by "Schema",...

Interesting one. We only use SSMS, and use the database diagram feature to visualize the ER-diagram. To back up the diagrams I use a script, that’s generate DDL-script to restore...

Any foreign key between Admin.RequisitionLifeCycle.RequisitionID and purchase.Req.RequisitionID?

Do they have own index or primary key?

Could this https://msdn.microsoft.com/en-us/library/cc645938.aspx help ?

Hi!

I maybe misunderstands your question, but you want your app login (prduser) to only have execute rights to procedures and functions?

You don’t add rights to a login object, you should...

My favorites to retrieve column information

-- Find nullable columns

select TABLE_NAME, COLUMN_NAME, DATA_TYPE from INFORMATION_SCHEMA.COLUMNS

where TABLE_NAME in (select name from sysobjects where type='U')

and IS_NULLABLE = 'YES'

...