Must admit, never played with powershell.

/walks off to go find a book on powershell

What he said -

I've not often seen a valid reason for dynamic sql. If yours is being...

simplier: EXECUTE sp_msforeachdb 'USE ? PRINT DB_NAME()'

can I add, bcp looks cooler when in full screen. More so if you star at it intently and mutter when strangers walk by :hehe:

I win 😉

You might be...

yup, purely for passers by and "covering all the bases" I would bang my head against a wall if the response was "well, it takes to long to copy the...

as has been suggested, why why why touch the source table again.

What you are doing is telling 10000 people to step forward, checking to see you've not spoken to them...

http://msdn.microsoft.com/en-us/library/ms188365.aspx

CHECK_CONSTRAINTS

Specifies that all constraints on the target table or view must be checked during the bulk-import operation. Without the CHECK_CONSTRAINTS option, any CHECK and FOREIGN KEY constraints are...

You could use a pretty simple command line delete via xp_cmdshell.

You can, assuming your agent account is running with appropriate permissions, put the files on a UNC path (\\MyOtherServer\c$\xxxx)

To test it, it is easier to enable xp_cmdshell and run exec...

as an aside, I've not had much luck with changing the reg setting so that it scans more than 8 (7 if you have a header). I found the tasks...

You sure the EOL is CRLF and not just CR or LF?

Try either option on its own.

dwill (6/8/2011)

---

Perhaps it is what it is - I am not shooting the messenger! - but the core task of copying a DB to another server (albeit 2005 -- >...

Are you sure the value is being set correctly? Can you see it in a Watch?

Did not perhaps set the Evaluation Operation to "OR"?

You could extract the sql which makes the view and search that.

SELECT OBJECT_DEFINITION(OBJECT_ID('vw_chkBreedDimension'))

hmm, lost me then. A tickle on google seems to suggest it's corrupt "DB" files. I am assuming you can still open excel.

Try applying jet SP4?

http://support.microsoft.com/kb/829558

Important Jet 4.0...