Forum Replies Created

Viewing 15 posts - 151 through 165 (of 498 total)

  • RE: Best way to exec crystal reports from a trigger?

    I agree with Andy, buld a small exe and have it do the processing. Just have your trigger put a record into a table that the exe looks at for...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 6:12 pm

    #493317

  • RE: Using Print

    I prefer to use a logging table instead. Simply insert the records into the logging table and then when you want to check the status select from the log table...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 6:05 pm

    #493315

  • RE: How To Check if Job is Running?

    Check sp_help_job.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 5:52 pm

    #493313

  • RE: Getting one .sql file to execute contents of anothe .sql

    The only way I know of to do this is to use xp_cmdshell and call osql. Rather than doing it this way I usually use a batch file to run...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 1:03 pm

    #493299

  • RE: collation

    Fred,

    I think we need more information on this. Are you saying that on Server1 you used SQL_Latin1_General_CP1_CI_AS as the default when you set up SQL? And that on Server2 you...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 12:57 pm

    #493298

  • RE: Script which will backup the transaction

    I would do this with a couple of jobs. First create a backup device for your log, then create a job that will run your trans log backups (Look at "BACKUP"...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 12:48 pm

    #493296

  • RE: Table data modification using Enterprise Manager

    I've never actually run across this. I wonder though if it is due to you not having a primary key on the table?

    Can you script your table out for us...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 12:40 pm

    #493294

  • RE: Replication Control

    Look at sp_start_job and sp_stop_job. You should be able to start/stop the replication agent job with these.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 12:34 pm

    #493292

  • RE: t-SQL to excel??

    You might also look at using OPENDATSOURCE and simply inserting the data directly into an XLS file.

    To retrieve data...

    ---------------------------------------------------------------------------------------------------------------------------------

    -- TODO: Make sure to change the name/path of...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 12:31 pm

    #493290

  • RE: Help

    Depending on if you have permission for xp_cmdshell you could alter Richards print statements to call xp_cmdshell and print the line into your file.

    DECLARE @ctr int

        , @Cmd    nvarchar(255)

    SET...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 12:23 pm

    #493289

  • RE: Rewrite Query with Nested Queries and Cross Join

    Hmmm... Why do you say it is using too much tempdb? With all those subqueries I'm not surprised! As Ken stated it would be nearly impossible to do the analysis...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 9, 2004 at 12:10 pm

    #493288

  • RE: ESCAPE quote

    Try something like this....

    SET @var = REPLACE(@strWord,'''','''''')

    Then build the rest of the string.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 6, 2004 at 6:46 pm

    #493187

  • RE: EXTRACT DATA TO A .CSV - Comma Separated Values

    If you return the results in Query Analyzer to a grid you can then save the results in CSV format. Unfortunately you can't save the column settings that way. Another...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 6, 2004 at 6:41 pm

    #493186

  • RE: Switching database context within a script or proc

    If Jonathan's suggestion doesn't work use xp_cmdshell and call osql with the command.  BTW: That will also work even if you need to do it on another machine




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 4, 2004 at 2:00 am

    #492716

  • RE: Converting Access Query to TSQL

    I agree with Keith on this. I think I would make a new table or add a column so that the abreviation of the region could be mapped to the...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    February 2, 2004 at 1:36 pm

    #492539

Viewing 15 posts - 151 through 165 (of 498 total)