Just to know what they are.

The primary key uniquely identifies a row.

A foreign key is used to relate one table to another. It uses the primary key (or...

Yep. A long operation. Because clustered is not simply a property of the PK, it describes the type of index being created. A clustered index defines how the data is...

Both. And more.

CHECKSUM validates that what was read from the disk is what got written to your backup file. VERIFY_ONLY will then validate that what was written to your backup...

Another vote for source control. That's the single best approach.

You could look to third party tools. For example, Red Gate Software (my employer) has a tool called SQL Compare [/url]that...

Koen Verbeeck (12/16/2014)

---

Voting time again!

The tribal award finalists are out and a lot of threadizens are nominated in very different categories!

Somehow my blog ended up in the category "Best Blog",...

Not a problem. Glad to help. And thanks for posting the solution back here. Now anyone with a similar issue that finds this thread on a search will know how...

patrickmcginnis59 10839 (12/15/2014)

---

Grant Fritchey (12/15/2014)

---

patrickmcginnis59 10839 (12/15/2014)

---

Grant Fritchey (12/15/2014)

---

The one thing that always validates whether or not any backup mechanism is any good is to run a restore.

So, use...

pottapitot (12/15/2014)

---

Thanks for your replies. I am basically trying to log database admins and users related activity. The list of events were provided to me by our logging solution support...

patrickmcginnis59 10839 (12/15/2014)

---

Grant Fritchey (12/15/2014)

---

The one thing that always validates whether or not any backup mechanism is any good is to run a restore.

So, use your bosses approach on...

Yes, Intellisense within SSMS is extremely flaky.

More memory.

2gb is extremely low for a SQL Server instance (assuming we're not talking about SQL Server Express). The minimum requirement is 500mb, so you're just barely beyond that, and,...

I would add the schema to the tables in all the code you're referencing. Even if it's just the default and the default is 'dbo' you'll have more accurate scripts...

Not only can you not restore just specific columns, but you can't restore just specific tables. A restore operation restores the whole database (well, there is such a thing as...

The one thing that always validates whether or not any backup mechanism is any good is to run a restore.

So, use your bosses approach on 3-5 different databases, preferably...

It really depends on what you are attempting to collect in this information you're gathering. I've always set up monitoring on a server-by-server basis, not on a database-by-database basis. If...