YW. Make sure you backup certificates ASAP when you create them. Lost certificate is lost data. Period.

Make sure you secure those backup files, along with any passwords used for keys.

skanker (8/28/2012)

---

Just read this after coming back off my Summer hols - two weeks of fun with the family. I am always astounded that someone does not use all...

Tobar (8/28/2012)

---

This is the only thing I have disagreed with.

A well-trained, well-staffed central IT probably would,...

I don't see anything in BOL (R2 is here: http://msdn.microsoft.com/en-us/library/bb895327%28v=sql.105%29)

However I don't see any reason why symmetric and asymmetric keys aren't available in Express. I see articles about SSL communications,...

This is deferred resolution and it...

Stored procedures are just sets of code, like a batch you'd run from SSMS.

you add a header with parameters like this:

create procedure MyProc

@myvar varchar(20)

as

Then you add the code...

mandeep_nyc (8/27/2012)

---

if you run the script as it is, it will fail because a GO is requried.

Secondly, I just ran this in a new database, and when creating the proc's...

kent_secher (8/27/2012)

---

That was my...

Clients typically don't start a process on the server and hold locks. When an application SELECTs data, and the data is returned, there are no locks held while the user...

djackson 22568 (8/27/2012)

---

Companies used to have/show loyalty to employees. As a result, employees were loyal in return. For a very long time companies have thrown loyalty out the...

Antares686 (8/27/2012)

---

This is great if your source is 10 million lines of code, but they still have to trace out the changes that caused the failure via the coders who...

Thanks, but...

I believe David...

ddriver (8/27/2012)

---

I don't think that Quickbooks should be held up as an example of quality software or quality software processes. I am really not surprised that they took ten million...

As Gail noted, you haven't given any details.

Have you run a DBCC CHECKDB? (DO NOT run the repair with data loss option).

Are there errors in the error log or from...