jmetape,

I think that will work very well.

Thanks

Ratbak,

I should be selecting DonationYear, just didn't think of it when I was doing some preliminary testing.

The Receipt # can be any sequence although likely will be DonationYear and a...

I'll have to play around with this to see when it occurs.

I know with DDColumnObject, I deleted a column and added another one.

In DDErrorLog, it was a column deleted

I think...

All tables would have been modified with SSMS GUI.

DDIndexColumn was also been modified with the GUI yet has the correct Create Date.

Hi Jeff,

The use case I have is creating a data dictionary and need to indicate what tables/columns are used in a View.  The column attributes are also listed.

One User View...

Hi Brian, thanks for your reply and sorry for my delayed response.

I tried removing the where clause in your response and did not get the tables/columns I was looking for,...

To me, the wording is questionable because the answers start "This can return a table …” which means it can return something else.

The TechNet article I referenced said "Inline user-defined...

Thanks for your suggestions.

After a demo of the proposed application UI to the user, it looks like a large part of their ad hoc reporting requirements could be...

I am somewhat surprised as to how much of conversation this question has raised.

Replies to multiple comments:

This is a new system that will replace an existing system, however additional requirements...

Sean is grasping the problem. I'm concerned about data integrity and having to enforce more rules in the business logic (which will be complex enough as it is)

If I...

My turn to apologize now. I was on vacation when you posted the answer. I attempted to post a reply at that time but it looks like it...

I've put the table creation back in case you dropped them and to make relating a bit easier

USE [test]

GO

/****** Object: Table [dbo].[tM_PolProd] Script Date: 1/21/2016 8:01:10...

Thanks. I'll look at this in detail.

As to your comments from the previous post:

1) The deletion of the cursor was a practice from a previous DBA so I just...

Delete is controlled by the application and there will only be one record deleted at a time.

Only one user uses this function so multiple concurrent deletes are unlikely, if not...

As requested, here's additional code related to this issue.

As to the statement "...that multiple instances of the stored procedure run in parallel and the second drops the cursor ..." I...