General information
Forum:
Microsoft SQL Server
I'm running the OSQL utility from within foxpro but I'm getting a "Program too big to fit in memory" error. Have you had this problem?
>No, my script below uses Windows Authentication, that's the -E parameter. I believe it's optional, if you don't pass in username and password, osql should try using Windows Authentication.
>
>To pass in username and password, use -U and -P parameters.
>
>Roman
>
>
>>Do you need to pass in user id and password into osql?
>>
>>>You can use the osql utility, you can read about it in BOL. It allows you to execute SQL commands, including contents of a file. Here is an example, I use this to back a database on development server, copy the backup file to my computer and then restore the database on my local server:
>>>
>>>osql -S devweb2 -d master -E -i "C:\Projects\COM\Backup\BackupPerson01.sql"
>>>copy J:\comPerson.BAK c:\projects\com\backup
>>>osql -S ltrehak -d master -E -i "C:\Projects\COM\Backup\RestorePersonDB.sql"
>>>
> snip <
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only