Modification date of objects

Hello there
Is there a way to know whan was the last time i've mofied objects? tables,
views, store procedures ect...?You can determine when they were created (crdate in sysobjects) but not
when they were modified. Use a source control system for that.
David Portas
SQL Server MVP
--|||That information is not available from SQL Server. If you really need it you
can use a product like Lumigent's LogExplorer to trail through your
transaction logs, but the best thing to do is use a Source Control system
like SourceSafe.
Jacco Schalkwijk
SQL Server MVP
"Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
news:OrVEKZIKFHA.2212@.TK2MSFTNGP12.phx.gbl...
> Hello there
> Is there a way to know whan was the last time i've mofied objects? tables,
> views, store procedures ect...?
>
>|||What is Source Control System?
And how can i get it and use it?
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:uIW6CkIKFHA.576@.TK2MSFTNGP15.phx.gbl...
> That information is not available from SQL Server. If you really need it
you
> can use a product like Lumigent's LogExplorer to trail through your
> transaction logs, but the best thing to do is use a Source Control system
> like SourceSafe.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
> news:OrVEKZIKFHA.2212@.TK2MSFTNGP12.phx.gbl...
tables,
>|||A Source Control program is an application that maintains a code
repository, records changing versions of code and logs who makes
changes and when. You can put into source control any stored procedure
scripts and DDL scripts for your database. Some form of source control
is pretty much essential if you have more than 1 or 2 people cutting
code. Of course, if you give DDL admin rights to your developers then
they still need to be disciplined enough to ensure they put every
change into source control...
SourceSafe is MS's source control offering and it's included with the
Enterprise editions of VisualStudio, or available as a separate
purchase. There are alternative products available though and you can
Google for those.
David Portas
SQL Server MVP
--

Missing perfmon SQL objects

I'm having an issue with a SQL 2000 cluster. On each node, there always
seems to be only one instance of perfmon SQL objects available at a time.
There are 3 instances of SQL installed on the cluster, default, PROD0 and
PROD1. On each physical node, opening perfmon to set up counters, there is
always only one set of SQL objects available. for example, as I write this,
only the default instance counters are available (SQLServer:<objectname>) on
the active node, but on the passive node, only the MSSQL$PROD0 objects are
available.
Any ideas?
Hello dwaine,
I understand that you could not see the performance counter in a SQL 2000
cluster environment.
You may use the following steps:
To get the counters loaded, SQL Server was taken offline and perfmon was
closed on the active node.
Simple Network Management Protocol (SNMP) service and the antivirus
software service were both stopped.
The following files were copied to the C:\Program Files\Microsoft SQL
Server\MSSQL\Binn folder:
From the SQL Server 2000 setup files: sqlctr.h
From the SQL Server 2000 sp4 setup files: sqlctr.ini and sqlctr80.dll
The following commands were run from the command prompt in the Binn folder
of the SQL Server instance:
unlodctr MSSQLServer
lodctr.exe \\VirtualServerName sqlctr.ini
net helpmsg %errorlevel%
Then, you will see the counter.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.