There are two ways of handling this situation

1. Backup transaction log in between

2. Are you taking a full backup after this task? Then you can change your...

Try this:

sp_configure 'max text repl size', 2097152

GO

RECONFIGURE WITH OVERRIDE

GO

This will set the maximum amount of data that could be transferred to 2 MB The default is 64 kb,

hope this helps

thanks for the comments. My concern is how to receive SAN information. (Hard disk capacity used. Disk health etc.)

I am actually developing an intranet to provide the data.

The script uses SELECT DISTINCT and you can't use blog columns in comparing. It means you need to exclude them: Use the @Fields parameter to list the other...

Hi

You say, if you don't use the date parameter query takes longer time. It means query takes the data set correctly to get the rows. So, the...

hmmm...

May be sending the content only when a new topic is added may be a useful thing. Later we can subscribe to the messages individually.

I dont know what is...

I receive mails on all subjects (not only threads) I have subscribed to. For example, I receive mails on "Administering"

It is different from the threads I have responded...

I felt that when we receive the mail with the message we will be more encouraged to respond.

Generally, not all can respond to all questions. Additionally, some times...

The database serves as read only database and will not be written when SQL Server instance is running.

Like any other file backup, or registry backup, backup of these files...

Oops I just realized that this is quite old thread. I am not sure why it suddenly came into my screen.

Removing identity property is something I have seen many people doing for some reason.

Most of the time, they perform an additional query to get the next value and then...

As Google is not down, we expect you to do the search 🙂 Just kidding.

The only argument anyone can bring is in case of a failure during the middle, (which is equal to a crash I mentioned) how can you resolve it. In...

Interesting.

I am not sure why those statements were mentioned. I have done enough upgrades, and never went with this approach.

May be you need to send a note to...

You need to write a function which turns the multi valued char(10) column into multi rowed table.

Then you can join that table to TableB and get the values needed.

I...