SQL Server Performance

Search Results

Search Again
  1. rock_and_roll

    T-SQL runs fine in Query Qnalyzer, but not as a job.........why?

    Thread by: rock_and_roll, Aug 22, 2008, 4 replies, in forum: T-SQL Performance Tuning for Developers
    I have some code that works fine in SQL Query Analyzer, but fails with an error when running as a job. Here's the code: USE STXbaxt -- Count number...
  2. rock_and_roll

    Using DTS global variables with an Informix data source

    Thread by: rock_and_roll, Jun 25, 2008, 2 replies, in forum: SQL Server DTS-Related Questions
    I've created a DTS package that reads order information from InformixSE 7.21 tables into lovely customised tables in SQL Server 2000. Thatworks...
  3. rock_and_roll

    DTS Excel export works fine......until I amend the SQL script providing the data....

    Thread by: rock_and_roll, Jan 21, 2008, 3 replies, in forum: SQL Server DTS-Related Questions
    I can't find an answer to this anywhere....... I've created a DTS package that extracts data from a table and exports it to Excel and then emails...
  4. rock_and_roll

    Using a fieldname in a variable in a SELECT list?

    Thread by: rock_and_roll, Oct 10, 2007, 4 replies, in forum: T-SQL Performance Tuning for Developers
    I apologise if this is ludicrously easy, but I've searched for the answer and not found it. Without exactly why I want to do this, I just want to...
Showing results 1 to 4 of 4
Search Again