Don't sugar coat it Jeff - tell us how you really feel.

Bummer - I just noticed that I cannot see the previous post while I am adding a new one.

The...

Overall, I think it is a great improvement.

I'm sure you are tired of hearing about the notification emails, so I will not add to them.  I did, however, find it...

Reporting Services 2005 supports dynamic data sources (connection strings).  I use this feature for my financial system since it creates one database per company.

Here is a post:

http://www.sqlservercentral.com/articles/Development/2945/

It just feels right to me.

You can manually set up the database and not use a snapshot.  The down side will be that you will be unable to simply re-initialize the database and have it...

Wow - I have to get used to the new website here - change always freaks me out.

As for your question, I would start by using the CLR integration in SQL...

The spilling of memory over into the page file is handled by the operating system, not the SQL Server.  Even though you have told SQL to reserve physical memory and...

When Microsoft bought Proclarity last year, they picked up a product that will do this for you.  It is the same kind of thing as Novaview in which you will...

Replication - by default - really wants to replicate deletes.  So, it is often a poor choice for an archiving solution.  That being said, you could use transactional replication.

Transactional replication uses...

This would need to be a feature of your pivot table tool.  AS will not allow you to force a user to always have a particular dimension filtered unless you...

There are a lot of differences, but the purpose of the second database is the latency of the data are probably the two most important factors.

In log shipping, the second...

I have been a DBA / Developer for about a decade.  During this time I have been on both sides of the fence - a manager of up to 14...

I would tend to suspect permissions, but start with seeing if the lookup component is querying the database correctly.  Start profiler and run a trace just before clicking the lookup...

You still have not given much information to work with here.  You are doing a lookup to a SQL 2005 server.  Regardless of the database or table you choose for...

We have a financial system that uses a database per company and we have about 45 companies at the moment, so I know how you feel with this.

I have a...