Thanks to both of you. This helped.

Thanks guys. I figured out my issue. i had two things working against me:

1) I did not have all the original parameters correct when I tried to duplicate...

I moved Master key, and all symmetric keys and certs used, and I'm still getting NULLs. I even created a brand new database, and walked through that article, with...

Thanks guys. Much appreciated.

I have done that for testing, and it I think this tells me what I need to know. What I'm trying to prove is that if someone gets both...

Thanks for the reply!

You mention the DMK needs to be backed up and restored to the new server. The DMK is stored within the database itself, so why would...

Gila,

Can you clarify for me a bit? Why is using task manager/resource monitor bad for SQL memory monitoring? Also, if SQL uses more memory to account for the...

Sorry for the confusion. I am trying to report database performance.

Thanks for the responses. First, to answer both your questions:

1) We do not have the AdHoc optimization turned on, and actually, I'd forgotten about it. I've been...

Did you ever find any further info about this issue? I believe we're having the same problem. Thanks!

Actually, I don't think I did realize we could use Try-Catch (I did mention I'm a relatively new DBA, right?).

Any way, that's exactly what I've done for now; put each...

Sorry to keep piling stuff on you, but I thought you may want to know this. We've actually refactored step #8 in the sotred procedure to look like this:

INSERT...

--CREATE statement for tbl_echart_patientinterfacestaging:

USE [Ucare]

GO

/****** Object: Table [dbo].[tbl_Echart_PatientInterfaceStaging] Script Date: 09/09/2009 08:42:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tbl_Echart_PatientInterfaceStaging](

[Id] [int] IDENTITY(1,1) NOT FOR REPLICATION...

All right. a little more clarification on what we are doing (I had to clear it with my boss about how much info I should disclose). Also, please...

Sounds good. I can get the info tomorrow when I'm back at the office. Another thing I forgot to mention is that all of the sites' records are...