User Profile

Collapse

Profile Sidebar

Collapse
MarkLafferty
MarkLafferty
Last Activity: Sep 10 '13, 04:17 PM
Joined: Sep 19 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MarkLafferty
    replied to Can you specify Query results file name in query itself?
    in SQL Server
    Solution

    Thanks for the suggestion CK.

    After running through a number of different scenarios, I ended up with the following batch file process:

    echo Release <Job Name> SQL Scritps Executed> <Location of Log Files>\<Log File Name>.txt
    echo ------------------------------------->> <Location of Log Files>\<Log File Name>.txt

    call osql -E -i <Location...
    See more | Go to post

      Leave a comment:

    • MarkLafferty
      started a topic Can you specify Query results file name in query itself?
      in SQL Server

      Can you specify Query results file name in query itself?

      I am running MS SQL Server 2008.

      I frequently need to manually run a large quantity of query files at a time. I need to log the results of the queries to a file without having to enter a new file name with each query executed.

      I wanted to automate the running of the batch of queries through the OSQL command specifying an output file, but
      each query builds on the query executed prior to itself so if the query...
      See more | Go to post
      • MarkLafferty
        started a topic Changing user schema
        in SQL Server

        Changing user schema

        I am running MS SQL Server 2000. I need to programatically change a user to a different schema, but I only find the syntax for doins so in ORACLE which really doesn't help so much.

        Can anyone give me the correct syntax to programatically change the SCHEMA the SQL user is using?

        Thanks for your help!!
        See more | Go to post
        No activity results to display
        Show More
        Working...