That's what I thought you meant, and it's why I suggested you compare your options on SSMS to those it uses when run through SSIS.

John

You said you were using SSMS.

John

For SSMS, go to Tools -> Options -> Query Execution -> SQL Server -> Advanced. For SSIS, it depends on the properties of the network library you're using to...

Andre

First, do you really need those cursors? If you can find a way to do your update with a set-based query, it's likely to run much faster. Second,...

(1) Yes.

(2) If you're asking why index size isn't zero when there is no non-clustered index, I don't know. I imagine there's some small overhead for the possibility that...

Bhuvnesh

A clustered index isn't the same as other indexes - it forms the actual rows of the table and therefore doesn't contribute to the "index" size. When you create...

Nevarda

Have your text response system only accept whole numbers between 0 and 10. If customers want to provide comments and feedback as well, put that in a separate field....

Two good reasons to apply service packs, even if you don't think you need them:

(1) They contain patches for security vulnerabilities

(2) When the product goes into extended support, Microsoft will...

If you change the collation of an existing database, that doesn't change the collation of all the columns in it. It only sets the default for newly created objects....

Yes, it is, using IDENTITY_INSERT, but why would you want to? The values in the ID column don't (or shouldn't) have any intrinsic meaning, so it doesn't matter if...

That'll be the SQL Server VSS Writer service. You should switch it off if you have a complete database backup regime in place (which, of course, you should).

John

Yes, or maybe another full backup was taking between the two backups you're working from? Again, check in msdb.dbo.backupset.

By the way, you don't need the MOVE clauses when you're...

If you're doing the failover as part of a real-life test, then Anthony is right - leave the applications running. If you're failing over for some other reason, for...

jjturner (8/5/2014)

---

Is it possible to RESTORE WITH MOVE and subsequently RESTORE the remaining backup chain (DIFF's and LOG's) to the new location?

I'm getting this error when I try to RESTORE...

Also, read about SET XACT_ABORT ON/OFF to learn more about different ways SQL Server can handle errors.

John