Forum Replies Created

Viewing 15 posts - 91 through 105 (of 498 total)

  • RE: Capture osql error message in a batch file

    simone,

    You should be able to set a variable to the script name before each osql call. Then use the variable to insert the script name into your logging table. I'm...




    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.

    April 30, 2004 at 3:00 pm

    #504900

  • RE: Backup and Restoring from several different sources

    While you can use the MODIFY FILE it would be easier to do the restore while moving the database at the same time. IEFrom...




    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.

    April 30, 2004 at 2:37 pm

    #504890

  • RE: Where is it best to place "where conditions" in the join or inthe final where statement

    For inner joins I don't think it really matters as noted by the optimizer doing the same thing. However if you go to an outer join many times it HAS...




    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.

    April 30, 2004 at 11:40 am

    #504877

  • RE: Simple backup status report.

    Thanks Chuck! You beat me to it




    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.

    April 30, 2004 at 11:27 am

    #504875

  • RE: How to align selection of numbers?

    If you are using QA you can have it default to right align numerics by going to the Tools/Options menu. Then clicking on the Results tab and checking the Right...




    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.

    April 29, 2004 at 6:16 pm

    #504754

  • RE: questions about string value

    I'm with Rob on this one. Use the replace function in the join. BTW: Rob is missing the closing parenthesis.

     

    SELECT *

    FROM table1 as a JOIN table2 as b on REPLACE(b.str_value,...




    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.

    April 29, 2004 at 6:05 pm

    #504752

  • RE: Migrating Oracle Packages to SQL2000

    The only ways I can think of would be to use actual global variables in a DTS Package and the other would be to create an SP to call all 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.

    April 29, 2004 at 5:57 pm

    #504751

  • RE: Simple backup status report.

    Jonathan,

    Create a "Reporting" database on these machines to write out the job errors to. Then you can simply have the job insert a record into the logging table in 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.

    April 29, 2004 at 5:48 pm

    #504750

  • RE: Restore Question

    I've never had a problem with this either. Even when moving from one machine to another. Did they perhaps change their settings in QA and not realize it?




    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.

    April 29, 2004 at 5:41 pm

    #504749

  • RE: information_schema views

    Does the instance have a case sensitive default collation even though your database doesn't? I run Latin1_General_Bin as my default collation and the above query needs to be changed to...




    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.

    April 2, 2004 at 10:04 am

    #501641

  • RE: SET NOCOUNT ON

    Just out of curiosity are there any triggers that change the NOCOUNT behavior? I've had problems with this in the past where a trigger has played havoc with NOCOUNT settings.




    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.

    March 30, 2004 at 3:29 pm

    #501202

  • RE: Will stored proc rollback on error?

    If this is a very large table you could look into using the SET ROWCOUNT syntax and then loop through until you no longer delete records. Then in the loop...




    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.

    March 30, 2004 at 3:23 pm

    #501200

  • RE: Development IDE for SQL2K - suggestions?

    I started using Visual Studio for SQL Dev work about 6 years ago and now I don't use anything else. My reasoning is that no matter what job I had...




    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.

    March 30, 2004 at 3:08 pm

    #501196

  • RE: Backup Transaction Logs

    If your main question is how to shrink the log file you could run the Backup Log ... With Truncate_only and then immediately run Backup Database. Once you have done...




    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.

    March 30, 2004 at 3:00 pm

    #501192

  • RE: Restoring an SQLServer 2000 database - questions...

    I agree with Bill. It sounds like you used the RECOVERY switch and need to run the script Bill gave to get you out of the "Loading" state.

    I'm sure...




    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.

    March 30, 2004 at 2:54 pm

    #501187

Viewing 15 posts - 91 through 105 (of 498 total)