You can use osql with the -i[path to the script] parameter to run a script with telnet.

checl in BOL for all the parameters used by osql.

For me is impossible to append the full backups because of their size. I have one backup device for the full backups. And another backup device for diff and tlog...

You should separate the biggest tables in differents data files each on a separate filegroup. Then backup separately those filegroups during the week. The recovery strategy can get complicated with...

Thanks guys, it is done. It was very simple.

did you recieved this error in the distribution agent? Are you replicating changes with customs stored procedures? Does the error shows, wich stored procedure failed to execute?

Does your DTS package access a file on disk?

If it does, you should check that path.

Well, the fastest way is to execute:

EXEC sp_pkeys [TableName].

This will show you the fields of the pk

You could create a dts package to import to an excel file, and then run it with a stored procedure and the send it by email.

You can create an excel...

Run a trace with profiler to see what is EM executing...

I think you declare a cursor with one name, and then try to close it or fetch it with another name.

You should check the sintaxis. Check everywhere where you write...

Yes you are right, that sp is used by sql toreplicate the updates. You should create the stored procedure again. You can use

the stored procedure:

EXEC sp_scriptdynamicupdproc @ArtID

to let...

It seems that you are replicating stored procedures and you deleted one in the publisher, but sql coudn't deleted in the subscriber because it didn't exists.

You can create the stored...

Yes you can change the table structure with sp_repladdcolumn, but not the db structure.

If you want, to avoid syncronizing again with a snapshot, you can re syncro withhout the snapshot....

You wan't be able to change the db structure until you drop the publication. You need to drop the publication and change the merge publish property with the sp_replicationdboption stored...

And what was the originally size of the DB when you first create it?