In replication, we can choose data to replicate.

In log shipping, we have no choice but all data.

I prefer BPool because we can flush out the buffer by using DBCC command.

The default size of ldf file is either that of model or a quarter of mdf file size, whichever is larger.

Using mapping drives?

It is for barsuk. What does sp_who2 active mean?

Many thanks in advance.

I would say NO. For example, DBCC CHECKDB may detect errors due to hard disk failure. We cannot expect these errors occur at the same time and at the same...

I would make sure if there is any null in the movedate in the server 23. In particular, after testing your script, you might not have any null in this...

Use the command:

BACKUP LOG dbName WITH NO_TRUNCATE

Disabling a job in SQL Server only means that the SQLServer Agent will not run it automatically. But we can fire the job from many other ways, such as manually...

Disabling a job in SQL Server only means that the SQLServer Agent will not run it automatically. But we can fire the job from many other ways, such as manually...

Your code did work. I mean your code is the only choice we have at this moment.

Many thanks once again.

Thank you so much for you guy's inputs. I forgot INFORMATION_SCHEMA is the owner of the view of ROUTINES. However, only Ninja's code could retrieve a list of all user-defined...

Using an infinite loop, combined with WAITFOR, you can do it.

Another alternate is to use SELECT fieldList INTO newTable FROM existingTable to avoid the headache in creating a new table.

DTS packages wraps account with themselves. After an account is changed, the packages may not change accordingly. As a result, it is not recommended to use DTS in my company...