<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
how to i find out the user when stored...
how to i find out the user when stored procedure last modified
Rate Topic
Display Mode
Topic Options
Author
Message
cooljagadeesh
cooljagadeesh
Posted Monday, December 03, 2012 6:11 AM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 11:39 PM
Points: 23,
Visits: 122
Hi All,
how to i find out the user when stored procedure last modified
i am able to get the list of sp's modified date
using below Queries
select modify_date,* from sys.objects
select modify_date,* from sys.procedures
select last_altered,* from information_schema.routines
but not able to get the user name
Please provide solution
Post #1391895
GSquared
GSquared
Posted Monday, December 03, 2012 6:13 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442,
Visits: 9,571
Use source control for object changes in your database.
If you can't use source control, use a DDL trigger to track the changes.
But source control is really the correct solution.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1391898
cooljagadeesh
cooljagadeesh
Posted Monday, December 03, 2012 6:17 AM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 11:39 PM
Points: 23,
Visits: 122
how to create
source control
Post #1391901
rhythm.varshney
rhythm.varshney
Posted Monday, December 03, 2012 6:30 AM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, March 21, 2013 2:14 AM
Points: 77,
Visits: 184
cooljagadeesh (12/3/2012)
Hi All,
how to i find out the user when stored procedure last modified
i am able to get the list of sp's modified date
using below Queries
select modify_date,* from sys.objects
select modify_date,* from sys.procedures
select last_altered,* from information_schema.routines
but not able to get the user name
Please provide solution
Where are you maintaining the different versions of SProcs ?
Post #1391902
GSquared
GSquared
Posted Monday, December 03, 2012 6:34 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442,
Visits: 9,571
cooljagadeesh (12/3/2012)
how to create
source control
http://www.bing.com/search?q=source+control+sql+server
or
http://www.google.com/#hl=en&sugexp=les%3Bernk_timediscountb&gs_nf=3&gs_rn=0&gs_ri=hp&cp=15&gs_id=1l&xhr=t&q=sql+server+source+control&pf=p&tbo=d&output=search&sclient=psy-ab&oq=sql+server+sour&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&fp=ff2852371cfa3161&bpcl=39314241&biw=1920&bih=985
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1391905
Grant Fritchey
Grant Fritchey
Posted Monday, December 03, 2012 6:59 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 3:40 PM
Points: 13,380,
Visits: 25,164
To do source control management easily, you will need to introduce other tools. The two primary ones are SQL Server Database Toos (SSDT) from Microsoft. These are built into Visual Studio. If you have VS 2012, you get them for free. If not, there is a download somewhere for it. But, this tool does require you to use Visual Studio.
To stay within SQL Server Management Studio, you'll want to look to Red Gate Software (my employer) and our
SQL Source Control product
. I have an article I wrote on how to use our tool sets for
monitoring changes in your environments
.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #1391919
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
