SQL Server has it own Performance moniter to collect the metrics

I am not sure if this would help you.In SQL Server 7.0 when I used to run the stored procedure/query in the Query analyser by selecting the results in text...

Make sure that the SQL server agent service is running with a domain account with proper read write permissions on the remote server.

Hope this help.

Is it working fine if you are executing the stored procedure form Query analyser

xp_msver will give the latest version and full version of SQL Server and version of Operating system.

I don't think we can get all the sp's installed list with any of...

I think @@rowcount should give you the number of records inserted.

begin tran

select * into authors2 from authors

select @@rowcount

commit tran

Not sure if it works but try this.

CREATE PROCEDURE VO_ImportRates @file varchar(100) , @count varchar(20) OUTPUT, @rrcount varchar(20) OUTPUT AS

SET NOCOUNT ON

BEGIN

EXEC dbo.VO_Import 'vo..importrates','D:\BillingProject\ImportRates\',@file

END

BEGIN

INSERT INTO dbo.ratehistory (Country, Planname, Rate, EffectiveDate,...

\\servername\folder, make sure it has proper permissions.

Can you give more details about the kind server/servers which you are using.

There is an article by Steve,I think it will explan what you are looking for.

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

I Don't think so,it will have the objects of the Master database only.For all the Individual databases it will be in sysobjects under that database.

I think that should work.

Yo cannot restore the SQL Server 2000 Backup to SQL Server 7.But, you can do it the other way round.

Excellent Steve,This process is really simple.Next time when I need to move the master database I am going to take this approch.

I think it should be 8k since in Oracle it writes to the archivelogs page size(between 2k and 64k) you specify.