ENV: SQL Server 2000
Have looked at sysobjects table with xype value of "P" and all its
attributes, not sure there's a way to do that. Your thought?
TIA.
4  1263 
NickName (da****@rock.com) writes: ENV: SQL Server 2000
Have looked at sysobjects table with xype value of "P" and all its
attributes, not sure there's a way to do that. Your thought?
Correct. There is a crdate, but there is no moddate, so if someone
use ALTER PROCEDURE, you can't tell. Well, the column schema_ver is
updated with 16 at each alter, so if you have an old version of the
table, you can compare. But you can't say exactly when.
The good news is that the new catalog views in SQL 2005 do have a
modified_date.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
NickName (da****@rock.com) writes: ENV: SQL Server 2000
Have looked at sysobjects table with xype value of "P" and all its
attributes, not sure there's a way to do that. Your thought?
Correct. There is a crdate, but there is no moddate, so if someone
use ALTER PROCEDURE, you can't tell. Well, the column schema_ver is
updated with 16 at each alter, so if you have an old version of the
table, you can compare. But you can't say exactly when.
The good news is that the new catalog views in SQL 2005 do have a
modified_date.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"The good news is that the new catalog views in SQL 2005 do have a
modified_date. "
Glad MS would correct the oversight, thanks for the info.
"The good news is that the new catalog views in SQL 2005 do have a
modified_date. "
Glad MS would correct the oversight, thanks for the info.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark |
last post by:
Hi yall
I'm a newbie, forgive me...
I am sure I have seen a simple way to do this, but I can't for the life of
me remember how it was done...
Say there is a database of jokes, from...
|
by: Brian McGonigle |
last post by:
I'm a Perl programmer learning Python (up to chapter 7 in Learning
Python, so go easy on me :-) and I find that I look to do things in
Python the way I would do them in Perl. In Perl functions and...
|
by: Nova's Taylor |
last post by:
Hi folks,
I am a newbie to Python and am hoping that someone can get me started
on a log parser that I am trying to write.
The log is an ASCII file that contains a process identifier (PID),...
|
by: googleboy |
last post by:
I didn't think this would be as difficult as it now seems to me.
I am reading in a csv file that documents a bunch of different info on
about 200 books, such as title, author, publisher, isbn,...
|
by: Gary |
last post by:
Does anyone know how to do a sort to find the most recent distinct records.
We have records with equipment, and activities the equipment was used for,
but I need a distinct list of where the...
|
by: Dave |
last post by:
1) I know that we can define an external proc to be Fenced or NotFenced on
"CREATE PROCEDURE" command.
I don't see the FENCED / NOT FENCED option on "Create Procedure" for SQL
stored procs.
Is...
|
by: yeti349 |
last post by:
Hi, I'm using the following code to retrieve data from an xml file and
populate a javascript array. The data is then displayed in html table
form. I would like to then be able to sort by each...
|
by: Platero |
last post by:
Hi, how can I get the most recent dated file (or the last
created/modified) in a specified directory?
Thanks
|
by: zacks |
last post by:
Most applications whose purpose is to work with various types of files
implement a "Most Recent Files" list, where the last, say, four files
accessed by the application can quickly be re-opened by...
|
by: James Mills |
last post by:
On Fri, Oct 31, 2008 at 8:49 AM, mark floyd <emfloyd2@gmail.comwrote:
Mark, this is correct behavior. You have
3 positional arguments in the function
definition. You _must_ aupply _all_ 3
of...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
