What service pack do you have?

I don't think you can update a job step while is still running. Even do, I don't think SQL would execute the new job step.

Can you create the job with...

Specify when you are adding the articles with sp_addarticle the paremeter @source_owner = N'dbo'.

Or with enterprise manager, in the articles tab, check every table, and specify the object owner....

I've never looked for the size in sys tables, so if you say that it doesn't exists I guess you are right. I think that you can execute:

Create table tmp_Size

(Size...

You can create a dts package to export the db, and then schedule from a job.

For creating a dts package check BOL.

I think the library db is a db from a Microsoft Certified Course of SQL server.

I think they give you the structure of the db in a script and then...

Try adding an alias in the client net library with the specified port

I think you should script the entire datavase with EM, and then after the installation of you app, run a osql that calls the file you created before. With SQL...

I would create the jobs with EM, script it and then create a master sp with all the job SPs included. You should change all the variables that you want...

If you have restored the last tlog backup with norecovery there 's no need to start all over again. Just execute restore log device_log with recovery and that 's it.

...

Also check sp_who2. It shows more info

I've installed SQL 2000 on a win2000 server with the Remote Desktop downloaded from microsoft web page and I didn't have any problems.

Can you post more details about when this is happening, or if you are having any errors...

Remember that the page split will only occured once the page is full not with every insert. To delayed this rememeber the fillfactor thing and also consider with pad index,...

Truncate the lo (with backup log DBNAME with Truncate_only) then ahrink the log File and then backup the database. The backup files should be smaller