I see your point however, THEY are NOT using the services or functionality, I think that is a very broad reading of the license. I also don't believe this...

Martin Schoombee (2/14/2012)

---

If you're setting the filepath dynamically in this case, I would suggest that you set the "DelayValidation" property to false for both the flat file connection manager and...

I'm a little confused by your problem..

When you create the variable set it to a VALID value then setup whatever needs to use it. You cannot modify a package...

From the doc "2008 SQL Licensing Overview final.docx":

"A SQL Server User CAL is required in order for a user (employee, customer, partner, and so on) to access or use the...

What exactly are you looking for? Just the logins? If you recreate logins with the same user SID databases permissions automagically line up.

CEWII

Those descriptions don't make much sense but.

I'm guessing login activity and security changes related to it.

what is contained in the “system or...

I think these audit standards are likely to bog your server down and generate large amounts of non-useful data..

With that said.. I normally specify a certain number of audits....

You are welcome.

Depending on your environment you may have less control over some things. For example you mention SAN storage, how LUNS are spread accross the drive array may...

NJDave (2/14/2012)

---

Thanks for the quick reply - I tried to answer each question below...

How many cores?

How do I determine this? They use 16 now...

How much memory? 2GB -based on...

NJDave (2/14/2012)

---

Hello

I need to make recommendations for a server to run SQL Server 2008 R2 Enterprise Edition.

The database that is currently running on SQL Server 2000 Enterprise on Windows Server...

Large databases themselves is not a problem, how much data would be moving is the question. The more data the harder it is and likely more latency.

I think you...

I'm sorry, but your question is unclear.

What is happening and what is not happening? What is different on the machines that do have a problem vs. those that don't?...

sandip1981 (2/14/2012)

---

Executed as user: AAA\XXX. ...Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 10:57:38 AM Error: 2012-02-14 10:57:45.29 ...

Koen,

You certainly have a point, this is not good code control. And perhaps a way to negate the issue entirely. If he is always starting form the source...

I would have to agree, SQL 2000 is just another data source and you should have no problems as long as you keep the syntax in mind.

CEWII