MSSQL 2000: How can we track table/sp/function changes?

My company would like to start keeping track of everytime a table, stored procedure, or function is changed.
What is the best way to do this?Option 1)
Create a database for storing metadata on all the other databases. Nightly, run a query that loops across all database and records all the objects along with their checksum values, and notes any objects who's checksum value has changed.

Option 2)
Upgrade to SQL Server 2005 and create database triggers to log changes to objects.|||sourcegears vault, visual sourcesafe. nothing makes it into our software\database builds that is not in our sourcecode management software.|||Revoke sysadmin/DBO rights from everyone but the DBAs.|||As suggested you cna take help of Visual Sourcesafe or PVCS in order to take care of object changes.

mssql 2000 v/s raid 5ee

Hallo all
I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
install mssql 2000 on raid 5ee (win 2003server standard) i will have
better performance or not ? I know the best performance is no raid 10
but i dont have.
Hi,
The performance depends up on the volume of data and amount of access. Take
a look into the below URL .
http://www-03.ibm.com/support/techdo...Index/WP100350
Thanks
Hari
<ebolasty@.op.pl> wrote in message
news:1160926718.834857.267660@.k70g2000cwa.googlegr oups.com...
> Hallo all
> I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
> install mssql 2000 on raid 5ee (win 2003server standard) i will have
> better performance or not ? I know the best performance is no raid 10
> but i dont have.
>
sql

mssql 2000 v/s raid 5ee

Hallo all
I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
install mssql 2000 on raid 5ee (win 2003server standard) i will have
better performance or not ? I know the best performance is no raid 10
but i dont have.Hi,
The performance depends up on the volume of data and amount of access. Take
a look into the below URL .
http://www-03.ibm.com/support/techd...bIndex/WP100350
Thanks
Hari
<ebolasty@.op.pl> wrote in message
news:1160926718.834857.267660@.k70g2000cwa.googlegroups.com...
> Hallo all
> I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
> install mssql 2000 on raid 5ee (win 2003server standard) i will have
> better performance or not ? I know the best performance is no raid 10
> but i dont have.
>

mssql 2000 v/s raid 5ee

Hallo all
I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
install mssql 2000 on raid 5ee (win 2003server standard) i will have
better performance or not ? I know the best performance is no raid 10
but i dont have.Hi,
The performance depends up on the volume of data and amount of access. Take
a look into the below URL .
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100350
Thanks
Hari
<ebolasty@.op.pl> wrote in message
news:1160926718.834857.267660@.k70g2000cwa.googlegroups.com...
> Hallo all
> I know mssql2000 v/s raid 5 is dont work (very slowly). Who knows if i
> install mssql 2000 on raid 5ee (win 2003server standard) i will have
> better performance or not ? I know the best performance is no raid 10
> but i dont have.
>

mssql 2000 update from select

I am trying to update a table from a select statement, any suggestions?

update (select column1 from table1)
set column2 = 'value'

The data in column1 contains the name of the table I want to update column2 with the 'value'.

I'm am pretty sure the syntax is in correct along with the structure. The error...

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '='.

Quote:

Originally Posted by tdority

I am trying to update a table from a select statement, any suggestions?

update (select column1 from table1)
set column2 = 'value'

The data in column1 contains the name of the table I want to update column2 with the 'value'.

I'm am pretty sure the syntax is in correct along with the structure. The error...

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '='.

nope, the syntax is not correct. in this case you have to build the string for the entire update command..

set @.sqlcmd = 'update ..."

exec (@.sqlcmd)|||Please explain how to build.

MS-SQL 2000 Tape/Hardware Support

Hi,
Where can I find a list of supported tape drives by MS-SQL?
For example: DDS, DLT etc.
Thanks
Shiri Tzuk
Shiri Tzuk wrote:
> Hi,
> Where can I find a list of supported tape drives by MS-SQL?
> For example: DDS, DLT etc.
> Thanks
I don't know if such a list exists, but why don't you just backup your
databases to disk? You can then let your backup program backup the files
to tape because now it's just a regular file backup.
Regards
Steen
|||Hello Steen,
Thanks for your reply.
We would like to backup to tape since our customers (that using our product)
request for that feature. We also provide of course the ability to backup to
the network.
The customers also can decide which tape drive and this is why I need to
know if there is a limitation in that area.
Shiri
Shiri Tzuk
"Steen Persson (DK)" wrote:

> Shiri Tzuk wrote:
> I don't know if such a list exists, but why don't you just backup your
> databases to disk? You can then let your backup program backup the files
> to tape because now it's just a regular file backup.
> Regards
> Steen
>

MS-SQL 2000 Tape/Hardware Support

Hi,
Where can I find a list of supported tape drives by MS-SQL?
For example: DDS, DLT etc.
Thanks
--
Shiri TzukShiri Tzuk wrote:
> Hi,
> Where can I find a list of supported tape drives by MS-SQL?
> For example: DDS, DLT etc.
> Thanks
I don't know if such a list exists, but why don't you just backup your
databases to disk? You can then let your backup program backup the files
to tape because now it's just a regular file backup.
Regards
Steen|||Hello Steen,
Thanks for your reply.
We would like to backup to tape since our customers (that using our product)
request for that feature. We also provide of course the ability to backup to
the network.
The customers also can decide which tape drive and this is why I need to
know if there is a limitation in that area.
Shiri
--
Shiri Tzuk
"Steen Persson (DK)" wrote:

> Shiri Tzuk wrote:
> I don't know if such a list exists, but why don't you just backup your
> databases to disk? You can then let your backup program backup the files
> to tape because now it's just a regular file backup.
> Regards
> Steen
>sql