Typically you separate out heavily used indexes from the tables, not necessarily all indexes. Or you move data from a heavily accessed table.

That being said, are you not getting anything...

You'd have to provide more details, and likely log things from the package.

Was the destination empty?

What was the transfer method? Any dups? Any PKs issues? continue on error? batch size?...

You base indexes on the queries and joins that you need. Doesn't matter if they are in a stored procedure or not, you check the queries (SELECT, INSERT, UPDATE, DELETE)...

I'd be curious to know if anyone has tested this. It's one transaction v many, and I would tend to agree with Bob, but on anything less than hundreds or...

Either you are not allowing remote connections for some reason, or the connection string is wrong.

How are you coding the connection? Have you tried connecting from the Control Panel |...

I am seeing more and more questions about "all known issues" between 2000 and 2008. Tells me that MS should have spent more time on this upgrade.

Run the batch jobs with Windows auth, and set the password in the Windows scheduler, or other scheduler. That way the account running the batch has the rights.

Not sure. The HELP section for BOL seems to reference the get-help command.

http://msdn.microsoft.com/en-us/library/cc281954.aspx

The learning item references the Windows shell.

http://msdn.microsoft.com/en-us/library/cc281945.aspx

What other rights? Perhaps something that deny's access?

Not sure of the issue, but it looks like the package might have issues. If this is a maintenance plan, I'd recreate it. Simple enough to do. Can you open...

The MDF file is the database. You wouldn't zip up this file, you'd zip up the backup if you want to move it to another system. A backup is the...

It's easy to say I want to do this, but think about the times where you have an issue. What if you get halfway through and power dies? You could...

I have not seen issues reported with any CUs lately, but I would caution you that these are not heavily tested. If you don't have an issue specifically with one...

The file formats are the same, so you can do this. However if you have features that you are using in the primary that aren't supported on the secondary, some...

I tend to agree with Gail's approach. Don't update everything if you don't need to.

There's a counter to keep track of # of rows changed. Lowell's script seems to make...