Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

identify which user creates the foreign key (creator name) Expand / Collapse
Author
Message
Posted Monday, June 29, 2009 11:27 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, January 21, 2016 1:45 PM
Points: 60, Visits: 247
Hi All,

pls tell me how to identify which user creates the foreign key (creator name)
Post #744172
Posted Tuesday, June 30, 2009 8:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 19, 2016 7:56 AM
Points: 10,787, Visits: 14,727
I don't know of any way to tell this unless you have a DDL trigger that saves the data.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #744467
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse