If two instances you will need a second linked server to see the other. If the schema is different then you will need the quailify with FROM schema.tablename for you...

I agree with Andy. Testing all my file backups I never have any trouble with size growing beyond what the last backup image was. Did you shrink then do the...

So yuor trying to stop them from importing to Access not SQL. In that case setup a workgroup where only a logged in admin has rights to make changes to...

Sorry but no. You have to build an audit process yourself for data changes, you can do this thru triggers. Physical structure changes are not tracked at all and have...

I like the Wrox books exam cram and exam prep books personally in regards to test prep. But for real world beyond the test, you will need to read a...

We can only hope.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not sure so I will trow this out first. Could be a Win32 Error Code which in this case would be

12 The access code is invalid. ERROR_INVALID_ACCESS

Can you describe...

Datawarehousing looks like the closest thing to it. There is no ETL cert I can find for any verdor.

"Don't roll your eyes at me. I will tape them in place."...

Try reinstalling the MDAC, may be a registry entry corrupted. If this does not change anything then try reinstalling the Client Networking utility. Let me know if anything changes.

"Don't roll...

They are not supported and have no direct counterpart.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

We do but for Analysis Services at this point not SQL itself. You may consider posting to MS as a feature request for future versions. But as for now the...

Can you see the error returned from the job? Also generally these errors are permission issues (file referenced in package not accessible by SQLAgents account) or client issues (using 2000...

Look at writing a query that ties the data together for approved items only. You can use a query as your source in a transformation. This also will mean multiple...

I have also heard of being done with ADO to bring in as a recordset and update the file like a datasource. But I have not seen an example.

"Don't roll...

Sounds like your connection string is not using the statements to utilize trusted connections. I have done this only a few times, mostly to see how it works. Otherwise I...