Though I could not make much out of your description of the problem, but I think do either of the two methods:

1. Make subreports and use expressions to make the...

You can go for geo-clustering but if your DR center is going to be at a different place (which is how it should be), you might want to go for...

Hi Pallavi,

Did you consider creating after triggers on your first set of tables? You can capture the changes through the 'magic tables' -Inserted and Deleted.

Anjali,

You dont have to have same thing for the dates. You can go with the approach suggested above:

select datename(mm,getdate()) --retuns a value of January

and then if you just want...

Did you try pivot() on your data? I think that will do exactly what you want...:w00t:

Aye Aye Captain !!!:-)

Confused :unsure:

Brent,

Thanks for sharing the interesting case study...:-)

Thanks for the feedback !!:-D

I would definitely like to know the situations where service brokers turn into nightmares.

As far as huge databases are concerned, service broker is hardly influenced by the DB size. All...

Yeah, I agree that its a curious case. But we have a requirement that the Developer DBAs should not be allowed to create objects on a particular database but someone...

Yeah, you are right but all those things are figured out already. Only the DBAs are allowed to create replications and nobody is talking about production servers here. So, now...

But what about replications? The users should have privileges to create replications so they will be effectively creating procs.