Nothing too exciting to report.

On the week-end, I brought the Mirror server up to SP3 to be in parallel with the Primary server. Then I experimented with various "faults"...

Thanks Robert. I'll see about bringing up the service pack levels. Also, this week-end I may be able to experiment. If I see anything interesting, I'll post...

Sorry for the delay in responding to your questions; I did not get a notification.

Anway, the Principal Server is SQL Server 2005, Enterprise Edition 64 bit, SP3.

The Mirror Server is...

Hi Robert,

For SQL 2005, State 12 is defined as "Principal Running Exposed"; the definition is: "This state occurs on the principal server instance when the operating mode is high protection...

No. I only set the default value. The calendar control is used to obtain a value indicated by the user.

The delay in activation of the calendar control almost...

OK, this looks like as good time as any to ask about DateTime data. The advice to the OP was to use datetime datatypes for date data. What's...

I don't want to be too harsh on these folks. Their business does not include the typical transactional database. Most of their input comes from 3rd party files,...

Ah, I just found part of the answer. This org wants to have documented procedures for all kinds of things. And it seemed easier to have prepared stored...

Yes, that all makes sense. I think the idea was to have the databases in Full Recovery mode in case a DBA was available (via a service), and that...

Gail, Grant

Thanks.

I understand how OPENQUERY directs the processing to the remote machine, and I'll look at that.

I was curious about the situation with Views. Since the main...

Thanks for both replies. The query hasn't been written yet, so we haven't been able to use the execution plan, but it appears clear that we should create some...

The code works when I run it. Are the title's identical? The code snippet is written such that the grouping includes the title.

HTH

Elliott

Hello,

This post looks a bit stale, but I'm intrigued. Here's what I observed, but maybe this is just an artifact of your sample:

The categories each have unique attributes associated...

Hello,

From what you posted, the dynamic sql is not necessary. If the table name is passed into the stored procedure as a variable (say @table_name varchar(100)), then your...

George, thanks. That's an interesting piece of information. I'll pass it on to the Purchaser, so the process will be more understandable.

thanks again to everyone in this community...