Hey Threadizens - any ideas on why OPENDATASOURCE isn't working on a prod server?

Thanks!

Wonderful

A traitor!:w00t:

I can't tell if you just want the "ALL" option in the drop down in the report parameters area, or how to handle in it the following code. So, I'll...

Set up a configuration file for the server name. Modify each package to use the configuration file (yep, it's labor intensive for 100 packages). On the production server, put the...

Hey Steve - what's the new avatar?

Steve Jones - Editor (9/8/2010)

---

I think Lutz has some bad karma going. It seems every weird thread I come across with a difficult OP is one in which Lutz is...

But how do you like the one I decided not to use?

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

How about a table where the PK is on a text datatype? (as are most of the other columns also!)

You should give appropriate data types. Having a text field (which allows for 2gb) as a PK just isn't a good idea.

You might want to try right-clicking the...

Jerry - You might want to take a look at Gail's excellent blog[/url] on what you're proposing.

Still running at needing 24.9 posts/day to get to 20000 by 11/18

It's worthwhile to get to know...

Pete-L (9/8/2010)

---

Hi Mike, the table I gave was an example - the one im going to run it against has almost 100k lines, the script would end up way too...