It is effectively a scale-out solution in architecture, but not in practice. If you reference the reporting server with the server net name of the SQL server (not the...

Revenant (6/8/2011)

---

Elliott, I guess you are right, in most cases and in this litigious society. However, so far I always got the answers I asked for -- I always...

Carlos Bossy (6/8/2011)

---

I think showing work you've done applies only to anything that would already be publicly available; a public web site, a paper you've published, a side project you...

I am going to go out on a limb here..

From the licensing overview doc:

BUSINESS INTELLIGENCE / COMPONENTS IN ADDITIONAL SERVERS

The Business Intelligence components for SQL Server 2008 include...

And on the systems where it is allowed (not by my choice, I inherited them)...

I believe the software is called DB2 Connect, and it aint free..

http://www-01.ibm.com/software/data/db2/db2connect/%5B/url%5D

Depending on the size of your company you might already be licensed for this.

I used to use a package...

Perhaps it would help to be very specific about how foreign keys work. A value that is reference by a foreign key can usually not be changed because it...

In most companies these days previous managers will usually not answer anything more than the most basic questions, no matter what the applicant signed. More often than not this...

I like GSquared's post..

Posting here and writing articles or blog posts create an impression of who you are and what skills you have. It also shows how you approach...

No, and I didn't want to, because this should work. I may try that after I un-rename the sa account.

CEWII

Think I will try re-renaming sa..

CEWII

I would say it doesn't matter if its particularly vague, you need to ADD a record into table three for the new value THEN do your updates then delete the...

Not that I know of, but have you considered using the ADSI provider to query the data as a linked server?

On most of my systems I disable xp_cmdshell and don't...

So this is for a report? Do you have one report that generates the data for all Clients?

I think I understand your problem a bit more but I need...

No but that article shows 1:1 isn't necessarily the best and that the guidance to use 1:1 can actually cost you performance. It CAN be be the best but...