Is that:

C:\Program Files

or

C:\Program Files (x86)

?

CEWII

Unless your 2000 server is fairly new you are likely buying new hardware for the 2008 box. The is a very common case for an upgrade. Although an...

I think what I'm seeing is a fundamental misunderstanding of what happens when you store data in SQL. You cannot control the format it is stored as, you put...

Are you running this through BIDS or from a SQL Agent Job?

That setting only applies to BIDS. Also, what directory is devenv.exe running out of?

CEWII

divyanth (5/13/2010)

---

You can use a Switch case as an EXP in derived...

You can use database mail to send emails from the database.

You can use SQL Agent to schedule jobs.

However, the ease of making all this possible is dependent upon what you...

It is a property of the package. Click on the package in the Control Flow away from other components and look at the property window, you will see it...

I would tend to agree with Phil. However, it depends on the source of the data. For things like flatfile sources or sources you can't change you might...

Audit is only available on Enterprise edition.. I agree, you need to be very careful with traces or your server can take a big hit.

CEWII

Fal (5/13/2010)

---

Ah Elliot, great minds think alike. I considered trundling out the .Net comparison earlier today but I knew I'll get howls of protest and denials.

End users, being internal...

You are welcome.

CEWII

Jeffrey Williams-493691 (5/12/2010)

---

I would disagree with this - I would not give them access to any system to run their queries until they have proven that they can write queries...

So their reasoning is that internally they did a poor job implementing it and a poor job of source control. So we are blaming the technology.

An analogy would be...

I would create the index on all three columns DateOnly, Con, and TimeOnly, you could probably use the INCLUDE syntax and get a covering query that doesn't have to use...

Great, I have to admit I didn't think about the buffers.. I'll store that away for future use. Thanks.

CEWII