This works should show you how to do it

Bryan

declare @Tablename varchar(400)

declare @x varchar(200)

declare curtable cursor

for

select name

from sysobjects

where type='U'

order by name

open curtable

fetch next

from curtable

into @x

set @x='select count(*) from '+@Tablename

print @x

exec...

SQL 2005 should work fine but I have not had a chance to try it.

you will not be able to do this SQL Server does not support calling C# managed dll's u will need to rewrite in C++ or Delphi or something similar

You could schedule a windows schedule job to run net stop service been the sql service and than start it would not run it from a SQL Job.

Set the sql servers as an active/active cluster and u can put different databases on each cluster but still have failover protecion for each node of the cluster.

As long as you only use SQL 2000 functionality on the SQL 2005 server it will work for all your customers you can set the compatability level to SQL 2000...

Why not script all the stored procs change them from create to alter insert the line you need in the text file and rerun the script so it alters all...