Pwd should have been PM'd to you, Steve. Maybe check the Inbox?

BTW - I'm in!

Thanks for setting it up.

-SD

Jerry's right - Acess needs the PK...

Coding SPs from Sql Server is how we do it here, but it does take time to do the coding.

You could write TSQL stored procedures on your SQL Server machine, and call them using pass-through queries in Access.

That would involve writing the SPs though.

Hi Bruce,

Unfortunately, we haven't made great progress yet.

We've decided to work toward the 'Trusted Subsystem' model that I read from Chapter 19 of Teo Lachev's book: Applied Microsoft SQL Server...

I'm in, if there's still room. I'm on the east coast, and would be keen on a live draft, depending on my availability (meetings, etc.). I like the auto-pick idea...

Ditto....

Similar to richj-826679, I have a standing moratorium on running any major UPDATE/INSERT/DELETE statements after 4pm, on any day.

-Simon

Amen!

Just wanted to leave a quick comment to say that this post saved me a lot of time.

Thanks very much, GSquared - your help is greatly appreciated!

-Simon

I got the chance to try out R2 a couple of weeks ago, and am excited about the integration of Map objects into SSRS.

Unfortunately, out of the box there are...

I'm experiencing a similar issue, and am working on the resolution now.

Basically, SSRS E-mail subscriptions weren't delivering when they were configured to attach the report to the e-mail (i.e. PDF,...

As a follow-up to my own post, I'm happy to report that I've not had any issues running SSRS 2008 with IE8.

Terrific article. I used it with some modifications to realize a huge time-saving project.

Many thanks!

- Simon D

Have you double-checked that you passed the correct credentials?

Terrific article, Andy - many, many thanks.

This got me started with understanding how to shred SQL data using the Object variable type. This understanding will now help me implement all...