How important is it that the query returns "live" data?  If you can tolerate some latency, you might try writing a stored procedure that fills a table.  The table can...

Keep in mind that Access is a file-based database; it is not considered a "data server."  Therefore as mentioned above you are limited to searching the file system. 

Can you tell me what the error is you get when you run sp_addlinkedserver?  Your syntax looks correct.

Paul

Don't forget that DMO is now called SMO in SQL 2005.  With it, it shouldn't be too hard to come up with a CLR assembly which can be called from...

You can check sybjobshistory.  You might as well launch the job in a query window, then in another window you can keep checking sysjobshistory.  As soon as the job is...

I don't believe it is possible.  I have tried different methods including changing the compatability level, but nothing has worked. 

Good luck.

Andy, thanks for being willing (daring) to write such a controversial article.  I'm all for dialogue whatever your point of view is.

In my 12 years of SQL coding I don't...

Nice article covering some basic points, but here are 2 important points to hightlight:

A lot of my work day-to-day is fining previously written procedures that are slow and re-writing them...

This is by far the best SQL groupie site I have experienced, EXCELLENT JOB!!  I even discontinued my logins to the other sites.

Best of luck, gentlemen. 

Paul

I miss the ability to play a given .wav file when a query finishes.  In SSMS we only have the option to play the Windows default beep.

Quite refreshing!  This is a great morale booster for all who use the site. 

Paul

Awesome, thanks very much. 

Don't know if this is still important to anyone, but I encountered this exact error today when trying to backup.  As in the orginal post above, my SQL server does NOT have...

Another good example of proper usage of comments within code is to look at some of the system stored procedures.  In the MS world, try looking at sp_get_composite_job_info located in...

Very cool.  Thanks for the education, Jeff.