Exactly Gail 🙂

A little tip: I create a file copy of the master database. If the master database should be so corrupt that SQL Server cannot start, I use this file copy...

Perry Whittle (12/21/2011)

Good point Perry, IPSec is an option which often is forgotten.

Nope. However, if you have software which remotely can invoke processes on a Windows server, you can use that software to run dtexec, which is used to run SSIS Packages.

I've used it several times. It has either been low-level data conversion (UTF8 to UTF16 and back, binary(8) to float) or working with bit mapped values, like @val...

Honstely, the better way of doing this is using a firewall 🙂

Something like SQL Server Access Restriction[/url]?

I do definitely not want to be petty, I do however think that the 2TB partition limit is an important knowledge regarding GPT vs MBR, in most cases actually more...

Meaning the lowest Id. The order of the rows is not guaranteed.

select min(id), name

from table

group by name

Locate the snapshot file on your file system, and loot at its properties. You'll see that the size is the same as your database file, but size on disk is...

Could you please post DDL and sample data?

First of all, BACKUP (Transact-SQL) has a lot of useful information.

1. A Copy only backup does not interfere with your backup strategy. A differential or a log backup will never...

A little piece of missing information: You describe some of the differences between MBR and GPT, but in my opinion you lack the most important one: MBR can only host...

First of all, I agree with Dev on the syntax. So, to your issue. If you have referential integrity, you have to delete from the referencinig tables first, followed by...

And to add a few other points:

* All or some of the columns in the primary key may also be a foreign key.

* A foreign key does not have to...