Perspectives are an Enterprise Edition feature (so, it is nothing to do with 64-bit)

Yes, the unique contraint would need to be on the Country table - no information supplied on the definition of that table so I gave a generic reply

There is a...

I agree with SQL Kiwi that his solution has the potential to make much better use of indexes etc and hence may well perform better.

My solution was intended to answer...

For a foreign key to be created you must have a constraint that forces uniqueness on some column(s). This could be a unique primary key or a unique constraint....

The CASE statement is intended to return a single value. For you condition, you are trying to checking whether either paymentduedate or createdate is between begindate and endate (depending...

If the user databases are/always were CASE SENSITIVE, you won't need to re-create them. Just detach and re-attach

How about adding a parameter to your sproc and in the dataset that uses that sproc, specify "=User!UserID" as its value

You can't do this with RS 2005. This functionality does exist in RS 2008 R2 (maybe also in RS 2008 but I can't quite remember at present)

I think you your query could be rewritten as :

SELECT

E.Name,

100 - SUM(CASE WHEN...

I am pretty sure that your vendor is correct. Each service on thr cluster will need its own IP address.

Have a look at a pair of articles on this...

There are changes to licenses that are yet to be annouced. The news licenses will be announced in a few weeks time (not sure whether they will be rapped...

Next - in the job that is running the package, is the server name correct ?

Before you discount Enterprise Architect (yes it is awesome), check out the price. The "Corporate Edition" - it does everything you need for US$239. That made the deal...

The error you are getting is happening when SQL Agent is trying to open the package. The server that it is attempting to connect to may be incorrect. ...

I have been using a product call "Enterprise Architect" for a few years - it is more than capable of meeting your needs. You can reverse engineer from most...