When using the ListAvailableSQLServers method of the application object, I think it uses the configuracion of the network library in the pc you are working on. This is by default,...

You should start sql from the command line using sqlservr.exe to view the log and check if there is any error during start up.

Where you able to connect before. Any...

First you should remove the subscriptions (pull or push) from all your publications.

Then remove the publications and once you don't have any, remove the distributor.

When removing replication, for me it...

You could try using quotename in your queries.

Check BOL for usage.

You shoudn't create tables begining with sys, so all the tables with that word, should be also system tables.

Agree. The only way is to remove the replicated table from the publication and then truncate the table.

with the sp sp_addarticle you must add each table independently.

I did it once, because have many tables to add to a publication and create a cursor with the tables I...

Do you have available space in the disk that you are trying to create the replication database.

In the wizard it shows the path where the db wil be created.

you can try master.dbo.xp_fixeddrives

Can be done with SQL-DMo.

The SQLReplication Object, has an event called Status, wich will return a message (How many transactions are been replicated) and a percentage value (wich can be...

There are several ways.

You can use Merge replication.

Also Transactional replication with inmediate or queue subscription.

Or also can set up a transactional publication in the publisher, another transactional in the subscriber...

VB, right.

Sorry to hear that. Guess I will have to learn .NET.

I think Lumigen Log Explorer must be already installed.

You can't install it and read transactions written to the log before the installation.

I don0t think you would be able to...

To access and view the temp table you must do it from inside the dynamic query.

For Example:

EXEC ('CREATE TABLE #Temp (ID INT) SELECT * FROM #Temp')

Would work, but not

EXEC ('CREATE...

Can't do from SQL with xp_Sendmail.

But maybe you can configure a rule from Outlook to send those mails with high importance, filtering by the subject, the sender of anything...