You can execute something like this:

DECLARE @query AS NVARCHAR(300)

SELECT @query = 'SELECT databasepropertyex ('+''''+'master'+''''+', '+''''+'Recovery'+''''+')'

EXEC [ServerName].master.dbo.sp_executesql @statement = @query

I also have many servers across my country, But fore me it...

Did you check the error log?

Any unusual?

Did you or someone change anything in the server?

The upgrade to BOL in SP3 you can find it here

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

you have to manually installed it.

If in the title of the BOL windows, it says "SQL Books On Line (Updated...

Declaring a cursor with all the sp names, and then execute sp_helptext for each one.

DECLARE @sp-2 AS SYSNAME

DECLARE curSP CURSOR LOCAL FOR

...

Don't have much documents.

All I can say is that you first must create a dial up connection, then with rasdial, you can connect to that connection.

What I did was this....

you can use sp_password:

EXEC sp_password 'OldPass', 'NewPass', 'sa'

I guess you meant wich columns have indexes on them.

With sp_helpindex TableName, you can see this.

If you have primary keys with clustered indexes, you also can use sp_pkeys TableName.

It should work anyway.

Is there a chance that the users that can't exec the sp, has deny permissions on any other role, windows group on directly to their users?

EXEC sp_spaceused TableName

Can you tell us who is the owner of the sp, what the sp do, wich objects and owners that it query?

IN heterogenous subscribers you can trasnform the data to be published before inserting it into subscriber.

You can execute a DTS package to get any transformation.

I've done it once.

I dind't found any problems.

It will al depend of how much transactions you will deliver each time you connect.

When I did it, I create a batch...

Run

SELECT SERVERPROPERTY('collation')

to be sure.

Yes you can...

sp_lock returns the id ob the object that are locked.

With: SELECT OBJECT_NAME(IDNumber)

you will know with object it is.

Both sp_validatemergepullsubscription and sp_validatemergesubscription are very similar

but the second one is more complete, because it not include push subscriptions but also pull.