MAybe if you save the linked server table locally and then execute the update can run faster.

SELECT M.Filed1, M.Field2, M.Field3

INTO #Temp

from LINK_SERVER2.TABLE AS M 

JOIN  #LOCAL  ON   M.ID =...

I was also hoping for something in QA

Agree. I should warn (Does this word exists? I meant warning) everyone before.

In my server I have the same deal. the guy who installed configure the hardware RAID with 46 K and the OS with 4 K.

But we re format the OS...

IF you need ro resync or reinitialize the subscription, applying the Snapshot will fail. Because the BULK INSERT SQL executes assumes that the dest table has the same columns that...

I have never documented anything of my process. But now that I need to review some old process I developed a long time ago, I 've noticed I should spent...

But in most cases you must have sysadmin right to use such app. There are also stored procedures to decrypt encrypted procedures.

I don't think it can be removed from the job history. If you need a clearer message, then you can save the result to a table or file.

You can add new columns to the tables in the subscriber.

If you use stored procedures to replicate the transactions, you can see that in the stored procedures the inserts, updates...

Not very performant I think. To speed it up a bit, you can put all the code into a stored procedure.

Another thing you can try is this:

CREATE TABLE #Top

(Pos INT...

You could use isqlw. First create a script with the t-sql code you need to execute in all your servers and then from DOS, you could use something like this:

C:\FOR...

Did you find anything in the SQL Server Error Log?

Did the Server Stopped? Or the SQL Agent?

You can try BACKUP LOG DBNAme WITH TRUNCATE_ONLY.

After truncating it, you should backup your db.

Do you have replication setted up in your server? If so, check if the Log reader...

SQL Profiler will run faster if you save the load to a .trc file, because it uses the same technology that sql uses to save to the log file.

Then you...

I've configured a pop3 mail account and recieve the same error when setting SQL Agent mail.

 Read in some article, that the error is espected. I accepted the error and the...