I thought it might...

CEWII

The name of that provider sounds like the MS SQL Provider.. Are you using the Sybase provider (I know stupid question, but I gotta ask)..

CEWII

I did all this without buying tools, the only thing we had was VSS and later TFS.

If you are doing smaller builds more often this model requires a fair amount...

GSquared (8/4/2009)

---

The best piece of advice I can give anyone on any subject is that knowledge comes from doing things, not from reading things. Reading gives you data, doing...

I got to tell you, your first hurdle is getting something that can read the PDF programatically and output something useful. I found a link that might be helpful:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/39b5ead2-8699-4957-aa07-5b585d2adb63/

CEWII

I think there is an option that sets a startup object, you just right click on it.. I generally right click on the package and click Execute Package..

CEWII

I have wide and diverse programming experience in a couple languages and spent a LOT of time solving challenges in SQL. I have been dealing with SQL server since,...

Authentication mode does not matter, the rules and availability are the same.

CEWII

SELECT columnname1, someothercolumnname, yetanothercolumnname

FROM ##Temp123

Clear?

CEWII

After much testing and soul searching I built a methodology that provided a basis for all server classes code to work in all environments unchanged.

From SQL 2005 on we had...

Best practices for SQL change control...

Well, I think some of the structures are easier to handle than others, especially functions, sprocs, and views.

I have typically built what I would consider...

I would say the profiler method could certainly do all that. You could also look at DDL triggers to capture the object changes and logon triggers to capture logins..

CEWII

I can't remember for sure but I believe you can reference either (local) or . for the local server.. I used to do it this way so I didn't...

I hate to be a smarta$$ but access is denied to the file you are trying to access..

In all seriousness though, the user (either you or the user that SQL...

My first thought was to have you write a sproc on the linked server that you simply called instead of building a dynamic sql statement to pass to it.

But as...