Can you post the conde inside the job that you are executing?

Yes but in the article parameter, it only accept the word 'all' or the name of the article to publish. Do I have to execute sp_Addsubscription sp as many times...

But you can connect to SQL or can't... If so wich what user are you connecting?

Did you change the login authentication type?, or specify any other windows login account

for any...

To really know what's your app is running in SQL you should trace your server with profiler or with sp_trace* stored procedures. Anyway, maybe you want find out how is...

thanks, I will try.

If you have replication and that server configured as a subscriber of your replication, you won't be able to drop the linked server and re create it, unless to disable...

Maybe you should map the network directory to wich SQL saves the backup. To map the drive you can execute :

exec master.dbo.xp_cmdshell 'NET USE H: \\Network Server\Shareddirectory' /User:domainuser password'

Then execute...

execute sp_helpserver to see if the linked server already exists. If it does, you can erase it with sp_droplinkedserver. You need to drop any logins you have set for that...

I would say varchar. But you could separate the dimension into more columns of decimal or int types. For example: use 1 for one column, then 3.75 in another.

With sp_who2 you can view if any user is accesing the db in that moment. When you said 'I got a share violation when I try to open the log...

In your jobs you run the DTS packages with DTSRun?

I have found MakeCAB.exe in my machine from the visual studio directories. But I don't think that it going to work. Most importat I need to unzip the .cab files...

This jobs tries to connect to a linked server or something similar? Or it happens on all your jobs?

Do you have any log error? Is the Agent started?

Sometimes when you restart SQL Server, and if you are using TCP/IP, the default port of TCP 1433 doesn't open. To check this you can telnet your server with that...

Of course my views are indexed to replicate the data in them. The problem about creating new publications in that I already have 3 publications created in my republisher...