I have an engineering degree, but not in Computers. 🙂 Electronics and Telecommunication. I have done couple of certifications, but only one in the IT Technology. ES 9000 Mainframe computers.....

Grant Fritchey (5/25/2010)

---

I haven't been posting here at the water cooler because, frankly, I was appalled at how many posts I had here. But I have to share this one...

Since you do not know how to write triggers, I am posting a sample of trigger.

USE Northwind

GO

DROP TRIGGER tr1

GO

CREATE TRIGGER tr1 ON Customers

FOR UPDATE AS

IF (...

In your stored proc you just have to use one insert statement

insert into DailyClientTranscation (Dates,ClientID,ClientNames,ProductName,Quantity,Price,TotalAmount)

Select @date,clientID ,@clientName ,@ProductName ,@Quantiy ,@price ,@TotalAmount from clientprofile

where clientID = @clientID and status ='Enabled'

Steve Jones - Editor (5/20/2010)

---

jcrawf02 (5/20/2010)

---

Advice requested -

trying to develop a searcheable db of our available reports for end users, including description, author, screenshots, blah blah blah.

We have...

Check how much free memory you have and how is your Disk IO. Also are you running out of disk space? All of these can cause the CPU to go...

CirquedeSQLeil (5/19/2010)

---

That would be nice - I only have the laptop. (p.s. I wasn't insinuating that you had nothing else to do. I re-read my last post and...

I have a desk top for work and laptop for other things..:-)

So it is not just our Network admins who are Site-Blocking Happy... Jason is also in the same boat. I have my laptop connected to a 3g modem but the...

Seems like 800+ attendees for 24 hr pass. 50% of them must be from this forum. 🙂

I do not think it will create a password when scripting out. But I am not 100% sure regarding that.

Is there anything in the SQL error log? Till now no one has reported issues in setting up TDE on SP1 and Windows 2008.

Keep in mind that Windows 2008...

Under what user is the service running? This looks more like permission issue. That is probably why encryption_state is 2.

Hi Eric,

Did you check the percent_complete value from the sys.dm_database_encryption_keys? Also are you trying to set up TDE on the same system where you tested without SP1?

This looks more like a HW issue. What kind of system are you experiencing this problem?