I meant in the first exec.

Don't know the exact explanation, but it is like it is executed in a diferent context or connection.

If you create a #temp table with EXEC...

You should also add the @srvproduct = 'Oracle' parameter.

You must put the update inside the EXEC.

EXEC ('update what ever')

Or declare @strUp AS VARCHAR(300)

SELECT @strUp = 'Update whatever...'

EXEC (@strUp)

Check dbcc shrinkfile (EMPTYFILE  parameter).

First you need to move all the data that is in the file to another file of the same filegroup. And then you will be able...

It will also depend, where you save your DTS Package

It will also depend, where you save your DTS Package

But how do you manage that subscribers connect to a publisher with a diferent name than the original??????

Are the in secuence? Can you use between instead of IN?

You can use logevent.exe windows command, and execute it with xp_cmdshell from SQL.

This program allows you to write any error with the id and shource that you need.

You won't be able to dettach/attach in the publisher, but you should be able at the subscriber.

you could try altering the database to create new files in the partition and...

That sp is executed when you add the subscription.

Are you using EM or sp_addsubscription? If using sp, then check the parameters that you are using because it seems that...

No. You must drop all subscriptions from the subscriber to all publisher.

Create new publication in new publisher, subscribe all your subscribers, generate the snapshot and sincronize again.

Check in the Server NetWork Utility and in the properties of TCP, check the port that it is configured.

Also, if in the server another aplication/process uses the same port by...

Mmm...

I would first try DBCC CHECKDB or CHECKTABLE with REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS first.

You should stop the sql Agent before running sp_dboption to put the db in single user mode.

If it...

Please, run sp_helpreplicationdb to check with databases are marked for replication.

Distribution is for replication but should not be marked for replication, so you should be able to restore it at...