Drop indexes first on the target server;

*****

Here is the place to play games.

You can use either BCP or BULK INSERT;

You can output data from your data source into several plain...

You can turn on Security Audit in the Profiler.

I think so, but not 100% sure. You can right-click the desired database, and see if it is there.

You may consider attach/detach approach.

There are 2 parts affecting the performance of a database server. Jobs running directly against database server and jobs running on its operating system platform.

You can use the profiler,...

If you would like to focus scripts running against your server, do not forget to set filters and columns in the Profiler.

Have you ever considered to use a scheduled DTS job?

Right click the desired table to Generate SQL Script ...;

Include all necessary under the three tabs;

You will get it!:)

But I do not know why you post your question in Replication.

Here is an example. The output of the sp_spaceused returns two record sets.

CREATE TABLE #tmp(line VARCHAR(2000))

EXECUTE master.dbo.xp_cmdshell 'osql –SYourSQLMachine –E -Q"EXECUTE sp_spaceused" –o"c:\temp\sp_out.txt" –s"" '

INSERT INTO #tmp EXECUTE...

I do not know any standard rule. But I think it is our DBAs' default rule to backup a database before modifying it. At least, we can return to the...

They will create tables with ownership under their own accounts. One user cannot access to a table created by another user. He is only the owner of the table he...

I would not like to say it will never use page file. But adding more RAM will definitely reduce the use of page file.

My understanding is that the purpose of...

I guess you only have ddl_admin permission. When you only have ddl_admin permission, all tables you create will have the ownership under your account.

Check whether or not you have the...

Did you try to use your PC name instead of dot (.)?

That is what I mean.

Two suggestions

If it is the disk issue

1. Shrink its log file;

2. Backup msdb again;

Or, if it a disk or datbase corruption issue

1. Export data (you can...