1. Run your scripts sequentially;

2. Make your scripts short.

I agree with you that the most efficient approach is to detach/attach databases. However, if you would like to move your data to other disks, such as SANs storage a...

Within 3-5 days, it is hard to fully understand all concepts of DTS packages. But it is enough to grab their main ideas. Being an SQL Server DBA, you may...

Based on my undersatnding, SQL Server cluster has only one instance. If you would like to add a new instance, you have to create another SQL Server group.

You need to apply the latest service pack and hot fix.

It is possible. Probably, the network person set it. One way to set it is:

Open the Task Manager;

Click the Process tab;

Right-click an executable file, then choose Set Priority;

...

You can change collation for a database and a column. But if you would like to set your new collation as default, you have to rebuild master database.

Interesting question! I know how to link Crystal Report to SQL but not vice versus.

I would like share this info.

Anyone would like to help?

Did you try

SET LANGUAGE Español

Normally, the information from the job history is not enough. I would like to recommend you add an output file in your job.

Open the properties of your desired job;

Goto Edit;

Click...

Could you change the default timeout value?

See if the following steps help.

Open one of your existing DTS packages

Click Save As...

Choose the SQL Server name where you would like to migrate your DTS package

Remember

You had better login...

I used SQL Server client tools to connect a remote server with sa privilege. I could manipulate everything except running a job. The error message showed that the SQLServer Agent...

Could you go to the Security tab in the properties of SQL server and set your audit level there?

But how do we know it is due to index fragment or out of date statistics before running restatistics?