You can use isqlw instead of osql.

isqlw is the way to execute QA by the command line. If you don't specify any parameters then is like opening QA, but if...

With a stored procedure you won't be able to schedulle the execution of the query.

You can do it with a Job from SQL, or from outside using a schedulle task...

Yes that should work. But you must be sure no transactions where made in the middle because they won't be replicated.

Due to a bug in SQL 2000, sometimes you can...

I have to run checkdb with the repair_Rebuild option a couple of times, and usually to repair a database, have to execute it several times (sometimes at least 5).

If...

If DBCC CheckDB finds any problem then running DBCC CHECKDB with the REPAIR option will require your db to be in single user mode.

Run a CHECKDB manually, and if it...

You can export the sp to a text file, running with a cursor an OSQL string that saves the output to a text file.

With this you will get as many...

did you run a checkdb in database DEVELOP?

nested procedures calls are allowed, but you will have problems if you populate tables in this way.

INSERT INTO Table

EXEC WhatEver

Maybe you can give us an example of some records in your table.

Try using functions like RIGHT, LEFT, SUBSTRING in a select query instead of the cursor, but still it...

If you are going to query the remote server frecuently then I suggest to set up a linked server.

You must check the security and the queries are going to be...

I think the problem is in Excel.

You must set the field format to text, so that you can maintain the leading zeroes.

I would suggest to start the distribution agent with the distrib.exe file.

You can view all the parameters in BOL lookin for distribution agent\Starting.

Executing the...

Bulk inserts don't fire triggers by default. You shoud specify the fire FIRE_TRIGGERS syntax in the bulk insert command.

Or:

declare @iRows int

set @iRows = 10

EXEC ('SELECT TOP ' + convert(char,@iRows) + ' * from TableName')

If the master server goes down, all the jobs in the target server will remain executing according to the original schedulle as if the master server still exists.

But the history...