February 15, 2013 at 7:41 am
Hi guys.
I'm trying to query when a database file is created but somehow I didn't find anything that would give what I need. Like for example if there's a new .ndf file added, I wanted to know when was that file added.
Is there a way get this information?
Thank you.
Antonio
February 15, 2013 at 8:25 am
Hey Antonio, have a look at this article by Greg Larson.
http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/
February 15, 2013 at 10:18 am
Erin Ramsay (2/15/2013)
Hey Antonio, have a look at this article by Greg Larson.http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/
Thanks Erin for the quick reply.
This article is great. There's also a T-SQL solution posted by Phil Factor.
Anyway I could have just go directly to the directory and look at what the create of the file.
It's nice that I can get these information with T-SQL.
Really appreciate it.
Thanks,
Antonio
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply