Hello,
Yes, I have access to the SQL database and the view. I can go into SSMS and run the view and see the result in SSMS -- but that is on the client's SQL Server. I want to be able to run the view and put the data into a file so I can bring it back and put it on my SQL server so I can run the import utility and debug the code.
Is there a SQL command that allows me to put the result in a file?
Thanks,
TFISHER
>>Hello,
>>
>>The client sandbox SQL database is at another site than my development machine.
>>
>>I know how to run the view and see the result in SSMS, but I actually want to have data on my development machine so I can trace through the code to ensure all is well.
>>
>>How do I run the view and get that data result back to my development machine?
>>
>>Thanks,
>>
>>TFISHER
>>
>
>Do you have an access to this server? Either using linked server or Openquery?
>
>Do you want to get the view definition?
Thanks,
TFISHER